Loading…
Attending this event?
THE BEST IBM i & POWER SYSTEMS EDUCATION.When you come to POWERUp, you’ll be able to customize your experience. Choose from 300 sessions, covering over 20 areas of IT, when you plan your schedule. Visit the largest Expo of its kind and meet the experts behind the solutions. Attend social events to meet renowned speakers and peers alike. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?

Exhibitor Hall: https://www.expocad.com/host/fx/common/s24/exfx.html

Exhibitor Hall Map Here 
Simple
Expanded
Grid
By Venue
arrow_back View All Dates
Tuesday, May 21
 

8:00am CDT

180: Revving up SQL Performance with Indexes
EVALUATION
One of the most important things needed to improve SQL performance is to have the proper indexing over tables, especially as table grow in size. Indexes are so important that the database provides index advice for assistance. However, advice is no substitute for knowledge and proper understanding of indexes. As with all advice, it must be reviewed and good judgment applied on when to create them.

Learning Objectives:
1. Learn about the importance of indexes on SQL performance
2. Learn how to use ACS tools to process Db2 Index Advice
3. Learn a methodology for identifying and ordering the key definition for new indexes.
Speakers
avatar for Kent Milligan

Kent Milligan

Senior Db2 for i Consultant, IBM
Kent Milligan is a Senior Db2 for i Consultant in IBM Technology Expert Labs. Kent has over 25 years of experience as a Db2 for IBM i consultant and developer working out of the IBM Rochester lab. Prior to re-joining the Db2 for i Expert Labs practice in 2020, Kent spent 5 years... Read More →

Revving Up SQL Performance With Indexes pdf
Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Beginner
  • Audience Database engineers and performance analysts as well as SQL programmers trying to improve performance

8:00am CDT

272: Access MongoDB from IBM i
EVALUATION
MongoDB is a database / document management system which arose from the NoSQL movement to become a popular backend for web applications. While MongoDB is, in our opinion, no competition in the RDBMS space for IBM i Db2, Mongo is still fun and easy. You can use Seiden Community PHP+ and/or Python to access remote MongoDB installations from IBM i : we'll show you exactly how.

Learning Objectives:
1. Learn about MongoDB.
2. Learn to access remote MongoDB from IBM i PHP or Python.
3. Learn how to perform typical web application tasks using MongoDB and why you might wish to do so, or find yourself doing so.
Speakers
avatar for Jack Woehr

Jack Woehr

Senior Engineer, Absolute Performance, Inc.
Author of Ublu, an open source remote language for IBM i. A Quantum Computing enthusiast, Jack is an IBM Qiskit Advocate, 2021 IBM Champion, 2022 IBM Champion, 2023 IBM Champion, and 2024 IBM Champion.A consulting programmer with over 30 years' experience in open source specializing in open source based IBM i modernization... Read More →

AccessMongoDBfromIBMi pdf
Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level All
  • Audience Anyone interested in MongoDB, especially in the context of accessing remote MongoDB installations from IBM i.

8:00am CDT

386: IBM Power's Differentiated Memory Roadmap
EVALUATION
This session explores the historical importance of Power's memory architecture, reviews recent developments in Power's memory roadmap, and highlights the strengths of Power's memory architecture going forward versus developments in industry memory architectures.

Learning Objectives:
Speakers
avatar for Bill Starke

Bill Starke

Power Processor Chief Architect, IBM
William Starke is an IBM Distinguished Engineer and Chief Architect for Power microprocessors. Since graduating from Michigan Tech University, Bill has been employed by IBM for over 30 years in several roles, spanning mainframe and Power systems performance analysis, logic design... Read More →

2024 0521 PowerUP v2 shareable pdf
Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Hardware
  • Session Level All

8:00am CDT

108: Choosing the right HA/DR solution
EVALUATION
The High Availability and Disaster Recovery landscape is continually evolving with new technologies both on-premis and in the cloud dedicated to ensuring your business stays running. Navigating through these technologies requires and understanding of business needs, and outage protection goals.

Throughout this session we will discuss the types of outages, and the technologies available to protect against those types of outages in order to help you make decisions to map out your HA and DR journey. This session will give a brief overview of a number of technologies including: Db2 Mirror, Live Partition Mobility, Logical/Software based Replication, Full System Replication, and PowerHA technologies.

Learning Objectives:
1. Learn the importance of considering your recovery point objective and recovery time objective for different types of outages
2. Learn how different technologies can help achieve various RPO and RTO targets.
3. Learn how the technologies can be combined to form solutions with several examples of common solutions
Speakers
avatar for Brian Nordland

Brian Nordland

Director of Development, Fortra
In addition to his role as Director of Development for Power Development at Fortra, Brian Nordland serves as the technical product manager for PowerHA and Robot HA. Brian has spoken at events, webinars, and user groups—including COMMON—since 2014. He is a co-inventor on multiple... Read More →

Choosing the right HADR solution pdf
Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience
  • Session Level Beginner
  • Award BRONZE
  • Digital Badge HA/DR
  • Audience Those looking to implement or enhance their HA or DR plans for IBM i that want an overview of various hardware replication technologies

8:00am CDT

112: Integrated File System Security Principles and Practices
EVALUATION
Are you confused about IBM i Integrated File System security? You're not alone! Come to this session and learn the principles and best practices of securing your file systems. This session will cover more than just setting permissions (authority) on your objects. Other topics include virus scanning, controlling remote access, object audit, and more.

Learning Objectives:
- Understand the semantics of integrated file system security
- Learn other methods of securing beyond permissions including virus scanning, and more
- Learn ways to manage and improve integrated file system security
Speakers
avatar for Margaret Fenlon

Margaret Fenlon

Software Engineer, IBM
Margaret started working for IBM in 1983 on the S/36. From 1986-1994 she worked in various areas of what is now the IBM i including Authorization Management support of POSIX and the integrated file system. She worked on the port of SAP R/3 from 1994-1997. In 1998 Margaret joined the... Read More →

IntegratedfileSystemSecurityPrinciplesAndPractices 2024 pdf
Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  IFS
  • Session Level Intermediate
  • Audience IBM i system administrators and application developers who wish to learn more about integrated file system security. Most beneficial for those that have working knowledge of the IFS or have attended the introduction and/or advanced sessions.

8:00am CDT

229: IBM i 7.5 Plus Favorite Features
EVALUATION
The Development lab is continues to roll out new functions and features with every release and technology refresh. In this session we will review some of the key features that have been delivered over the past couple of releases. These are things that you should be aware of either for you to incorporate today, or to help you tomorrow.

Learning Objectives:
Speakers
avatar for Tim Rowe

Tim Rowe

Business Architect Application Development & Systems Management for IBM i, IBM
Tim Rowe is the Business Architect responsible for Application Development and Systems Management for the IBM i operating system. His responsibilities include helping to make sure that the IBM i has what is needed to be successful both today and into the future. He sends much of his... Read More →
avatar for Scott Forstie

Scott Forstie

Db2 for i Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry events... Read More →

1 IBM i 7.5 Plus our Faves pdf
Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  IT Strategy

8:00am CDT

341: Open Source: How to not mess it up
EVALUATION
Free open source software (FOSS) is "free as a puppy." We should know that the "free" indicates freedom, not zero cost!

Adoption of open source software also brings its share of responsibilities. Failure to properly care for your open source stack can be costly. Incorrect use can also be costly.

In this session, we will look at best practices surrounding the use of open source software, which involves proper management of user authorities, support, CVE mitigation, and more.

Learning Objectives:
Understand how to successfully deploy open source projects and avoid some of the "foot guns" that come with "free" software.
Speakers
avatar for Jesse Gorzinski

Jesse Gorzinski

Business Architect, IBM
Jesse Gorzinski works for the IBM i development lab in Rochester, MN. He is a Senior Business Architect and Senior Technical Staff Member (STSM) responsible for open source technologies on the platform. Jesse, who was doing RPG programming at the age of 18, is an expert on application... Read More →

OSS How to not mess it up v3 pdf
Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  IT Strategy
  • Session Level All
  • Audience IT managers, project managers, or developers

8:00am CDT

275: Kick the Old IDE Habit With Code for i
EVALUATION
SEU and PDM are no longer viable. Does RDi feel slow and clumsy? Or perhaps your manager won't pay for RDi, or won't let the team use it? VSCode with the Code for i plugin is an amazing solution, and Scott even prefers it over RDi. Why not learn how to get started?

Learning Objectives:
1. Learn how to set up VSCode with Code for i
2. Learn how to use it to connect to IBM i systems
3. Use it to edit, compile and read programs, including RPG.
Speakers
avatar for Scott Klement

Scott Klement

Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →

Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools

8:00am CDT

219: Modernization Case Study – Creating a Database Abstraction Layer
EVALUATION
By providing a layer of separation between your applications and your database, you have much more agility to respond to changing business requirements and you can reduce your maintenance burden at the same time. This case study will review three approaches that can be used to provide database abstraction and the strengths and weaknesses of each approach.

Learning Objectives:
1. Evaluate three different approaches to database abstraction and their benefits.
2. Walk step by step through the implementation of a Logical File database abstraction layer.
3. Review the reference architecture for a database I/O service program.
4. Best Practice design recommendations for new tables.
Speakers
avatar for Ray Everhart

Ray Everhart

Senior IBM i Analyst and X-Analysis Product Manager, Fresche
For over 30 years, Ray has helped companies understand, develop and manage their RPG, COBOL and CA 2E application environments. He also specializes in helping clients enhance and modernize their systems to meet evolving business demands and take advantage of digital transformation... Read More →

Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level All
  • Audience Developers

8:00am CDT

150: IBM i Security: What’s New for IBM i 7.4 and 7.5
EVALUATION
Security improvements continue to be high priority to help mitigate vulnerabilities. Come see the various security related features included with IBM i that you can use to help improve the health of your environment.

Learning Objectives:
Discuss new enhancements in IBM i 7.4 and 7.5 related to improved security by default, system values, password levels, TLS 1.3, Authority Collection, Digital Certificate Manager, SST Profiles, and more.
Speakers
avatar for Robert Andrews

Robert Andrews

Principal Security Consultant, IBM
Robert Andrews is a Principal Security Consultant, Senior Technical Staff Member (STSM), and the Team Lead for the IBM i Security and Authentication Technology Expert Labs team in Rochester, MN. He is an IBM certified Thought Leader and The Open Group certified Distinguished Technical... Read More →

WhatsNewIBMiSecurity7475 pdf
Tuesday May 21, 2024 8:00am - 9:00am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Beginner
  • Award GOLD
  • Audience System and security administrators

