COMMON POWERUp 2024

Attending this event?

COMMON POWERUp 2024

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?

10:15am CDT

105: What's New in Db2 for i Meeting Room 201C 292: IBM i Shops: Prepare for DevOps Meeting Room 204A 143: What's new in PowerHA Meeting Room 201B 113: Real-Time Access to Integrated File System Data Across the Network Meeting Room 201A 383: Maintaining an IBM i Development Staff in a Changing World Meeting Room 203B 399: Subscription on IBM i Placeholder Meeting Room 103A 126: IBM i Networking and Servers Overview Meeting Room 203C 103: Basics of QA and Testing for IBM i Professionals Room 202 A-B 121: What's New and Exciting in RPG Room 202 C-D 171: Foundations of IBM i Systems Admin: Reading Joblogs Meeting Room 203A 181: Intro to IBM i Services (SQL) for Admins Meeting Room 102 123: IBM i Security from the Ground Up Meeting Room 101

11:30am CDT

179: SQL and IFS - Reading/Writng IFS Files with SQL Room 202 A-B 188: SQL Coding Tips and Techniques Meeting Room 201C 177: Using DevOps to Quickly React to Business Needs: DevOps ROI Meeting Room 203A 214: Git and IBM i - How to Build Your Source Room 202 C-D 404: NVME is your Friend Meeting Room 201B 137: BRMS - How It Can Save YOU! Meeting Room 203B 326: Visual Studio Code and IBM i - Bring Your Own Device Meeting Room 102 130: Step-by-Step Guide to Creating Virtual i Partitions Hosted by IBM i Meeting Room 201A 196: Live Demo of the New IBM Navigator for i Meeting Room 203C 220: Introduction to Open Source on IBM i Meeting Room 103A

1:30pm CDT

415: Be The Star That You Are! Empowering You to Make a Difference in Your World Ballroom B

2:45pm CDT

419: Practical Examples of Using AI and IBM i Meeting Room 102 256: SQL Plan Cache Uncovered Meeting Room 201C 391: Analyzing Geospatial Data Using Db2 for i Meeting Room 203A 235: Git Branch Management for IBM i Source; I Want JUST the Changes Room 202 C-D 385: IBM Power: Made by Innovators for Innovators Meeting Room 201B 363: Choosing the Right Cloud Strategy: Private, Public, or Hybrid? Meeting Room 203C 293: What’s New with Open Source & IBM i Meeting Room 103A 268: Using IBM and Db2 Services in (RPG) Programs … Can Make Life Much Easier! Room 202 A-B 183: Anatomy of a Password Meeting Room 101 379: Foundations of IBM i Security Defense Meeting Room 203B 323: Introduction to the Navigator Performance Tasks Meeting Room 201A 342: Use Service Commander to manage ALL your stuff Meeting Room 204A

4:00pm CDT

173: Getting Started with SQL Functions and Procedures Meeting Room 203A 402: The Latest Hardware for IBM i Meeting Room 201B 109: Intro to FlashCopy & Cybersecurity Resiliency with Safeguarded Copy Meeting Room 201A 157: IBM i Strategy, Roadmap and Innovation Meeting Room 102 101: Agile Testing and Concepts Meeting Room 103A 355: Experience the Wonders of AI: Come Marvel with Me! Room 202 A-B 361: Decoding Fullstack: A Comprehensive Guide to Front-End Strategies Meeting Room 201C 148: Options for Consuming REST APIs from RPG Room 202 C-D 274: Di WHY? Do it yourself IBM i security assessment Meeting Room 101 124: HMC, IBM I, FSP, BMC & Firmware: Putting All the Pieces Together Meeting Room 203C 208: IBM i Navigator an Administrators View Meeting Room 204A 410: Performance Based Workload Management on IBM i Meeting Room 203B

5:15pm CDT

191: IBM i ACS 5250 Overview Meeting Room 201A 352: Simple Ways to Convert Your DDS Files into DDL Statements Meeting Room 204A 132: How to Become a Speaker at COMMON Meeting Room 203B 313: BRMS Recoveries Meeting Room 101 394: Debugging with VScode Room 202 A-B 222: UNIXCMD: Integrating RPG with Open Source Meeting Room 203A 345: Use WildFly to Serve Your Java Web Apps Meeting Room 201B 257: Lets Learn The Acronyms Room 202 C-D 335: Shortcuts to Using the IBM i Audit Journal Meeting Room 203C 205: Logging options for Rest APIs on IBM i Meeting Room 102 420: IBM i Security: A Dual Responsibility Meeting Room 103A

5:50pm CDT

192: IBM i ACS IFS Overview Meeting Room 201A 250: Top 10 Reasons to Build Your Own SQL Indexes Meeting Room 201C 339: 20 SQL Tips in 20 Minutes Meeting Room 203A 197: The Secrets to Making the Most of Online Meetings Meeting Room 203B 285: Collect Network Statistics the Easy Way Meeting Room 101 336: Understanding How Tech Impacts Our Bodies and What We Can Do About It Meeting Room 203C 206: Introduction to RDi's Code Coverage Tool Room 202 C-D 354: RPG array magic Meeting Room 204A 239: IBM i Event Monitoring with Manzan Meeting Room 102 388: Understanding the Various Ways to Save Your IBM i Meeting Room 201B

8:00am CDT

180: Revving up SQL Performance with Indexes Meeting Room 201C 272: Access MongoDB from IBM i Meeting Room 201B 386: IBM Power's Differentiated Memory Roadmap Meeting Room 203C 108: Choosing the right HA/DR solution Meeting Room 103A 112: Integrated File System Security Principles and Practices Meeting Room 201A 229: IBM i 7.5 Plus Favorite Features Meeting Room 102 341: Open Source: How to not mess it up Meeting Room 203A 275: Kick the Old IDE Habit With Code for i Meeting Room 101 150: IBM i Security: What’s New for IBM i 7.4 and 7.5 Room 202 C-D 100: IBM i OS and Power System Upgrade Testing Meeting Room 204A 129: Elevate Your IBM i Game: Transforming Bad Habits into Best Room 202 A-B

9:15am CDT

170: Deploy, Administer, and Restrict IBM i ACS: Get and Deploy IBM i ACS Meeting Room 203C 327: Db2 for i Inside of VS Code Meeting Room 203A 190: How Journaling Works with DB2 Meeting Room 201C 295: BRMS Beyond the Basics Meeting Room 201B 377: The IBM i Box of Chocolates - with Q&A Meeting Room 102 182: Test Analysis and Design Focusing on Planning, Cases, and Conditions Meeting Room 103A 233: Moving into Git (for RPGLE, COBOL, and more) Meeting Room 204A 384: Intro to Modern Application Integration via API Room 202 C-D 337: Breaches, Ransomware and Recovery, Oh My! Room 202 A-B 166: Understand your IBM i Performance Signature Meeting Room 201A 397: Power IO Placeholder Meeting Room 101 195: No Limits Modern Excel Reports Using RPG-The Whole Story Meeting Room 203B

10:30am CDT

169: Deploy, Administer, and Restrict IBM i ACS: Administer and Restrict IBM i ACS Meeting Room 201B 104: Consuming JSON Documents and Web Services with SQL (SQL and JSON - Part 2) Meeting Room 201A 262: Accelerate Your SQL Queries with SMP Meeting Room 204A 264: Partitioned Table Functionality Meeting Room 201C 168: Become a Superhero to your CIO: A Day in the Life of a CIO Meeting Room 203C 152: Programming Standards and Guidelines Meeting Room 103A 387: Basics of System Admin for Programmers Room 202 C-D 350: Maximizing the benefits of embedding SQL in your RPG code Meeting Room 203A 324: Best Practices for the IBM i Security Administrator Room 202 A-B 117: Managing IBM i PTFs Meeting Room 101 372: Accessing the IBM i with Rest Meeting Room 102