8:00am CDT

100: IBM i OS and Power System Upgrade Testing
EVALUATION
Focusing on the unique needs of IBM i environments we look at the testing needed for system and OS upgrades/migrations. From strategic test management and planning to risk management and resource allocation. Concepts covered include how to identify testing points, determine risk, and implement responsible quality assurance. Updated to include templates and planning examples.

Learning Objectives:
  1. Understanding testing strategies, tactics, and design.
  2. Determine risks to system quality.
  3. Aligning testing with risk exposure.
  4. When to use risk based testing, static testing, behavioral testing, or structural testing for best results.
Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Principal Architect for Quality Assurance on IBM i, Yvonne Enselman Professional Services
I am a Quality Assurance, Project Management, and Professional Services expert.Named IBM Champion 2024I have twenty-five years of experience in the IBM i industry starting in application development, transitioning through quality assurance, and into management. My passion has been... Read More →

Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience Audience: IT department personal who want to deliver solid testing for upgrades. Any system administrator who is concerned about the testing their system is subjected to. Consultants who are in the upgrade/hardware/admin sphere and want to enhance their testing offering. QA professionals who want understand what the technical team is testing and evaluating before hand off.

8:00am CDT

129: Elevate Your IBM i Game: Transforming Bad Habits into Best
EVALUATION
Best Practices is all about meeting IBM system compliance to achieve optimal results. Don’t let old myths or newly formed bad habits be the difference between success or a failure in service delivery. This session will examine V7R4/R5 System configurations, BRMS Backups, Disaster Recovery, and Security Management. Examine assumptions, technical gaps, blunders, and recommendations. Hear actual lessons learned so you do not make the same IBM i assumptions others have made. IT is not a game of chance

Learning Objectives:
Speakers
avatar for Richard Dolewski

Richard Dolewski

VP, Enterprise Solutions, Connectria
Richard is a recognized SME and award-winning industry speaker specializing in, Cloud Computing Architecture, Business Resiliency, Disaster Recovery Planning and Backup & Recovery Program Design. He leads organizations through the new era of technology, achieving the desired, successful... Read More →
JP

129 Elevate Your IBM i Game Transforming Bad Habits into Best PowerUp Dallas Final pdf
Tuesday May 21, 2024 8:00am - 9:00am CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Systems Management

9:15am CDT

170: Deploy, Administer, and Restrict IBM i ACS: Get and Deploy IBM i ACS
EVALUATION
Deploy, Administer, and Restrict IBM i ACS Use the best practices and tools to be the most effective System Administrator possible. This module will extend your knowledge of IBM i Access Client Solutions (IBM i ACS) to more effectively deploy, administer and restrict the best IBM i access and administration client available.

Part I: Get and Deploy IBM i ACS
Part II: Administer and Restrict IBM i ACS
Part III: Ask Me Anything

Learning Objectives:
1. Where and how to obtain IBM i ACS client 2. IBM i ACS Deployment Guide
Speakers
avatar for Wayne Bowers

Wayne Bowers

Software Engineer, IBM
Wayne Bowers has been with IBM since 1997, where he works with the IBM i Global Support Center in Rochester MN. He is an Advisory Software Engineer specializing in the support of the IBM i Access (aka Client Access) products, Console, the TCP Telnet communications server, and the... Read More →

ACS GetDeploy PowerUp24 pdf
Tuesday May 21, 2024 9:15am - 10:15am CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Client Connectivity
  • Session Level Intermediate
  • Digital Badge ACS
  • Audience IBM i IT responsible for Deploying and Administering IBM i ACS.

9:15am CDT

327: Db2 for i Inside of VS Code
EVALUATION
VS Code is really built with developers in mind. IBM has been building a neat Visual Studio Code extensions that makes accessing and working with the database much simpler for developers. Not only can VS Code be used for writing in many different languages, but now it has great tools for working with Db2 for i. You might see exporting data, working with examples, browsing your schemas, or even managing multiple database configurations. There's a lot to see!

Learning Objectives:
* How to connect to Db2 for i thru VS Code
* Using content assist for SQL
* How Visual Explain works in VS Code
* Understanding the power of Notebooks
Speakers
avatar for Ryan Moeller

Ryan Moeller

Software Engineer, IBM
Ryan Moeller is a software engineer working on Db2 for i, specifically on the SQL Query Engine (SQE) team. He joined the team in the Rochester, MN development lab in 2020. Ryan specializes in SQL, database development, and query performance analysis.

VSCode for i Database Extension pdf
Tuesday May 21, 2024 9:15am - 10:15am CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Database

9:15am CDT

190: How Journaling Works with DB2
EVALUATION
From its humble beginning journaling local database changes to physical files on the System/38, IBM i journaling technology has evolved to include SQL tables, the integrated file system (IFS), and even remote journaling. In fact, many IT teams have been using IBM i journaling technology for audits, replication, problem determination, removal of bad updates, and high availability for years!

This session will take you through the process of how journal works against data base files and IFS. You will learn about the various commands for creating and working with journals and journal entries.

You’ll learn:
• How to start journaling of PF/SQL/IFS
• Why before and after images are important
• How to use remove journal changes
• What remote journaling is

Learning Objectives:
You’ll learn:
• How to start journaling of PF/SQL/IFS
• Why before and after images are important
• How to use remove journal changes
• What remote journaling is
Speakers
avatar for Tom Huntington

Tom Huntington

EVP of Technical Solutions, Fortra
Tom Huntington is Executive Vice President of Technical Solutions at Fortra, and has been with the company for over 35 years. He helps manage the worldwide Fortra software engineer team that works to integrate and promote our automation and security solutions to partners and customers... Read More →

Common PowerUp2024 Journaling DB2 Handouts pdf
Tuesday May 21, 2024 9:15am - 10:15am CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience
  • Session Level Beginner
  • Digital Badge HA/DR
  • Audience DB administrators and developers

9:15am CDT

295: BRMS Beyond the Basics
EVALUATION
This session will discuss some of the advanced topics in using BRMS for your back up and recovery. Featured topics will be tape and library management, BRMS Networking, control group and list controls, BRMS Policies and how they affect the overall operation of BRMS, and using SQL to manage BRMS. Recovering from a BRMS back up can be extremely easy, but it can also present some opportunities for trouble. This session will discuss some of the landmines in a BRMS recovery and how to avoid them.

Learning Objectives:
1. Ultilize control groups and lists to fully customize BRMS backups
2. Set up and manage BRMS Networking
3. Learn how to make a BRMS recovery simple and as easy as possible
4. Using SQL services to manage BRMS and reports
Speakers
avatar for Sarah Jacob

Sarah Jacob

VP of Customer Experience, Agile Technology Architects
Sarah Jacob is the Vice President of Customer Experience at Agile Technology Architects. She is a Subject Matter Expert in Power Systems Administration and a volunteer for COMMON. Sarah specializes in Backup and Recovery planning and recovery testing. Additionally, she acts as primary... Read More →

Tuesday May 21, 2024 9:15am - 10:15am CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience
  • Session Level All
  • Digital Badge HA/DR
  • Audience BRMS users who know the basics but want to expand beyond that.

9:15am CDT

377: The IBM i Box of Chocolates - with Q&A
EVALUATION
You know what Forrest Gump's mother said about a box of chocolates. Well, in this presentation by Steve Will, IBM i CTO and Chief Architect, you never know what you're going to get - but we're pretty sure you're going to like every piece!
Steve will spend a few minutes talking about a few morsels from the IBM i box of chocolates – including the state of the IBM i operating system, its plans, its technology and its community – and of course, AI!
And then he'll open the floor for questions.

Learning Objectives:
1. Current hot topics
Speakers
avatar for Steve Will

Steve Will

IBM i CTO & Chief Architect, IBM
Steve is the CTO and Chief Architect for the IBM i Operating System. Spending the past fourteen years of his IBM career in this position, he has become an award-winning speaker, author of the influential blog "You and i," (https://bit.ly/You-and-i-blog) and is one of the most sought-after voices at customer briefings and events. Steve has worked on IBM i and its predecessors since before the creation of the AS/400, and is currently responsible for setting the strategy of the IBM i operating system, as well as deciding which enhancements will be implemented. In his role, he talks to clients and pa... Read More →

IBM i Box of Chocolates 2024 POWERUp Preview pdf
Tuesday May 21, 2024 9:15am - 10:15am CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  IT Strategy

9:15am CDT

182: Test Analysis and Design Focusing on Planning, Cases, and Conditions
EVALUATION
This session is a deep dive into the creation of tests:
• Covering scope, approach, resources, schedule of activities, features, tasks.
• Determine entry and exit criteria and the rational for what is decided upon as well as establishing bi-directional functionality.
• Organize input values, execution preconditions, expected results, and post conditions into test cases.
• Isolate what items or components of the system can be verified by a case.
• Write cases that are repeatable, verifiable, and traceable back to the requirements, quality risk, etc.
• Transform the above into executable tests that scale to all levels of testing infrastructure

Learning Objectives:
1) Take foundational or informal knowledge of testing and improve it procedurally for optimal results.
2) Organize the components of proper testing into a viable plan
Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Principal Architect for Quality Assurance on IBM i, Yvonne Enselman Professional Services
I am a Quality Assurance, Project Management, and Professional Services expert.Named IBM Champion 2024I have twenty-five years of experience in the IBM i industry starting in application development, transitioning through quality assurance, and into management. My passion has been... Read More →

Tuesday May 21, 2024 9:15am - 10:15am CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Program Testing
  • Session Level All
  • Audience Anyone who wants to learn about testing and quality assurance

9:15am CDT

233: Moving into Git (for RPGLE, COBOL, and more)
EVALUATION
The future of writing ILE languages is with git. Whether you've not heard of git, or you're an expert, we'll cover the basic concepts of git, how to get your ILE source code into git, how to develop and compile code from repositories, and many other concepts.

Learning Objectives:
1. Learn what tools are available to move source code
2. Understand where your source code repository can live
3. Get the gist on general git concepts
Speakers
avatar for Liam Allan

Liam Allan

Software Advocate, IBM
I am a developer and open-source advocate. Ask me about Node.js, VS Code, app deployment and CICD :) 

Tuesday May 21, 2024 9:15am - 10:15am CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools

9:15am CDT

384: Intro to Modern Application Integration via API
EVALUATION
We no longer live in a world where we have one system of record that is used for all business functions. IT is an everchanging blend of tools, applications, and platforms. Integration is top of mind for most businesses. If there is one common way to link all these systems, it is an API layer. Your IBM i should speak the language of APIs, both consuming and hosting. In this session, let’s look at the big picture with regards to APIs and IBM i.