1:30pm CDT

416: What Does Your Job Look Like in 2030? A Vision of IBM i Work in the Future Ballroom B

2:45pm CDT

138: Using SQL to Overcome Challenges when Consuming XML (Case Study) Meeting Room 204A 140: OLAP (Online Analytical Processing) Functions – Much More Than Running Numbers! Room 202 A-B 304: Run Away Queries Got You Down? Meeting Room 201C 279: IBM HA/DR Solutions for IBM i Meeting Room 203B 133: The Ninja Guide to Building Teams and Creating Engagement Meeting Room 203C 176: Service Programs and Unit Testing – The Perfect Pair Meeting Room 103A 153: Overloading in RPG Room 202 C-D 368: How to Leverage Existing IBM® i Assets to Adhere to Modern Design Systems Meeting Room 203A 300: Audit Journaling with Navigator for i Meeting Room 102 307: Zero Trust Security for IBM i Meeting Room 201B 162: Where to Start with Open Source Package Management Meeting Room 201A 119: Selecting Your Power Virtualization Environment Meeting Room 101

4:00pm CDT

357: Beyond the Buzz: Practical AI Implementations in IT Room 202 C-D 266: Under the Hood: A Deep Dive into the SQL Query Engine Meeting Room 204A 303: Temporal Tables: Time Travel Is Cool Meeting Room 201C 380: IBM i DevOps and Azure DevOps, Making It Work Meeting Room 203A 258: Power10 for the COMMON User Meeting Room 201B 298: Disaster Recovery – What Does That Actually Mean for the IBM i? Meeting Room 201A 390: CEF Next Generation on IBM i Meeting Room 103A 312: Developing With Developers In Mind Meeting Room 101 329: What Modern App Dev for IBM i Looks Like Room 202 A-B 201: IBM i Security Cocktail, with an SQL chaser Meeting Room 102 301: Navigator for i - A Developer's Guide Meeting Room 203C 412: IBM i Proactive Performance Preparation Meeting Room 203B

5:15pm CDT

193: IBM i ACS Data Transfer Overview Meeting Room 201A 251: Performance Tuning, QAQQINI what you care about and how to use it Meeting Room 203C 294: How Many Indexes is Too Many? Meeting Room 203A 198: The Secrets to Negotiating and Resolving Workplace Conflict Meeting Room 203B 203: My Vision For the Future Meeting Room 201C 343: Make Your Web Apps Zoom with Nginx! Room 202 A-B 185: Test Driven Development Using Python Meeting Room 204A 207: Developing an Weather Application for your IBM i Room 202 C-D 283: Leveraging Text to Group Objects for Security (20min) Meeting Room 101 200: 20 Tips in 20 Minutes Meeting Room 103A 247: Best Practices for Collecting Performance Data with Collection Services Meeting Room 201B 418: State of Code for IBM i – An Open Discussion Meeting Room 102

5:50pm CDT

333: IBM i ACS Printer Output Overview Meeting Room 201A 210: What is SYSTOOLS and How Can You Leverage It? Meeting Room 201C 260: Geospatial Analytics - What About Performance? Meeting Room 203A 217: Use Value Stream Mapping to Improve Business Response Meeting Room 203C 261: Fostering Positive Relationships Meeting Room 203B 249: What's up with the RDi Debugger? Room 202 C-D 223: Quick Spreadsheets through PHP and Python Meeting Room 204A 213: Web Services: The Basics of Pulling External Data into Your IBM i Applications Room 202 A-B 284: Object-level Authorities by Application, with Automation Meeting Room 101 212: Using System Monitors in IBM Navigator for i Meeting Room 201B 319: Insights into Database Performance with the Performance Data Investigator Meeting Room 103A

8:00am CDT

349: Looking at Your Data From a Different View Point Room 202 A-B 184: Live Demo: Deploying PowerHA and Independent ASPs Meeting Room 203A 344: Open Source Always Wins. Let's Talk about it Meeting Room 204A 365: How to Set Up Your IBM i Environment to Weather the Evolution of Work in 2024 Meeting Room 203C 407: Steve's Yin to Josh's Yang - Maximizing Your Productivity in a Distracted World! Meeting Room 102 127: Hidden Gems of IBM i Room 202 C-D 240: How Do I Improve Software Quality? Meeting Room 101 149: Discovering your IBM i Data – For Security Administrators Issues Meeting Room 201A 118: Daily Care and Feeding of IBM i Meeting Room 201B 211: Set up a Shared NFS Drive to Deploy PTFs and Upgrades with Image Catalogs Meeting Room 103A 271: IMGCLG, IFS, & FTP: Your BFFs for Getting your Data to the Cloud. Meeting Room 203B 325: Can PowerVS help me in accomplishing my DR and Cyber Resiliency goals. Meeting Room 201C

9:15am CDT

228: ACS & Db2 for i – Explained Meeting Room 204A 328: End-to-End Development: Modern IBM i Development Stack Room 202 A-B 147: The Power of Ready - Lessons Learned from Actual Disasters Meeting Room 203A 401: Enterprise Design Thinking at Scale Meeting Room 201C 218: Using RDi to Refactor RPG Code Room 202 C-D 106: 30 PHP Tips in 60 Minutes Meeting Room 103A 189: How to set up your IBM I system and applications with a layered security defense using MFA Meeting Room 203B 375: 30 Information and Cyber Security Tips in 60 Minutes Meeting Room 101 131: Cool things in Navigator to be a RockStar System Administrator Meeting Room 203C 231: iSee with Scott and Tim Meeting Room 102 353: Using SQL to Help Keep Your System Clean Meeting Room 201A 120: Managing Startup and Shutdown of your IBM i Meeting Room 201B

10:30am CDT

392: API Enable Your Database Meeting Room 103A 347: How to Begin a Real-life DevOps Journey Meeting Room 203A 338: DB2 Mirror - Logistics for 400K trucks - Driving Business Outcomes Meeting Room 102 139: Everything They Never Taught You! Meeting Room 101 382: Intro to Developer Productivity Engineering (DPE) Room 202 C-D 356: AI Ethics: Balancing Innovation and Responsibility Room 202 A-B 314: Navigating Python on IBM i: From Zero to Hero Meeting Room 204A 216: Test Data Management : Are You Compliant? Meeting Room 201A 389: Fortify and Conquer: Secure Coding Strategies for IBM i Developers Meeting Room 203B 160: A Day in the Life of a Systems Admin Meeting Room 203C 194: What to know when moving to the Cloud Meeting Room 201C

1:30pm CDT

302: Database Modernization An Evolution not a Revolution Meeting Room 103A 310: Elevate your SQL Capabilities with Lateral Joins, Pivots, and Window Functions Meeting Room 203A 204: The Magic of Rest APIs on IBM i Meeting Room 102 265: Ask Dr. *nix Meeting Room 201C 315: Expanding Your Python Toolkit on IBM i Meeting Room 204A 163: What's the Fuss? Using Procedures and Service Programs Room 202 C-D 290: How to Use SQL in RPG Room 202 A-B 308: Best Practices for Preventing and Recovering from Ransomware Meeting Room 203B 107: Why Wait? Discover the Power of IBM i Wait Accounting Meeting Room 201A 116: Clean Up Your IBM i Disk Meeting Room 101 134: Discovering your IBM i Data - For System Administrators issues Meeting Room 203C 309: PowerVS is the Destination, Understand the Journey! Meeting Room 201B

2:45pm CDT