Learning Objectives:
• Importance of APIs in modern architecture
• Common API integration needs
• Replacing legacy interfaces_
• Elements of a successful API implementation
Speakers
avatar for Brian May

Brian May

Vice President of Product Management, Profound Logic
Professional IT Leader, Speaker and WriterSpecialties:Team Building, Development and RetentionTechnical SalesSolutions ArchitectureSoftware DevelopmentEnterprise Systems Manufacturing ProcessesApparel IndustryAccounting Principles

Modern Application Integration via API pdf
Tuesday May 21, 2024 9:15am - 10:15am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programming - General
  • Session Level All
  • Audience Developers interfacing with partners, customers, or internal applications

9:15am CDT

337: Breaches, Ransomware and Recovery, Oh My!
EVALUATION
Your organization has been breached. Ransomware has run rampant throughout your organization. Have you planned for this eventuality? Does your incident response plan include IBM i? During this session will discuss the steps you’ll want to take now to reduce risk to IBM i and to ensure that you can recover should your system be affected. Real-life incidents and scenarios will be discussed so that you can learn from others’ mistakes.

Learning Objectives:
1 Understand the steps you can take to secure your system to reduce the risk of data loss or being infected with ransomware
2. Learn about the backup technologies that will support both disaster recovery as well as recovery from ransomware
Speakers
avatar for Richard Dolewski

Richard Dolewski

VP, Enterprise Solutions, Connectria
Richard is a recognized SME and award-winning industry speaker specializing in, Cloud Computing Architecture, Business Resiliency, Disaster Recovery Planning and Backup & Recovery Program Design. He leads organizations through the new era of technology, achieving the desired, successful... Read More →
avatar for Carol Woodbury

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco Systems
With over 30 years' experience in the area of IT security, Carol is known world-wide as an expert in the area of computer security. During her career, Carol has architected security solutions for Fortune 100 companies as well as small and medium-sized organizations. Carol is passionate... Read More →

337 Breaches Ransomware Recovery Oh My PowerUp Dallas Final pdf
Tuesday May 21, 2024 9:15am - 10:15am CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Security

9:15am CDT

166: Understand your IBM i Performance Signature
EVALUATION
IBM i often runs well with little or no focus on the performance of the system. But what if something unexpected does occur? If you understand the performance signature of your system when it is running well, it becomes much easier to identify problems if something goes wrong. This session will show you how to use the Performance Data Investigator to understand your day-to-day performance signature, as well as Graph History to understand long-term trends over weeks, months, and years.

Learning Objectives:
1. Learn how to interpret performance charts in PDI
2. Understand what wait metrics mean
3. Learn how to review historical performance data
Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
Dawn has been involved with COMMON for over 20 years and has been a consistent volunteer since 2008. She's been a member of the strategic education team, a subject matter expert, and a speaker. Now, as President of COMMON, she's focused on leading COMMON as the industry leader of... Read More →

Understand Your IBM i Performance Signature POWERUp2024 pdf
Tuesday May 21, 2024 9:15am - 10:15am CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Systems Management

9:15am CDT

397: Power10 I/O Offerings Update
EVALUATION
We will look at the IO offering portfolio including ethernet, fibre channel, NVMe, storage and IO expansion. We will highlight the latest updates and interesting capabilities along the way.
Speakers
avatar for John Folkerts

John Folkerts

Power Systems IO Product Management, IBM
John Folkerts has recently taken on the role of Power Systems IO Product Manager.  John is responsible for direct attach storage, network adapters, fibre channel adapters, IO expansion and a variety of other areas.  His previous roles within IBM included hardware development of... Read More →

IO Offering COMMON POWERUp 2024 V2 pdf
Tuesday May 21, 2024 9:15am - 10:15am CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Virtualization
  • Session Level All

9:15am CDT

195: No Limits Modern Excel Reports Using RPG-The Whole Story
EVALUATION
Our businesses often want reports delivered in Excel format. While there are several ways to create these spreadsheets using RPG, they all have some drawbacks. Writing to the current XLSX format for Excel spreadsheets may seem a formidable challenge, but we will see that the prospect of success is better than it might seem at first. And we will see how to use tools such as CGIDEV2 to accomplish the task of creating these modern, highly-functional spreadsheets.

The first part of this session looks at what you need to get started with this approach. It also looks at the advantages of using CGIDEV2 to create Excel files.

The second part digs deeper into adding more features of Excel to your spreadsheets, optimization, and troubleshooting - what to do with that "unreadable content" message!

Learning Objectives:
1. Understand the internal structure of modern Excel (XLSX) files
2. Begin to get hold of the workings of CGIDEV2 and XML
3. Understand how to design and implement an Excel (XLSX) application
4. Get some idea of just what CAN be done to make even more useful spreadsheets
5. Learn what to do when...
Speakers
avatar for Vern Hamberg

Vern Hamberg

Senior Software Engineer, Ecolab, Pest Elimination
Vern has worked on IBM midrange systems for over 30 years, beginning with the System/38 and AS/400. At present he is a senior software engineer for the Pest Elimination division of Ecolab. He serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for... Read More →

OPEN LAB Fast Modern Excel (XLSX) Workbook Creation Using RPG pdf
OPEN LAB Fast Modern Excel (XLSX) Workbook Creation Using RPG docx
Shared Strings Table Resources zip
DIY XLSX Lab setup zip
No Limits Modern Excel Reports Using RPG The Whole Story 2up pdf
Tuesday May 21, 2024 9:15am - 11:30am CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level Intermediate
  • Audience Developers (and their managers) who are asked to create spreadsheets will see a way to get high functionality and good run-time performance.

10:30am CDT

169: Deploy, Administer, and Restrict IBM i ACS: Administer and Restrict IBM i ACS
EVALUATION
Deploy, Administer, and Restrict IBM i ACS Use the best practices and tools to be the most effective System Administrator possible. This module will extend your knowledge of IBM i Access Client Solutions (IBM i ACS) to more effectively deploy, administer and restrict the best IBM i access and administration client available.

Learning Objectives:
1) How to use items like AcsConfig.properties, Restrictions, Function Usage to Administer IBM i Access Client Solutions
Speakers
avatar for Wayne Bowers

Wayne Bowers

Software Engineer, IBM
Wayne Bowers has been with IBM since 1997, where he works with the IBM i Global Support Center in Rochester MN. He is an Advisory Software Engineer specializing in the support of the IBM i Access (aka Client Access) products, Console, the TCP Telnet communications server, and the... Read More →

ACS AdminRestrict PowerUp24 pdf
Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Client Connectivity
  • Session Level Intermediate
  • Digital Badge ACS
  • Audience IBM i IT responsible for Deploying and Administering IBM i ACS.

10:30am CDT

104: Consuming JSON Documents and Web Services with SQL (SQL and JSON - Part 2)
EVALUATION
JSON becomes more and more important especially in RESTful web services. The use of XML declines in favor of JSON. With the JSON_TABLE table function JSON documents can be parsed, converted into a relational representation and data picked specifically out. Additional scalar functions allow SQL to directly access JSON documents located within the IFS (Integrated File System) or in source physical file members. Last but not least IBM provides SQL functions for getting access to web services. In composition with the JSON_TABLE function the JSON answers returned by web services can be consumed.

Learning Objectives:
Learn how JSON documents located in either the IFS or a column in a table or JSON answers from web services can be parsed with the JSON_TABLE table function, converted into a relational representation and data specifically selected. You’ll also get an overview over the new http-functions and how to use them for getting access to web services.
Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →

POWERUp Consuming JSON Birgitta Hauser pdf
POWERUp Consuming JSON Birgitta Hauser sql
Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Advanced
  • Award BRONZE
  • Audience Developers and Users who are experienced in SQL Queries and need to process JSON documents located in either SQL tables or the IFS or JSON answers returned by web services or simply want to enhance their SQL know-how.

10:30am CDT

262: Accelerate Your SQL Queries with SMP
EVALUATION
With Symmetric Multiprocessing (SMP) now available as a no-charge feature in IBM i, you've gained access to a powerful feature that can significantly improve the speed of query execution. However, SMP must be approached carefully, as improper usage may produce lackluster results. This session will cover the inner workings of SMP, when to utilize SMP, and tools for controlling system-wide SMP usage.

Learning Objectives:
1.) Understand how the SQL Query Engine utilizes SMP to accelerate query execution
2.) Understand what workloads benefit most from SMP
3.) Understand the controls available to the Database Engineer to control SMP
Speakers
avatar for Ryan Moeller

Ryan Moeller

Software Engineer, IBM
Ryan Moeller is a software engineer working on Db2 for i, specifically on the SQL Query Engine (SQE) team. He joined the team in the Rochester, MN development lab in 2020. Ryan specializes in SQL, database development, and query performance analysis.

Accelerate Your SQL Queries with SMP pdf
Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Award GOLD
  • Audience Database engineers, programmers, application developers

10:30am CDT

264: Partitioned Table Functionality
EVALUATION
Did you know that partitioned table functionality is now included in IBM I 7.5? Attend and learn what partitioned tables are and the benefits of using them to organize your data. Q&A will follow a live demo.

Learning Objectives:
participants will be able to use partition tables in their own IBM i shops.
Speakers
avatar for Sven Jansson

Sven Jansson

Senior developer, Apper Systems AB
I have worked on the IBM i platform since 1995. My technical roles include developer, analyst, database specialist, application security, and communications. I also worked on IBMz for a few years, and I serve on the COMMON Sweden board. I'm a curious person who always wants to learn... Read More →

Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Database

10:30am CDT

168: Become a Superhero to your CIO: A Day in the Life of a CIO
EVALUATION
In today's hyper-competitive world, we're all striving to be the best employees we can be. We want to impress our boss, finish that big project on time and under budget, and earn that big promotion with a hefty raise. If you work in IT, it's very likely you report - directly or indirectly - to your company's CIO, or perhaps CTO. How can we best enhance and leverage that relationship to support your company's IT initiatives, and advance your career?

The first step is to understand your CIO's role. The role of the CIO or CTO may seem mysterious and overwhelming at first, but it's critical for all IT employees to understand the big picture in order to better support your boss, and become a superhero to your CIO!

Learning Objectives:
We'll cover:
- What is your CIO responsible for? We'll discuss the practical elements as well as the strategic decisions of the job
- What does a day in the life of your CIO look like?
- What are the differences between a CIO and CTO?
- Who does your CIO communicate with? Who is he or she responsible to, and for what?
- What pressures does your CIO deal with every day, and from whom?
Speakers
avatar for Steve Wolk

Steve Wolk

CTO, PC Richard & Son
Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →

A Day in the Life of a CIO Steven Wolk pdf
Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Developing Business Skills
  • Session Level All
  • Digital Badge IT Strategy
  • Audience All IT professionals who aspire to become a superhero to their CIO, or perhaps become a CIO or CTO themselves one day!

10:30am CDT

152: Programming Standards and Guidelines
EVALUATION
We have all unfortunately seen really bad code or really bad practices. Have you ever wanted to take that code and throw it against the wall and start over? This session will give you the steps and guidelines that will help you start the discussion so you and your colleagues can implement standards and guidelines and start the process of cleaning up your code or the code you have inherited.

Learning Objectives:
1. We will look over various different recommended programming standards and guidelines.
2. we will look at bad code vs new code and make recommendations that you can take back and implement in your shop.
3. We will learn why its important to have standards and guidelines and how you can start the standards discussions at your shop.
Speakers
avatar for Marina Schwenk

Marina Schwenk

Innovative Software Solutions
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina worked for over nine years as a Senior Programmer Analyst/IBM i admin at Everbrite... Read More →

Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Programming - General
  • Session Level Beginner
  • Audience Developers

10:30am CDT

387: Basics of System Admin for Programmers
EVALUATION
Are you a programmer who is now responsible for the administration of your IBM i system? Do you know what you need to successfully manage the system? What commands do I need to know? In this session, we will cover the basics of System Administration that you need to know to manage your IBM i. Learn what you need to know to do the daily care and feeding of your system.

Learning Objectives:
1) Understand how to check your system messages to know that everything is ok.
2) Make sure that you are saving the right stuff.
3) Basics of security
4) What are PTFs, and how to manage PTFs
Speakers
avatar for Pete Massiello

Pete Massiello

IBM i Advisor, Massiello Holding Corp.
Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions through out his career. He is the President of iTech Solutions Group, an IBM Premier Business Partner delivering... Read More →

Basics of System Admin for Programmers pdf
Tuesday May 21, 2024 10:30am - 11:30am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programming - General
  • Session Level Beginner
  • Audience Programmers who are now responsible for the administration of their systems.

10:30am CDT

350: Maximizing the benefits of embedding SQL in your RPG code
EVALUATION
Many people are now integrating SQL into RPG programs & procedures. Simon will give practical examples of how you can optimize the performance of your statements & simply diagnose the feedback returned from Db2. Will include mentions of how using Views enhances this optimization process.

Learning Objectives:
1. SQL I/O methods to get data from the database faster
2. Better method to capture errors, or what happened with your SQL statements
Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for eleven years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. His work has led him to be recognized by IBM as an IBM Champion for Power and IBM i Community Advocate. He is a subject matter expert for COMMON North America and... Read More →

Simon Hutchinson 350 Maximizing the benefits of embedding SQL in your RPG code pdf
Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level Intermediate
  • Audience Any RPG programmer looking to modernize their skills by using embedded SQL within in their work in a manner that will increase the performance of their programs & procedures.

10:30am CDT

324: Best Practices for the IBM i Security Administrator
EVALUATION
As an IBM i System Administrator, you know you need to be checking IBM i Security settings but aren’t sure which ones or how often. This session solves that mystery. During this session Carol will provide you with a checklist of the areas of the operating system that you’ll want to be checking on a regular basis as well as explain why it’s important to do these checks. She will also discuss the risks of not maintaining these settings. Sample SQL will be provided for you to use in your workplace!

Learning Objectives:
Speakers
avatar for Carol Woodbury

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco Systems
With over 30 years' experience in the area of IT security, Carol is known world-wide as an expert in the area of computer security. During her career, Carol has architected security solutions for Fortune 100 companies as well as small and medium-sized organizations. Carol is passionate... Read More →

Best Practices for the IBM i Security Administrator 2024 zip
Tuesday May 21, 2024 10:30am - 11:30am CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Security

10:30am CDT

117: Managing IBM i PTFs
EVALUATION
What are PTFs? Why do I need them?  How do I get them? Which ones do I need? Does my technology really need a refresh? In this session we will describe PTFs, Cumultative PTFs, and other PTF Groups. We'll discuss how to find out what you have, how to get them, and how to put them in place. We'll help you determine what PTF strategy is the one for you and your system.

Learning Objectives:
1. What PTFs, and PTF Groups are and why you need them.
2. How to get PTFs and load them onto IBM i.
3. The use of Virtual Image Catalogs and Virtual DVD drives to save time and problems in the PTF process.
4. How to determine which PTFs you need for your system.
Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Cloud and Datacenter Engineer, IBM Champion, Service Express Inc.
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction In 1988.After spending many years as a developer Larry began working on communications, networking, and systems management tasks. Years of... Read More →

Managing IBM i Fix Information [PTFs} pdf
Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Award SILVER
  • Audience This session is for you if you are the person in charge of administering IBM i.

10:30am CDT

372: Accessing the IBM i with Rest
EVALUATION
Why not use Rest for all connections to the IBM i ? With the new Remote System Explorer, you can establish a secure connection with any IBMi, and request and interact with the IBM i using only Rest as the method. The RSE support allows custom request (CL, SQL) as well as some predefined actions leveraging only the Rest protocol. We will leverage Live demos to show this support in action to help you understand the possibilities.


Speakers
avatar for Tim Rowe

Tim Rowe

Business Architect Application Development & Systems Management for IBM i, IBM
Tim Rowe is the Business Architect responsible for Application Development and Systems Management for the IBM i operating system. His responsibilities include helping to make sure that the IBM i has what is needed to be successful both today and into the future. He sends much of his... Read More →

Access the IBM i with Rest pdf
Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level All

10:30am CDT

Expo Open
Lunch in Expo from 12PM-1PM
Tuesday May 21, 2024 10:30am - 1:30pm CDT
Exhibit Hall A, First Floor 1508 Houston St, Fort Worth, TX 76102

12:00pm CDT

Lunch in Expo
Tuesday May 21, 2024 12:00pm - 1:00pm CDT
Exhibit Hall A, First Floor 1508 Houston St, Fort Worth, TX 76102

1:30pm CDT

416: What Does Your Job Look Like in 2030? A Vision of IBM i Work in the Future
EVALUATION
Within 60 days of its release, ChatGPT hit 100 million users in 2022, a feat it took TikTok 9 months to achieve. According to Deloitte, “64% of CEOs say they’re facing significant pressure from investors, creditors, and lenders to speed the adoption of generative AI”. This sudden ramp up of genAI, coupled with macro trends such as hybrid work are drastically changing the model of work we all are accustomed to.

What does this mean for IBM® i and for you? In this session, Puneet Kohli – COMMON board member and President of the Application Modernization business unit at Rocket Software, will discuss:
  • The roles of IBM i admin and IBM i developer and how they change over the next 5 years 
  • What opportunities this will present for you 
  • How you can set yourself up for success in 2030 and beyond 
Speakers
avatar for Puneet Kohli

Puneet Kohli

President of Application Modernization Business Unit, Rocket Software
Puneet Kohli is the President of Application Modernization BU at Rocket Software. Puneet has two decades of experience managing all facets of engineering for enterprise software. Puneet has deep knowledge of Identity and access management, governance risk & compliance, Devops, hybrid... Read More →

Tuesday May 21, 2024 1:30pm - 2:30pm CDT
Ballroom B, 2nd Floor 1508 Houston St, Fort Worth, TX 76102
  IT Strategy
  • Session Level All

2:45pm CDT

138: Using SQL to Overcome Challenges when Consuming XML (Case Study)
EVALUATION
In this new world of mobile data collection by our field specialists, we ran head-on into special characters as well as emojis. This case study tells the tale of overcoming the hurdles we were stumbling over to deal with them.

Learning Objectives:
1. Learn what issues can be raised when using mobile devices to collect information from the field
2. Learn how XML support in Db2 for i was used to resolve these issues
Speakers
avatar for Vern Hamberg

Vern Hamberg

Senior Software Engineer, Ecolab, Pest Elimination
Vern has worked on IBM midrange systems for over 30 years, beginning with the System/38 and AS/400. At present he is a senior software engineer for the Pest Elimination division of Ecolab. He serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for... Read More →

Using SQL to Overcome Challenges When Consuming XML screenshots 2up pdf
Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level All
  • Audience Developers who need to process XML files and web services and others who need to know what can be done with XML support in SQL for IBM i

2:45pm CDT

140: OLAP (Online Analytical Processing) Functions – Much More Than Running Numbers!
EVALUATION
The first OLAP Functions were already introduced with Release 6.1, for building running numbers and ranks, in a specific sequence and even with the ability to restart numbering at a predefined level. At release 7.3 a bunch of additional OLAP functions and enhancements for existing OLAP functions are introduced. With these enhancements it is possible to easily build running totals or averages with or without level breaks. Data cannot only be accumulated over all rows, but also within a specific range. It is easy to access and compare the first, previous, next or last occurrence of the data within a partition. This session will give you an overview over the available OLAP functions and how they can be exploited.

Learning Objectives:
In this session you will learn which OLAP functions are available and how they can be used for and how they can be exploited especially for statistical reports.
Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →

POWERUp 2024 OLAP Specifications Birgitta Hauser pdf
POWERUp 2024 OLAP Specifications Birgitta Hauser sql
Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Advanced
  • Audience Manager, Programmers, Database Administrators and Engineers who need to generate and analyze complex statistics or everybody who is just interested in what is possible with OLAP functions.

2:45pm CDT

304: Run Away Queries Got You Down?
EVALUATION
Having negative performance impacts from query tools like Query/400, QMF, Showcase, Tableau and others because of the "query from heck" eating up system resources? Is your system open to security exposures from wide-open ODBC type connections? This session will cover options including using the new-ish Db2 Query Supervisor to control and/or audit long-running queries.

Learning Objectives:
1. Learn about the Db2 Supervisor to control and/or audit long running queries.
2. Gain insight into the tools you can use to monitor, tune, and prune queries.
Speakers
avatar for John Westcott

John Westcott

Db2 for i Consultant and Team Lead, IBM
John Westcott is the Db2 for i Team Lead in IBM Technology Expert Labs. John is highyly skilled in SQL, RPG, Data Analytics, Rest API, and both database and application modernization. John has over 35 years of experience on IBM i and it's past family of names. John has a storied career... Read More →

304 Run Away Queries Got You Down pdf
Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Anyone concened with managing system performance

2:45pm CDT