187: Streamline your SQL Routines Meeting Room 203A 351: Simon’s Top Ten SQL Meeting Room 102 102: What IBM i Professionals can learn from NASA Meeting Room 103A 128: Testing your DR Plan - Reality Check - 5 Yearly Must Haves Meeting Room 203B 364: I've Moved Over to Cloud. Now What? Meeting Room 204A 267: Open Source WALSTIB Meeting Room 201C 224: Build a Phenomenal Web App on IBM i in Under 10 Minutes — No Coding Required! Room 202 C-D 395: Building APIs with Jakarta (Java) Room 202 A-B 146: Take the Guesswork out of Security with Authority Collection Meeting Room 201A 280: 35 Tricks & Treats Meeting Room 101 348: Architecture to Optimize IBM Backup with FalconStor StorSafe Virtual Tape Library Meeting Room 203C 142: Take Control of Your IBM i Prestart Server Jobs Meeting Room 201B

4:00pm CDT

393: Visual Explain - IBM's SQL Performance Show-&-Tell Meeting Room 102 115: Accelerate Your Excel! Meeting Room 201A 414: We’re Going to the Cloud, but How Do We Get There? Meeting Room 204A 376: So You Want to Be a Contractor or Consultant Meeting Room 203A 408: Unleash the Power of RDi and VS Code for IBM I Room 202 A-B 241: How Refactoring Helps Bulletproof Your Application Meeting Room 203C 221: PHP Today and Tomorrow Meeting Room 103A 409: Modernization and 21st Century Skills - How to Move your Business into the 21st Century on IBM i Room 202 C-D 369: Why Should You Use HTML5 and Not Static HTML to Build New UIs Meeting Room 101 332: The Expert’s Guide to Power Systems Cloud Security Meeting Room 203B 122: Tales from the Datacenter: Worst Practices in Systems Management Meeting Room 201C

5:15pm CDT

346: Database Features in VSCode Room 202 A-B 209: Back Up to the Cloud with IBM Cloud Storage Solutions for i Meeting Room 201B 215: Benefits of Continuous Availability with Db2 Mirror for i Meeting Room 101 417: Data Corruption? Cyber Attack? Recover Your IBM i Data in Some Minutes Instead of Many Hours Meeting Room 203C 396: IBM Client Innovation Stories Meeting Room 201A 297: IBM i Integration - What's the Best Option For You? Meeting Room 203A 287: Troubleshooting Tips and Tricks Meeting Room 103A 288: Build a Web Application on IBM i Meeting Room 204A 178: Handling JSON With DATA-INTO and DATA-GEN in ILE RPG Room 202 C-D 305: The Cyber Security News Report - A Fun Look At Current Information Security News Stories Meeting Room 102 403: SQL for System and Storage Management Meeting Room 201C 411: Leveraging IBM i (SQL) Services for Performance Management Meeting Room 203B

8:00am CDT

366: How AI Trailblazes a New Path for Automated Testing Meeting Room 203C 269: SQL Error Logging Facility (SELF) Room 202 A-B 248: I'm Interested in Deploying IBM Db2 Mirror for i - Now What? Meeting Room 204A 114: Management by the Movies Meeting Room 201B 136: IBM i Network Monitoring, Diagnostics and Troubleshooting Meeting Room 203A 135: Optimizing Batch Processing with SQL Meeting Room 103A 371: Secure Rest APIs Meeting Room 101 202: IoT: Open My Garage Door with RPG Room 202 C-D 252: What Does a Full-Featured Security Strategy Look Like? Meeting Room 203B 175: Everything You Need to Know About the IBM i Administration Runtime Expert Meeting Room 102 245: Don't Lock Yourself Out! Securing Admin Servers Meeting Room 201A

9:15am CDT