279: IBM HA/DR Solutions for IBM i
EVALUATION
The IBM i HA/DR portfolio covers the spectrum from storage-based solutions to IP based Geographic Mirroring for both on premise and/or in PowerVS. The solution portfolio enables automated fail-over, provides off-line backups and ransomware protection while greatly reducing both CAPX and OPEX compared to the legacy logical replication tools. We’ll cover the options, how they work and how you should position them as well as the latest enhancements. We’ll also discuss Pools 2.0, the CBU and migrating to PowerHA 7.5 from a previous release, GRS in PowerVS and upcoming roadmap.

Learning Objectives:
1. for current PowerHA/FSR/VM Recovery Manager customers, learn what's new and what's coming, on premise and in PowerVS
2. for IT Admins and business partners relatively new to hardware based based HA/DR, learn the basics, what are the outcomes expected from each approach, how does this solution portfolio compare to legacy software replication tools
3. On premise verses PowerVS or Hybrid
4. Be able to make the case to your management on the how and why you want to do this.
Speakers
avatar for Steven Finnes

Steven Finnes

Product Manager, IBM
Steve has spent several years in IBM with positions spanning basic research to product development, product offering and marketing. He is the product offering manager for IBM Power Systems with responsibility for PowerHA for AIX, PowerHA for IBM i and the CBU.

IBM I HADR PowerUp 2024 pdf
Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience

2:45pm CDT

133: The Ninja Guide to Building Teams and Creating Engagement
EVALUATION
Sure, Ninjas are cool, and they're fun to talk about. And more importantly, there's a leadership lesson there... Ninjas are always 100% ENGAGED! They equate their personal success with the success of their team, and of their mission. How productive would your teams be if they were always completely engaged, like Ninjas? Whether you're a leader looking to learn the secrets behind building strong teams and keeping them engaged, or a team member who wants to better understand team dynamics, you'll find this session illuminating.

Learning Objectives:
During this session you'll learn:
* Hiring tips to ensure you get the people you need on your team (and to communicate better with them)
* Learn to interview candidates like a pro (or to ace your next interview)
* Techniques to build your bench by creating a reserve of good will
* How to keep your people motivated (and yourself!)
* Methods to align your team's success (as well as your own) with that of your organization

By the end of this session you'll have the tools you need to build a team of the best and brightest, and keep them as engaged as... Ninjas!
Speakers
avatar for Steve Wolk

Steve Wolk

CTO, PC Richard & Son
Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →

The Ninja Guide To Building Teams And Creating Engagement Steven Wolk pdf
Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  IT Leadership and Management
  • Session Level All
  • Award SILVER
  • Audience Everyone who leads other people - or works as part of a team - will benefit from this session!

2:45pm CDT

176: Service Programs and Unit Testing – The Perfect Pair
EVALUATION
Do you have monolithic programs that you have to start breaking up into manageable pieces? Have you been tasked to start unit testing and don’t know where to start? This session is meant for you.

Learning Objectives:
We will work through the benefits to modernizing your code and why you want to adopt unit testing.
We will work through breaking apart monolithic programs and how to write their respective unit tests.
We will discuss some best practices in unit testing and how you can take some of those best practices and apply them to your everyday development processes.
Speakers
avatar for Marina Schwenk

Marina Schwenk

Innovative Software Solutions
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina worked for over nine years as a Senior Programmer Analyst/IBM i admin at Everbrite... Read More →

Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Program Testing
  • Session Level Intermediate
  • Audience Application Developers, testers

2:45pm CDT

153: Overloading in RPG
EVALUATION
One of the coolest new features in ILE RPG is the ability to overload your prototypes! With overloading, you can accept differing parameter types while keeping the same routine name. Overloading can be used with programs, but the biggest value comes when using it with subprocedures.

Learning Objectives:
- What is overloading? Why use it?
- Technical details of parameters, candidates, etc
- Full examples you can use yourself
Speakers
avatar for Scott Klement

Scott Klement

Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →

Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG

2:45pm CDT

368: How to Leverage Existing IBM® i Assets to Adhere to Modern Design Systems
EVALUATION
You’ve been asked to create nice web user interfaces for an application. You could do a 1:1 replacement of each screen—a tiresome but doable project. But, if you need to adhere to modern design systems like Google Material Design or IBM Carbon, your efforts, no matter how valiant, won’t cut it for your users. Also, what happens when users start asking for better workflows or customization?

In this session, we will discuss:
o How you can take assets you already have—like display files—and smartly approach your web UX projects
o How you can collect each screen, uniquely identify them, and then build the UI
o How you can keep the green screen application and the new UI in sync to handle changes dynamically
Speakers
avatar for Nikesh Zalte

Nikesh Zalte

Product Manager, Rocket Software

Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Programming - UI
  • Session Level All

2:45pm CDT

300: Audit Journaling with Navigator for i
EVALUATION
Understand how Navigator for i can make ease the use of audit journaling on the IBM i. Learn how Navigator simplifies configuring auditing to just a few button clicks. See how Navigator can make consuming and analyzing audit entries easier. Learn about what is planned to improve the performance of analyzing audit entries.

Learning Objectives:
1. Understand how to configure an IBM i for auditing
2. Understand how to analyze the generated audit entries
3. Learn how to maximize the performance of analyzing audit entries
Speakers
avatar for Ann Wilkerson

Ann Wilkerson

Software Developer, IBM
Ann Wilkerson is the technical team lead for Navigator for i and a developer for IBM i Services.

Audit Journaling with Navigator for i pdf
Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Beginner
  • Audience System administrators responsible for configuring auditing and for reporting on audit entry data

2:45pm CDT

307: Zero Trust Security for IBM i
EVALUATION
While Zero Trust is still one of the strongest trends driving the cyber security industry, there remains much buzzword confusion around the topic. No one product or solution can get an enterprise to Zero Trust. It is a security methodology, not a product.

Learning Objectives:
• A basic introduction to Zero Trust for the larger enterprise
• The unique opportunities within the IBM i for implementing the Zero Trust framework
• How to integrate your IBM i strategy with your organization’s larger Zero Trust initiative.
 • Best Practices for implementing Zero Trust on the IBM i
Speakers
avatar for Gavriel Meir-Levi

Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level All
  • Audience Administrators responsible for IBM i security

2:45pm CDT

162: Where to Start with Open Source Package Management
EVALUATION
As more and more development teams embrace Open Source technologies on the IBM i OS it will be important that Systems Administrators know the basics of managing these packages on the IBM i OS. This session will predominantly look at the Open Source Package Management capabilities included with IBM i Access Client Solutions as the go to environment for those who are not themselves using the Open Source packages.

Learning Objectives:
As a Systems Administrator become familiar with Open Source Package Management on the IBM i OS.
Speakers
avatar for Wayne Bowers

Wayne Bowers

Software Engineer, IBM
Wayne Bowers has been with IBM since 1997, where he works with the IBM i Global Support Center in Rochester MN. He is an Advisory Software Engineer specializing in the support of the IBM i Access (aka Client Access) products, Console, the TCP Telnet communications server, and the... Read More →

OSPM Start PowerUp24 pdf
Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience IBM i System Administrators who need to manage making Open Source technology packages avaialble on the IBM i.

2:45pm CDT

119: Selecting Your Power Virtualization Environment
EVALUATION
When virtualizing IBM POWER Systems you have two primary choices for the hosting environment, VIOS and IBM i. Each of these offers strengths and each has weaknesses. In this session we'll go over more than 35 comparison points putting the two hosting choices side by side. Well cover technical capabilities as well as usability and visual items. We'll look at costs and requirements for each host.

Come and select your choice for a hosting partition or confirm that you've gone down the right track.

Learning Objectives:
What requirements would lead you to select VIOS as your hosting environment
What requirements would lead you to select IBM i as your hosting environment
What are the costs or need-to-knows for each of the two hosts.
Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Cloud and Datacenter Engineer, IBM Champion, Service Express Inc.
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction In 1988.After spending many years as a developer Larry began working on communications, networking, and systems management tasks. Years of... Read More →

Slecting your Power Hosting Environment pdf
Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Virtualization
  • Session Level Intermediate
  • Audience Any IBM i system administrator, especially those with virtualization in their future.

4:00pm CDT

357: Beyond the Buzz: Practical AI Implementations in IT
EVALUATION
AI can be used in many different ways, from creating robots to helping with medical diagnoses. From automating mundane tasks to improving decision making and predictive analytics.  

AI can also be used to automate mundane tasks, such as data entry or customer service.

See how AI can help businesses save time and money, as well as improve customer service.


Speakers
avatar for Charlie Guarino

Charlie Guarino

CEO & IBM Champion, Central Park Data Systems
Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →

Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  AI

4:00pm CDT

266: Under the Hood: A Deep Dive into the SQL Query Engine 
EVALUATION
The SQL Query Engine (SQE) powers (nearly) every query that executes on your system. Since its introduction, SQE has been continually improved to create more efficient access plans, but these inner workings are rarely understood. In this session, Ryan will give audience members a rare peek under the hood of the engine that powers Db2 for i.
Speakers
avatar for Ryan Moeller

Ryan Moeller

Software Engineer, IBM
Ryan Moeller is a software engineer working on Db2 for i, specifically on the SQL Query Engine (SQE) team. He joined the team in the Rochester, MN development lab in 2020. Ryan specializes in SQL, database development, and query performance analysis.

Under the Hood A Deep Dive Into the SQL Query Engine pdf
Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Database engineers, database administrators, application developers

4:00pm CDT

303: Temporal Tables: Time Travel Is Cool
EVALUATION
Learn how to time travel within your data! How many programs are already doing some type of temporal logic? Would moving to a more data-centric approach reduce your development effort delivering faster and better results? This session explains how to temporalize your existing database, how to manage temporal database, and how to perform temporal analysis.

Learning Objectives:
How to temporalize your existing database.
How to manage temporal databases.
How to perform temporal analysis.
Speakers
avatar for John Westcott

John Westcott

Db2 for i Consultant and Team Lead, IBM
John Westcott is the Db2 for i Team Lead in IBM Technology Expert Labs. John is highyly skilled in SQL, RPG, Data Analytics, Rest API, and both database and application modernization. John has over 35 years of experience on IBM i and it's past family of names. John has a storied career... Read More →

303 Temporal Tables Time Travel Is Cool pdf
Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Anyone interested in creating a temporal database or performing temporal analysis

4:00pm CDT

330: Automated Build Systems for IBM i Environments
EVALUATION
We have been working on open source tools to make managing your IBM source code and building objects easy for when your source code is in git. In this, we will show how objects get built from a git repository (when developing locally and from an automated build), teach how build systems detect dependencies in your code, what build tools are available (GitHub Actions, GitLab CICD, etc) to work with IBM i, and eventually how you can start using these tools.

Learning Objectives:
* Show how objects get built from a git repository
* Teach how build systems detect dependencies in your code
* How you can start using these tools
Speakers
avatar for Liam Allan

Liam Allan

Software Advocate, IBM
I am a developer and open-source advocate. Ask me about Node.js, VS Code, app deployment and CICD :) 

Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  DevOps

4:00pm CDT

380: IBM i DevOps and Azure DevOps, Making It Work
EVALUATION
Managing IBM i native code with Azure Devops has huge opportunities for efficiency when managing business applications that span both platforms. If your company is Azure Devops everywhere but IBM i development this session will detail how you can hook these two platforms together for synchronous development and deployment with Azure pipelines. An added benefit is it makes the database directly available to .Net developers but you can still have a gatekeeper before the DB2 changes are deployed. Hear about how our experience of implementing our solution with Azure Devops at multiple customers.

Learning Objectives:
1. Planning workflow for IBM native code in the context of Azure devops
2. Integrating with Azure Devops pipelines for automation
Speakers
avatar for Jeffrey Tickner

Jeffrey Tickner

ARCAD Software
Jeff Tickner has worked in Change Management on the IBM I for 17 years at different companies. He is certified in Rational Team Concert as well has having experience with other Change Management packages from SourceSafe to Subversion. Jeff currently works for ARCAD Software, an international... Read More →

Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  DevOps
  • Session Level Intermediate
  • Audience Developers and managers who are interested in managing their native code with Azure Devops

4:00pm CDT

258: Power10 for the COMMON User
EVALUATION
Did you know that the entire IBM Power server family has now been refreshed with Power10 processor technology? Starting in September, 2021, IBM introduced the Power10 E1080 enterprise system and in July, 2022, IBM introduced the rest of the product family which includes the S1014, S1022/S1022s and S1024. IBM i customers need to know the capabilities and positioning of the entire Power server family, so attend this session to hear about the latest and greatest.
Speakers
avatar for Daniel Sundt

Daniel Sundt

IBM i Product Manager, IBM
Dan Sundt is an IBM i product manager. He has the responsibility for the IBM i business, including defining and guiding future directions and strategies. He works with the IBM i sales, marketing, and development teams as well as customers and partners to ensure that the IBM i operating... Read More →

Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Hardware
  • Session Level Intermediate
  • Audience Any IBM i customer on older hardware looking to upgrade their infrastructure

4:00pm CDT

298: Disaster Recovery – What Does That Actually Mean for the IBM i?
EVALUATION
Most IBM i shops assume their DR plan is as simple as loading the backups and their up and running – well, that isn’t actually the case. In this session we’ll discuss the devil in the details of Disaster Recovery, what information you need to have done and what steps you should anticipate taking should disaster strike.

We’ll address scenarios like:
- I backed up my system last night and then it crashed today. What do I do about the information that didn’t get uploaded since last night’s backup?
- Who do I speak to to get new software license keys for every single application my system is running?
- What’s my organization's RPO and RTO? What do I think it is and what is it in actuality? What should it be?

Learning Objectives:
Attendees will walk away learning about the importance of DR plans, how to execute them, and what needs to be on their DR checklist.
Speakers
avatar for Robert Nettgen

Robert Nettgen

Senior Consultant, Briteskies
Robert Nettgen wanted a career in radio broadcasting, but saw that profession declining and found better pay working in IT.  A PC developer in the ‘80’s, Rob started administering AS/400s in the early ‘90s for a Radio/TV group owner.  In 1999 Rob accepted a job as IT director... Read More →

Disaster Recovery what does that actually mean for IBM i pdf
Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience
  • Session Level All
  • Audience CISOs, System admins, Managers and Directors of IT departments, and anyone else responsible for information security and disaster recovery

4:00pm CDT

312: Developing With Developers In Mind
EVALUATION
In the world of software development, effective developing strategies are a crucial part to any project. Join us in this insightful session to explore the art of developing with developers in mind. Discover strategies, tools, and best practices to improve productivity and streamline updates for a better user experience. If you're not sure if this is the session for you, just ask yourself, "Do I want to receive work emails and calls while I'm on vacation?"

Learning Objectives:
1. Learn about organizing code using procedural programming
2. Learn to Automate tasks and processes (with a hint of open source)
3. Learn about what to include in project documentation
Speakers
avatar for Mike Zaringhalam

Mike Zaringhalam

Developer, PC Richard & Son
Have you ever wanted to meet someone who started Hawaiian Shirt Fridays at their work place? If the answer is 'Yes!', then feel free to reach out with any questions you have regarding Hawaiian shirts... Or IBM i related topics. My main focuses are RDi, DB2, Modernization, and D... Read More →

Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  IT Strategy
  • Session Level All
  • Audience Anyone looking to improve their collaboration skills

4:00pm CDT

360: Mastering Technical Debt Challenges in the IBM i Ecosystem
EVALUATION
A comprehensive session on strategies for addressing the challenges associated with tackling technical debt in the IBM i ecosystem. This session explores the impact of technical debt on your system's performance and longevity and provides actionable insights to effectively manage and reduce it.

Key Highlights:

- Understanding Technical Debt
- Identifying Hotspots and Common Areas
- Impact on Performance and Scalability
- Strategies for Debt Reduction
- Building a Future-Ready IBM i

Learning Objectives:
Join this session to
- Gain practical insights into proactively addressing technical debt in your IBM i environment.
- Learn how strategically managing technical debt not only mitigates risks and reduces long-term maintenance costs but also optimizes system performance and ensures the long-term scalability of your IBM i infrastructure.
- Walk away with actionable strategies and implementation tips tailored to your specific IBM i context, contributing to the future-proofing of your system and its adaptability to evolving technological landscapes.
Speakers
avatar for Chris Koppe

Chris Koppe

SVP Strategy Services, Fresche Solutions
Chris Koppe is responsible for developing client transformation strategies at Fresche Solutions. He has led the development of legacy management strategies for hundreds of companies, across a variety of platforms, languages, databases, and technologies. This insight has allowed Chris... Read More →

Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  IT Strategy

4:00pm CDT

201: IBM i Security Cocktail, with an SQL chaser
EVALUATION
In round 2 of this award-winning session, be prepared to hear Scott Forstie and Carol Woodbury shake up the world of IBM i Security once again, mixing up new SQL concoctions to bedazzle the otherwise boring world of IBM i Security. This menu includes examples of using SQL to find vulnerabilities in your code (aka penetration testing) as well as new (but practical!) ways to use SQL services. Even the most ardent security skeptic will be surprised at how just a sip of SQL can freshen up old IBM i Security processes. Before you know it, you’ll be sipping on the delightful features of SQL and rushing to pour out your current processes that have reached their ‘consume by’ date. A note of caution, however. You may leave a bit shaken (but not stirred) once again!

Learning Objectives:
1. Foundational knowledge of IBM i security
2. Why and how SQL is useful to the Security Officer and beyond
3. Have an idea of where to start and how
Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry events... Read More →
avatar for Carol Woodbury

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco Systems
With over 30 years' experience in the area of IT security, Carol is known world-wide as an expert in the area of computer security. During her career, Carol has architected security solutions for Fortune 100 companies as well as small and medium-sized organizations. Carol is passionate... Read More →

IBM i Security Cocktail with an SQL Chaser Round 2 PowerUp 2024 zip
Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Intermediate
  • Award BRONZE
  • Digital Badge SQL
  • Audience Anyone tasked with understanding, improving, or auditing security on IBM i.

4:00pm CDT

301: Navigator for i - A Developer's Guide
EVALUATION
Do you think that Navigator for i is just for system administrators? Think again! Navigator for i is a powerful tool for all IBM i users, including developers. In this session, you will get an overview of how Navigator for i works and learn about specific functions that developers can use to make their lives easier.

Learning Objectives:
1. Understand how to configure Navigator for i
2. Understand what functions Navigator for i provides to developers
3. Understand how Navigator for i interfaces with other IBM products
Speakers
avatar for Ann Wilkerson

Ann Wilkerson

Software Developer, IBM
Ann Wilkerson is the technical team lead for Navigator for i and a developer for IBM i Services.

Navigator for i A Developer's Perspective pdf
Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Beginner
  • Audience IBM i developers with any level of comfort with Navigator for i

4:00pm CDT

412: IBM i Proactive Performance Preparation
EVALUATION
No one plans to have a performance problem. When it next happens to you, will you have the information necessary to identify the root cause of the problem? This session will show you how to be prepared in the event of an unplanned performance problem. It will also discuss ways to avoid that problem from happening in the first place, and how to be notified as soon as possible that a problem may be starting.

Learning Objectives:
1. learn how to configure IBM i performance tools to have the data you need when a problem happens
2. learn how to get notified of potential problems
Speakers
avatar for Anil Madan

Anil Madan

Sr. Managing Consultant, IBM
Anil Madan is a Senior IBM i Performance Consultant with specialization in system, application and Db2 for i performance management. He is an IBM certified Thought Leader Technical Specialist and an IBM certified Executive Project Manager. Working out of the IBM Expert Labs in Rochester... Read More →

IBM i Proactive Performance Preparation pdf
Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level All

5:15pm CDT

193: IBM i ACS Data Transfer Overview
EVALUATION
IBM i Access Client Solutions (IBM i ACS) provides a Db2 Data Transfer features and capabilities that you may not be aware of or using most effectively. Join us for a quick, predominantly live demo session to get the most out of your IBM i ACS Data Transfer. 1. Get the most out of IBM i ACS Data Transfer
Speakers
avatar for Wayne Bowers

Wayne Bowers

Software Engineer, IBM
Wayne Bowers has been with IBM since 1997, where he works with the IBM i Global Support Center in Rochester MN. He is an Advisory Software Engineer specializing in the support of the IBM i Access (aka Client Access) products, Console, the TCP Telnet communications server, and the... Read More →

ACS DataTransfer PowerUp24 pdf
Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Client Connectivity
  • Session Level All
  • Digital Badge ACS
  • Audience IBM i ACS Data Transfer Users

5:15pm CDT

251: Performance Tuning, QAQQINI what you care about and how to use it
EVALUATION
This session hits the highlights of the file that defines your SQL environment. Did you know that you can have more than one? This session will hit the most important entries of this file. What values you want to use, and how to use it.

Learning Objectives:
1. Learn the most important entries in the file that defines your SQL environment
2. Learn how to use more than the one provided by IBM for your different workloads
Speakers
avatar for Tom Davidson

Tom Davidson