373: Ai-Ops – Automation, AI for managing your IBM i Meeting Room 102 242: Fun with JSON Publishing: Letting SQL Do the Dirty Work Meeting Room 201C 110: Live Demo: Managing PowerHA Solutions Meeting Room 203B 111: Integrated File System: Real Life Room 202 C-D 199: Strategic IT - The Art of Advancing your Career Beyond the Technical Meeting Room 201B 374: Web Application Implementation Patterns for IBM i Room 202 A-B 125: Expand and Simplify RPG Using MI Functions Meeting Room 204A 381: Breaking Up a Monolith Meeting Room 203A 141: Configuring Single Sign-on for IBM i Meeting Room 101 362: Still Making These IBM i Security Faux Pas? STOP. Meeting Room 203C 237: Free Open-Source IBM i System Dashboards with Grafana Meeting Room 103A

10:30am CDT

316: ChatGPT as your Co-Developer: Use AI Intelligently Room 202 A-B 144: Turn up the Power: External Disk and Hardware Replication on i... A Case Study! Meeting Room 203B 253: API examples using RPG, Node.js, PHP, and Python Room 202 C-D 255: 30 Python Tips in 60 Minutes Meeting Room 103A 219: Modernization Case Study – Creating a Database Abstraction Layer Meeting Room 101 306: Disk-level encryption isn’t enough Meeting Room 201C 406: Cross-Platform Compliance, Security and EDR Meeting Room 201A 236: Advanced IBM i Services (SQL) for Admins Meeting Room 203C 398: PowerVS Placeholder Meeting Room 102 405: Power Virtualization & HMC Meeting Room 204A

1:30pm CDT

263: What is Open AI and Why Should You Care? Meeting Room 102 334: Configuring ACS (Access Client Solutions) to Use TLS Meeting Room 103A 259: Simple Steps to Improving Data Security on IBM i Meeting Room 203C 227: Tame the IFS with SQL Services Meeting Room 203B 270: You're Fired! ... Now What? Meeting Room 201B 154: Discovering your IBM i Data – For Development Issues Meeting Room 204A 159: One Order of Code Factoring With a Side of RDi Room 202 A-B 367: How to Choose the Best API Management Deployment Options: On-Site/On-Premises, Cloud, or Hybrid Meeting Room 201C 254: Alan's Favorite Tips for Open Source on IBM i Room 202 C-D 238: Ransomware and IBM i Meeting Room 201A 286: Using SQL to Drive Security scans Meeting Room 101

2:45pm CDT

421: Modernize & Improve Development Practices Using AI Meeting Room 201B 155: IBM i Services for the Developer Room 202 A-B 230: Merlin, DevOps, Git, and Modern Development for IBM i Room 202 C-D 158: How to Remain Relevant In a Changing IT Environment Meeting Room 201C 317: VS Code Power-User: Elevating RPG, Python, and Node on IBM i Meeting Room 203A 174: SQL for the RPG Programmer “How To”: SQL Access to Data and ACS Tools Meeting Room 204A 378: Building a Successful IFS Security Strategy Meeting Room 201A 172: Keep Your System up to Date: Image Catalogs - How They Changed my Life! Meeting Room 203C 296: Work Management Optimization Meeting Room 101 413: "Peeling the Onion” using iDoctor for IBM i Meeting Room 203B

4:00pm CDT

232: Using SQL Services in Everyday Life Meeting Room 201B 331: Deploy, Administer, and Restrict IBM i ACS: Ask Me Anything Meeting Room 203A 311: Honey, I Looped the Data: Recursive CTEs Meeting Room 103A 330: Automated Build Systems for IBM i Environments Room 202 A-B 225: Geographic Mirroring: HA with Any Storage Including Cloud and Hybrid-Cloud Meeting Room 101 360: Mastering Technical Debt Challenges in the IBM i Ecosystem Meeting Room 201C 400: Licensing on IBM i Placeholder Meeting Room 203C 246: Upgrade Your TODAY! Meeting Room 204A 291: Simplify Your Life with SQL Services Meeting Room 102 281: Surviving a Ransomware Attack Meeting Room 203B 165: What You Need to Know to Successfully Upgrade to IBM i 7.5 or 7.4 Meeting Room 201A