Sr Consultant, Cleindori Consulting
I'm a 40 year veteran of the IBM i (System/38,AS/400, iSeries, IBM i). My background is in Manufacturing and Performance. I specialize is tuning older systems to extend their life.I am also a JDE CNC (18 years), and my second specialty is JDE/IBM i/Weblogic.

QAQQINI What it is and how to use it pdf
Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Beginner
  • Audience Programmers and DBAs that are trying to improve performance of their applications.

5:15pm CDT

294: How Many Indexes is Too Many?
EVALUATION
The creation of indexes can have a positive impact on query performance. However, an index also has a cost since it has to be maintained every time rows in the associated table are inserted, deleted and updated. This session will the discuss indexing tradeoffs including the review of a benchmark test created to quantify the positive & negative impacts of indexes. In addition, you will learn about tooling that can be used to identify your most valuable and least valuable indexes.

Learning Objectives:
Speakers
avatar for Kent Milligan

Kent Milligan

Senior Db2 for i Consultant, IBM
Kent Milligan is a Senior Db2 for i Consultant in IBM Technology Expert Labs. Kent has over 25 years of experience as a Db2 for IBM i consultant and developer working out of the IBM Rochester lab. Prior to re-joining the Db2 for i Expert Labs practice in 2020, Kent spent 5 years... Read More →

How Many Indexes is Too Many pdf
Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level All

5:15pm CDT

198: The Secrets to Negotiating and Resolving Workplace Conflict
EVALUATION
Do you dread the thought of negotiating on your own behalf? Are you unsure of the best ways to handle conflict in the workplace? If you answered yes to either of these questions, then you need to attend this session! We'll cover time-tested techniques for negotiations and conflict resolution that could change your life!

Learning Objectives:
In just 20 minutes, you'll:
- Learn to consider the value of an argument vs the cost
- Find common ground to smooth the negotiation
- Understand that all new ideas are great, and that we all make mistakes
- Show respect and build a reserve of good will to allow everyone to leave the negotiation with their head held high
Speakers
avatar for Steve Wolk

Steve Wolk

CTO, PC Richard & Son
Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →

The Secrets to Negotiating and Resolving Workplace Conflict Steven Wolk pdf
Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  IT Leadership and Management
  • Session Level All
  • Audience We can all benefit from the techniques presented in this session!

5:15pm CDT

203: My Vision For the Future
EVALUATION
The world is changing. You can see it if you look around you... computers understand your voice, cars drive themselves, and so much more! What will things look like in 10 or 20 years? How will the world change? And, most importantly, how can we be ready for it?

Learning Objectives:
1. Understand how automation is already changing the world.
2. Think about how it will change things over time.
3. Be inspired to become a part of it!
Speakers
avatar for Scott Klement

Scott Klement

Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →

Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  IT Strategy
  • Session Level All

5:15pm CDT

261: Fostering Positive Relationships
EVALUATION
Positive healthy relationships are vital to success in everything you do: whether it is excelling in your career, creating a vibrant and energetic work environment, or having a happy and rewarding personal life. Learning how to interact with others in a way that is respectful and constructive is essential.

Learning Objectives:
Come to this session to learn:
1) How to connect with others in a positive and proactive way
2) The impact of creating respectful and nurturing relationships
3) How to create long-term relationships that will accelerate your career
4) Tools and techniques to foster positive relationships
Speakers
avatar for Kim Greene

Kim Greene

President, Kim Greene Consulting, Inc.
Kim Greene is president of Kim Greene Consulting, Inc. specializing in providing consulting services for the HCL Collaboration Solutions portfolio for IBM i, Windows, and Linux. Kim has over 20 years of experience with IBM Domino and 25 years of experience with the AS/400, iSeries... Read More →

Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Personal Development
  • Session Level Beginner
  • Audience All IT professionals

5:15pm CDT

185: Test Driven Development Using Python
EVALUATION
User Acceptance Testing should not be the only testing tool in your arsenal. Building a solid Python application is easy if you automate the boring testing process. In this session we’ll explore how easy testing can be in Python and how to get it done with several examples.

Learning Objectives:
1) Explore benefits of test Driven Development.
2) Work through a basic framework for architecting TDD.
3) Build an example case from scratch using Python and the unittest module.
Speakers
avatar for Mike Pavlak

Mike Pavlak

Solution Architect, Perforce Software
Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →

Python TDD 2.0 pdf
Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Programming - Python
  • Session Level Intermediate
  • Audience Developers and syste architects looking to explore Python or TDD architecture

5:15pm CDT

207: Developing an Weather Application for your IBM i
EVALUATION
I know, I know... we don't need another Weather Application. This is a fun session where I can show you how to put the pieces together, using an API, JSON_TABLE function, RPG, PHP into a store procedure. This will give you ideas on things you can do to impress your users and boss!

Learning Objectives:
1. Internalize how API"s can be used in your shop.
2. Understand how easily these pieces fit together.
Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies
Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →

Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level All
  • Audience Manager or any type of developer

5:15pm CDT

283: Leveraging Text to Group Objects for Security (20min)
EVALUATION
Three object types provide a critical information needed to manage your security project:

User profiles, Libraries, and IFS root-level directories. These “high-level” objects need to be assigned groups for simplified maintenance and security management.

Learning Objectives:
We will review how to simplify your security project by grouping critical object-sets; leveraging a little bit of code; and trusty PDM.
Bonus: O/S upgrade customization management.
Speakers
avatar for Tim Hawkins

Tim Hawkins

System Admin, Tanimura & Antle
I've got one year to go before I retire....  The boss said to "give back", and since that matched my plans anyways; here we go.  I present 4 classes on IBM i Security, showing all of the gory details.  Some can be leveraged for just system administration, and some elements work... Read More →

cos010c clle
cos020c clle
Job Schedule Entries sql
Job Schedule Entries xlsx
Sample PDM subsets docx
Leveraging Text to Group Objects for Security pdf
Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level All
  • Audience IBM i System Administrators who will be attending the “Using SQL to drive IBM i Security scans” session.

5:15pm CDT

200: 20 Tips in 20 Minutes
EVALUATION
In my work with real-world environments, I have found a number of very common configuration settings that are not optimal for today's environment. Whether it be system values, job descriptions, memory pools, many shops have configuration settings at the system default value, or settings that were done years ago.

This session is a fast-paced session covering 20 configuration tips in 20 minutes.


Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
Dawn has been involved with COMMON for over 20 years and has been a consistent volunteer since 2008. She's been a member of the strategic education team, a subject matter expert, and a speaker. Now, as President of COMMON, she's focused on leading COMMON as the industry leader of... Read More →

20 Tips in 20 Minutes POWERUp2024 pdf
Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Systems Management

5:15pm CDT

205: Logging options for Rest APIs on IBM i
EVALUATION
The IWS Rest API support has some exciting new logging options that has been recently added. With the new options you can now easily have tools like Splunk or Elastic Stack, or others, as you can now create a JSON based log file with Lots of additional details to help you better understand your API work flow and who is making connections.

Learning Objectives:
Speakers
avatar for Tim Rowe

Tim Rowe

Business Architect Application Development & Systems Management for IBM i, IBM
Tim Rowe is the Business Architect responsible for Application Development and Systems Management for the IBM i operating system. His responsibilities include helping to make sure that the IBM i has what is needed to be successful both today and into the future. He sends much of his... Read More →

Logging options for Rest APIs on IBM i pdf
Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level All

5:15pm CDT

418: State of Code for IBM i – An Open Discussion
EVALUATION
Welcome to our open forum discussion on the latest developments and future plans for Code for IBM i and its extensions. Join us to gain insights into our ongoing projects, current priorities, and upcoming features. This is your chance to engage directly with our development teams, including the core team, database team, and debug team. Whether you're curious about implementing VS Code, enhancing security measures, or contributing (be it code, documentation, videos, &c.), we invite you to bring your questions and ideas to the table. Let's collaborate and shape the future of Code for IBM i together.
Speakers
avatar for Jesse Gorzinski

Jesse Gorzinski

Business Architect, IBM
Jesse Gorzinski works for the IBM i development lab in Rochester, MN. He is a Senior Business Architect and Senior Technical Staff Member (STSM) responsible for open source technologies on the platform. Jesse, who was doing RPG programming at the age of 18, is an expert on application... Read More →
avatar for Tim Rowe

Tim Rowe

Business Architect Application Development & Systems Management for IBM i, IBM
Tim Rowe is the Business Architect responsible for Application Development and Systems Management for the IBM i operating system. His responsibilities include helping to make sure that the IBM i has what is needed to be successful both today and into the future. He sends much of his... Read More →
avatar for Scott Forstie

Scott Forstie

Db2 for i Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry events... Read More →
avatar for Liam Allan

Liam Allan

Software Advocate, IBM
I am a developer and open-source advocate. Ask me about Node.js, VS Code, app deployment and CICD :) 
avatar for Adam Shedivy

Adam Shedivy

Software Developer, IBM
Adam is a software Developer working on enhancing client and open source integration on IBM i.

Tuesday May 21, 2024 5:15pm - 6:15pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools

5:30pm CDT

All Attendee Reception in Expo
Tuesday May 21, 2024 5:30pm - 8:30pm CDT
Exhibit Hall A, First Floor 1508 Houston St, Fort Worth, TX 76102

5:50pm CDT

333: IBM i ACS Printer Output Overview
EVALUATION
IBM i Access Client Solutions (IBM i ACS) provides an IBM i Printer Output utility with many features and capabilities that you may not be aware of or using most effectively. Join us for a quick, predominantly live demo session to get the most out of your IBM i ACS Printer Output Utility. 1. Get the most out of IBM i ACS Printer Output
Speakers
avatar for Wayne Bowers

Wayne Bowers

Software Engineer, IBM
Wayne Bowers has been with IBM since 1997, where he works with the IBM i Global Support Center in Rochester MN. He is an Advisory Software Engineer specializing in the support of the IBM i Access (aka Client Access) products, Console, the TCP Telnet communications server, and the... Read More →

ACS PrinterOutput PowerUp24 pdf
Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Client Connectivity
  • Session Level All
  • Digital Badge ACS
  • Audience IBM i Access Client Solutions users

5:50pm CDT

260: Geospatial Analytics - What About Performance?
EVALUATION
Like any new offering, the Geospatial Analytics support features cool technology with lots of bells and whistles. When integrating a new technology like this into your applications, it's easy to focus just on the functional implementation and to overlook the performance considerations.

Learning Objectives:
In this session, learn how to streamline a Geospatial Analytics solution by leveraging the Geohash functionality and other advanced features.
Speakers
avatar for Kent Milligan

Kent Milligan

Senior Db2 for i Consultant, IBM
Kent Milligan is a Senior Db2 for i Consultant in IBM Technology Expert Labs. Kent has over 25 years of experience as a Db2 for IBM i consultant and developer working out of the IBM Rochester lab. Prior to re-joining the Db2 for i Expert Labs practice in 2020, Kent spent 5 years... Read More →

Geospatial Analytics What About Performance pdf
Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Database developer designing applications

5:50pm CDT

217: Use Value Stream Mapping to Improve Business Response
EVALUATION
When you are rolling out new applications, new features, tracking tickets, or enhancements how do you view this data? Sure, you can use a spreadsheet, maybe even view progress in each tool, or use a simple database, but why not use a dashboard with value stream mapping to pull 'live' information right into your preferred dashboard. This can pull everything together into an easy to use and comprehend visual reference. Stop by and find out how Value Stream Mapping can work for you.

Learning Objectives:
1) Find the delays in your pipeline.
2) Visualize how to find the hotspots.
Speakers
avatar for Alan Ashley

Alan Ashley

Presales Consultant for DevOps for IBMi, Arcad Software
When it comes to describing someone, even yourself, it can be difficult. This time it's easy. I grew up on the AS400, through iSeries, and into the IBM i world. Started on a model B50 (I know it was a B model) where the disk drive needed two persons to replace and now in the DevSecOps... Read More →

Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  DevOps
  • Session Level Intermediate
  • Audience Are you an application owner or project manager, then finding the delays is paramount in the DevOps cycle. VSM is the answer.

5:50pm CDT

197: The Secrets to Making the Most of Online Meetings
EVALUATION
Now that virtual meetings have become the new normal for so many of us, it's vital that we learn to make the most of this approach to getting things done. Whether you use Zoom, Teams, Webex, or another product, come to this session to learn the secrets to supercharging your online meeting productivity and getting results!

Learning Objectives:
In just 20 minutes, you'll learn:
- How to plan your meeting for success
- How to run your meeting for maximum productivity
- The best ways to take meeting notes
- When and how to end your meeting
- Tips and tricks to maximize your use of technology and supercharge your work from home environment
Speakers
avatar for Steve Wolk

Steve Wolk

CTO, PC Richard & Son
Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →

The Secrets to Making the Most of Online Meetings Steven Wolk pdf
Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  IT Leadership and Management
  • Session Level All
  • Audience Anyone who coordinates or attends online meetings

5:50pm CDT

249: What's up with the RDi Debugger?
EVALUATION
For many users getting started with the RDi debugger is intimidating. In this short session, we'll help the attendee understand the power of the debugger and feel comfortable with the features of the tool!

Learning Objectives:
1. Letting go of the 5250 debugger
2. Getting started with RDi debugging
3. Batch and interactive debugging
4. Service Entry Points (SEP)
5. How to debug different type of programs
6. Understand break-points and Monitor Expressions
7. Tips and Tricks!
Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies
Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →

Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools
  • Session Level All
  • Audience Attendees who are new to RDi or those that have had trouble "Quitting" The 5250 debugger

5:50pm CDT

222: UNIXCMD: Integrating RPG with Open Source
EVALUATION
Applications in the PASE environment (Java, Ruby, PHP, Python, Node.js and more) have taken the IBM i community by storm. Naturally, you'll want to integrate them with your traditional RPG and CL programs... but it's not as easy as it sounds! The model of calling Unix-based programs is very different from the traditional model. The Open Source (free!) UNIXCMD project makes it easy. With UNIXCMD, you can read and write commands the same way you access files.

Learning Objectives:
1. Understand the difference between Unix and IBM i calling models
2. Understand how to use UNIXCMD to bridge the two models.
3. Some examples to get you started
Speakers
avatar for Scott Klement

Scott Klement

Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →

Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Programming - Frameworks
  • Session Level Beginner
  • Audience Programmers looking to combine RPG with newer open source techniques.

5:50pm CDT

223: Quick Spreadsheets through PHP and Python
EVALUATION
Each language supports modules for extending basic features. In this session we'll explore this technique for creating REAL spreadsheets for both Python and PHP.

Learning Objectives:
1. Create REAL Spreadsheets using XLSXWriter in Python.
2. Create REAL Spreadsheets using PHPSpreadsheet in PHP.
Speakers
avatar for Mike Pavlak

Mike Pavlak

Solution Architect, Perforce Software
Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →

SpreadsheetPHP Python1.2 pdf
Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Programming - General
  • Session Level Beginner
  • Audience Programmers and utility folks interested in enabling data through controled mechanisms.

5:50pm CDT

213: Web Services: The Basics of Pulling External Data into Your IBM i Applications
EVALUATION
Obtaining information from external systems or data servers has come a long way since the introduction of EDI in the 1980s! Today, publicly available Web Service APIs offer a much more flexible and easier-to-integrate method for pulling pertinent global data into your IBM i applications. Whether it be commodity prices, financial data, current weather information, demographic statistics or whatever else you can think of, there is no shortage of information available on the internet that could complement certain areas of your company's business, thus adding valuable real-time information to your various user applications.

In this session we'll put this concept to work in a hands-on fashion. The presenter will use real-world API examples to demonstrate how developers, using Native IBM i DB2 SQL, can quickly access these valuable web service repositories and pull data into an RPG program or UI tool for their users. Attendees will see two simple 5250-based interactive examples in action, with source code they can try on their own systems.

Learning Objectives:
1> Understand the basic structure of a REST API, and how it differs from SOAP.
2> See how to find a public web service API and understand its inputs and outputs.
3> Learn how to structure and execute an SQL statement to pull data from the web service.
Speakers
avatar for Robert Swanson

Robert Swanson

Senior Partner, CNX Corporation
Rob has worked as an in-the-trenches IBM i developer since 1992, with the past 15 years focused on developing modernization efforts for legacy systems written in RPG. Currently serving as Senior Partner for CNX Corporation in Chicago, Rob is a strong advocate of introducing highly... Read More →

Use Native Functionality to get Public Data pdf
Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Programming - UI
  • Session Level Beginner
  • Audience Developers who could benefit from pulling external information (i.e., commodity prices) into their user applications on IBM i

5:50pm CDT

284: Object-level Authorities by Application, with Automation
EVALUATION
The ownership and authority privileges for all objects on the system are gathered and summarized for review; SQL code is set to identify when objects in the application don’t follow preset authorities; and code to automate the maintenance of ownership and authorities in a fast-paced development environment. Ownership and public authorities are critical elements of a secure environment.

Learning Objectives:
We will review sample application authorities, and the code that drives the creation of an application_authorities table. We review a few of the methods to categorize libraries for ownership and authority maintenance. Finally, a second SQL set of stored procedures are presented to maintain authorities on a schedule basis.
Speakers
avatar for Tim Hawkins

Tim Hawkins

System Admin, Tanimura & Antle
I've got one year to go before I retire....  The boss said to "give back", and since that matched my plans anyways; here we go.  I present 4 classes on IBM i Security, showing all of the gory details.  Some can be leveraged for just system administration, and some elements work... Read More →

Set application authorities sql
Object level Authorities by Application, with Automation pdf
Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level All
  • Audience System Administrators who will be attending the “Using SQL to drive IBM i Security scans” session; or who need to know about application authorities in-use on their system.

5:50pm CDT

212: Using System Monitors in IBM Navigator for i
EVALUATION
Learn how to create and work with System Monitors in IBM Navigator for i. Also learn how to use the Performance Data Investigator (PDI) visualization tool to view System Monitor data.

Learning Objectives:
1. How to create a System Monitor
2. How to view system monitor data
Speakers
avatar for Shauna Rollings

Shauna Rollings

IBM i Performance Tools & High Availability Development, IBM
Shauna joined the IBM i development team in 2008. She has developed and supported IBM i performance data collector tools throughout her entire IBM career. From the very beginning of the Db2 Mirror for i project, she has also been the technical team lead for the Db2 Mirror Configuration... Read More →

212 UsingSystemMonitorsNavigator pdf
Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level All
  • Audience System Administrators looking to take advantage of the performance monitoring capabilities of IBM i.

5:50pm CDT

319: Insights into Database Performance with the Performance Data Investigator
EVALUATION
While the SQL Performance Center is the "go to" tool for understanding database performance, you can also gain insights into database performance with the Performance Data Investigator (PDI). PDI has charts that allow you to visualize database performance data in graphical form. In addition, Collection Services collects SQL job-level performance metrics. Attend this short session to learn about how to use PDI to graphically view your database performance metrics and get some tips on what those metrics mean.

Learning Objectives:
1. Learn how to use the IBM i performance tasks to view database-related metrics
2. Learn how IBM i performance data can be helpful in determining if a potential performance problem is related to the database.
3. Learn how to gain insights into the plan cache with PDI
Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
Dawn has been involved with COMMON for over 20 years and has been a consistent volunteer since 2008. She's been a member of the strategic education team, a subject matter expert, and a speaker. Now, as President of COMMON, she's focused on leading COMMON as the industry leader of... Read More →

Insights into DB Performance with PDI POWERUp2024 pdf
Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Beginner
  • Audience Administrators who want greater insight into Db2 performance by using the Performance Data Investigator.
 
Filter sessions
Apply filters to sessions.
Filtered by Date - 
Clear filter
Monday, May 20
Tuesday, May 21
Wednesday, May 22
Thursday, May 23
Ballroom B, 2nd Floor
Billy Bob's Honky Tonk
Exhibit Hall A, First Floor
Meeting Room 101
Meeting Room 102
Meeting Room 103A
Meeting Room 201A
Meeting Room 201B
Meeting Room 201C
Meeting Room 203A
Meeting Room 203B
Meeting Room 203C
Meeting Room 204A
Meeting Room 204B
Room 202 A-B
Room 202 C-D
  • AI
  • Client Connectivity
  • Database
  • Developing Business Skills
  • DevOps
  • Hardware
  • High Availability Resilience
  • IFS
  • IT Leadership and Management
  • IT Strategy
  • Middleware (other)
  • Networking
  • Personal Development
  • Program Testing
  • Programmer Tools
  • Programming - Frameworks
  • Programming - General
  • Programming - PHP
  • Programming - Python
  • Programming - RPG
  • Programming - UI
  • Security
  • Systems Management
  • Virtualization
  • Session Level
  • Advanced
  • All
  • Beginner
  • Intermediate
  • Award
  • BRONZE
  • GOLD
  • SILVER
  • Digital Badge
  • ACS
  • HA/DR
  • IT Strategy
  • SQL
  • VS Code
  • Popular