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
Wednesday, May 22
 

8:00am CDT

349: Looking at Your Data From a Different View Point
EVALUATION
Simon will explain how building SQL Views should become a part of your development strategy. He will give examples of the common ways he builds and uses Views to make his own and that of his team easier and simpler. Why do the hard work yourself when something else can do it for you?

Learning Objectives:
1. Why use Views
2. How to create a View
3. Deformalize your data for easy access
4. Create new derived & calculated data within the View
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 349 Looking at Your Data From a Different View Point pdf
Wednesday May 22, 2024 8:00am - 9:00am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience People interested in modernizing their database, people who want to make their programming simpler & easier to understand

8:00am CDT

184: Live Demo: Deploying PowerHA and Independent ASPs
EVALUATION
See how to go from a single system, to a fully deployed PowerHA environment using IBM FlashSystems Global Mirror technology. We begin the journey by creating an Independent Auxiliary Storage Pool (IASP) along with techniques for migrating your application into the IASP. We will be doing a live role swap by the end of the hour.

Learning Objectives:
1. Learn how to deploy PowerHA with IBM FlashSystems Global Mirror
2. See how to synchronize security and configuration related objects across the environment
3. Understand how to migrate data and applications to an Independent Auxiliary Storage Pool (IASP)
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 →

Deploying PowerHA pdf
Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience
  • Session Level Intermediate
  • Digital Badge HA/DR
  • Audience Anyone looking to implement PowerHA

8:00am CDT

344: Open Source Always Wins. Let's Talk about it
EVALUATION
Open source wins. It always wins. There's no fighting it. There's no denying it. But, it's important to understand "why" open source is such a disruptor and how you can tailor your IT strategy around its predictable wins.

Learning Objectives:
Understand and Leverage the momentum of open source technologies
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
Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  IT Strategy
  • Session Level All
  • Audience IT planners, executives, IT managers, or even developers

8:00am CDT

365: How to Set Up Your IBM i Environment to Weather the Evolution of Work in 2024
EVALUATION
The evolution of work is on every IT leader’s mind, whether it’s in the context of hybrid work, generative AI, or automation. For IBM i teams, though, there’s also the challenge of a shrinking workforce that has deep expertise in IBM i administration and development. The good news is IBM I teams can take advantage of this evolution in a way that not only mitigates the skills shortage business impact but also sets up the organization for success.

Learning Objectives:
In this session, we will discuss what you need to do to take advantage of the trends in the evolution of work, including how to:
• Leverage pipelines to visualize and document your DevOps processes
• Enable 3rd party tried and true tools
• Weave hyper-automation into your every day
• Enable teams to experiment with new tech and IT trends like AI
• Simplify a move to the cloud
Speakers
avatar for Jeroen van Dun

Jeroen van Dun

Product Manager, Rocket Software
avatar for Herman Rensink

Herman Rensink

Distinguished Engineer, Rocket Software

Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  IT Strategy

8:00am CDT

407: Steve's Yin to Josh's Yang - Maximizing Your Productivity in a Distracted World!
EVALUATION
The distractions are EVERYWHERE! Emails, texts, social media, meetings, phone calls - the list is as endless as the demands on our time. We live in a fast paced multi-tasking world of constant change, never having enough time! We NEED to find ways to maximize our productivity, despite the distractions! But there are questions…
  • Is it possible to use technology more efficiently and effectively to stay organized and communicate better?
  • Are we using technology too much, not allowing enough time for other aspects of life?
  • Can both be true? Spoiler alert… Yes, they are! Come join this session to find out how. Enjoy two speakers for the price of one, and learn two different but complementary approaches to the same goal!
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 →
avatar for Josh Bander

Josh Bander

IBM i Account Executive, IBM Champion, Rocket Software
Josh Bander is an IBM i Account Executive based in Cleveland, Ohio. He works at Rocket Software, one of the leading IBM i software providers with familiar products such as Rocket DevOps (Aldon), iCluster, and Rocket API. Recently, Josh has become well-known within the IBM i community... Read More →

Steve's Yin to Josh's Yang Maximizing Your Productivity in a Distracted World! Steve Wolk & Josh Bander pdf
Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Personal Development
  • Session Level All
  • Audience Everyone who would like to be more focused, less distracted, and more productive!

8:00am CDT

127: Hidden Gems of IBM i
EVALUATION
The IBM i team has been delivering new function two times per year since 2010. New releases and technology refreshes deliver a broad range of function and sometimes the smallest line items can be easily missed. The IBM i team has reviewed the past releases/refreshes and have assembled some of their favorite hidden gems; things that you might have missed but should know. Everyone will leave with something new that will help them in their day to day work.

Learning Objectives:
1. Learn about some of the very useful but lesser known functions of IBM i.
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 Douglas Gibbs

Douglas Gibbs

IBM i Product Manager, Program Director, IBM
Douglas Gibbs is the offering manager for IBM Power Systems I/O and works closely with the overall Offering Management, Sales and Development teams regarding all manners of I/O. Douglas has worked in the IT Industry for more than 25 years and has been in a variety of positions at... Read More →
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 →
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.
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.

Wednesday May 22, 2024 8:00am - 9:00am CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Programming - General

8:00am CDT

240: How Do I Improve Software Quality?
EVALUATION
Every programmer wants to do the best job. How do you test your program and ensure that you aren't missing anything? From the simplest bug fix to large complex projects, there are key concepts that you can use to ensure that your program is properly tested.

This session is co-presented by expert developer, Scott Klement, and expert tester, Yvonne Enselman so that you can see things from both a developer and tester's perspective.

Learning Objectives:
1. What are the key points in the development process where testing should be considered?
2. How developers can identify the need for support from a tester or project manager.
3. How to minimize risk from software errors.
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 →
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 →

Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level Intermediate
  • Audience Software developers who want to improve their quality.

8:00am CDT

149: Discovering your IBM i Data – For Security Administrators Issues
EVALUATION
There’s plenty information on IBM i that is so valuable for the daily tasks. Many commands, APIs, and SQL functions, let you gather information from your IBM i. You can exploit it online, or build your own database tables with it.

I like to dig into this info. There is always something new to discover. Particularly related to security administration activities: analyzing user profiles, object ownership and authorities, authority lists, program adoptions, exit programs implemented, exploiting audit journal entries, analyzing Db2 activities, and the list goes on and on. All this information is as valuable to IT System Managers, as it is enterprise information to Business executives. You need to understand, evaluate, and take advantage of this knowledge.

In this session we will review the different types of system information you can find on IBM i, that are important for Security Administrators. We’ll also analyze different case studies of how to interpret and prepare the info for future exploitation.

Learning Objectives:
Identify different kinds of Information available in your IBM i
Analyze different ways of obtaining and/or finding this information in your systems.
Prepare information for better use with modern tools.
Speakers
avatar for Cecilia Howlin

Cecilia Howlin

Owner, PYRAMIS S.R.L.
Cecilia Howlin has been working on this platform from the very beginning. On her first job at IBM Argentina, she learned S/38. And never left the platform, since she thinks it never appeared other operating system as good as this one.She usually worked on technical issues, like installing... Read More →

Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Intermediate
  • Audience Security Administrators and Security Auditors who need to find and exploit System Information related to Security

8:00am CDT

118: Daily Care and Feeding of IBM i
EVALUATION
IBM i and IBM Power Systems combine to deliver a fabulously reliable environment. The operating system has rich work management capability and strong error reporting. Despite that you shouldn't ignore it or you will eventually find yourself dealing with something serious. In this session we'll cover the things you need to watch and understand allowing you to deal with them before they become serious issues.

Learning Objectives:
1) Learn where to look and what to look for to know how your system is running.
2) Learn what to configure for automatic reporting of errors and problem.
3) Learn the points at which you need to begin to apply effort well before issues occur.
4) Be able to tell management: "Yes our IBM i is running well!"
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 →

Daily Care and Feeding of IBM i pdf
Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Award GOLD
  • Audience This session is focused on the Developer who is suddenly handed the Admin hat and needs to know what the daily tasks of an Admin are.

8:00am CDT

211: Set up a Shared NFS Drive to Deploy PTFs and Upgrades with Image Catalogs
EVALUATION
Upgrading and PTFs is easy with Image Catalogs, but doing the same process on multiple LPARs can take a lot of redundant time and space. Learn how to use the mature and established support of NFS to create a single image catalog that multiple LPARs can use.

Learning Objectives:
1. Brief discussion of image catalogs and NFS
2. How to set up NFS with real world examples
3. Networking requirements and guidelines
Speakers
avatar for Jeffrey Carey

Jeffrey Carey

Sr. System Administrator, Ensono
Jeff Carey is an IBM i professional with over 25 years of experience on the platform, specializing in system administration. He currently is a Senior System Administrator for Ensono, a company providing managed services for Mainframe, IBM i, Cloud, and hybrid IT, headquartered in... Read More →

Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience System Administrators who need to update and upgrade multiple systems, especially multiple LPARs on singe physical system.

8:00am CDT

271: IMGCLG, IFS, & FTP: Your BFFs for Getting your Data to the Cloud.
EVALUATION
Getting your production data to the cloud has many challenges, including method, additional storage, backup time, and transfer recovery time. There are 3rd party packages which will help with these but come at a cost. This session will cover methods using native IBM i functions to accomplish this. In addition, identify ways to significantly reduce the transfer time. Real life example how a 350GB full system backup transfer taking 61 hours was reduced to 9 hours. Tricks to reduce the time even more and minimize additional storage requirements.

Learning Objectives:
1. Learn different tools and methods of getting you data to the cloud, including Image Catalogs and FTP.
2. Using native IBM i tools, understand different ways to reduce the data and time needed to get your data to the cloud.
Speakers
avatar for Rob Mineo

Rob Mineo

IBM i Senior Administrator/SME, (Independent)
I started my IT career in 1984. I started working on an IBM SYSTEM/38 in 1986, and upgraded to the AS/400 in 1989.  I worked for STERIS Corporation from 1991 until I semi-retired in 2022. Since then, I have worked as an Independent IBM i Administrator.  My career started as a programmer... Read More →

Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience System Administrators and anyone responsible for getting IBM i data to the cloud or transferring data between systems.

8:00am CDT

325: Can PowerVS help me in accomplishing my DR and Cyber Resiliency goals.
EVALUATION
in this session we are going to find out how IBM Power Virtual Server can help you to accomplish your Disaster Recovery and also your Cyber Resilience goals.

Also the reason for PowerVS as a DR environment will be discussed.

Learning Objectives:
-Understand how to set up a secure environment in IBM Power Virtual Server
-Compare on premise security to IBM Power Virtual Server security.
-How can IBM Power Virtual Server help you around Cyber Resiliency.
Speakers
avatar for Tonny Bastiaans

Tonny Bastiaans

offering manager, IBM
Tonny Bastiaans is World Wide Product manager Power System at IBM. Started more than 20 years ago as an engineer on RS6000 systems (the predecessor of Power). He moved via several roles to his current role. With his technical background he is bridging the gap between technic and business... Read More →

Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Virtualization
  • Session Level All
  • Audience it administrators, architects, business strategist

9:15am CDT

228: ACS & Db2 for i – Explained
EVALUATION
In this new session, you’ll hear the inside scoop about ACS from Ryan & Wayne.

At this session we will explore ACS and have a fun time understanding all the ACS has to offer.

Learning Objectives:
1. Discover the database and SQL feature-rich options within ACS
 2. Gain best practices by hearing and seeing two experts discuss and demonstrate ACS
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 →
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.

ACS and Db2 for i Explained pdf
Wednesday May 22, 2024 9:15am - 10:15am CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Beginner
  • Audience Anyone who needs to interact with Db2 for i

9:15am CDT

328: End-to-End Development: Modern IBM i Development Stack
EVALUATION
In this talk, we’ll look at everything from development tools, build systems, to deployment methods. Finally there is a complete open source stack from IBM to use git and easily deploy ILE code (RPG, COBOL, you name it!) and this will cover them. We will look at the end-to-end lifecycle for IBM i applications when stored in git - all the way from the developers, to the end users machine automatically.

Learning Objectives:
* Understanding what a modern development lifecycle looks like
* How modern lifecycles look when running on IBM i
* Seeing the available open-source tools to accomplish automated deployments
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 :) 

Wednesday May 22, 2024 9:15am - 10:15am CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  DevOps
  • Session Level Intermediate
  • Audience Customers who want to use git, automate builds and automate deployments

9:15am CDT

147: The Power of Ready - Lessons Learned from Actual Disasters
EVALUATION
Our businesses today demand up-time, and reliability to move product and deliver services. Can your IBM i survive a sudden, unplanned event? Learn from multiple computer room, Cloud, and regional disasters, to know your DR Solution works in an actual Disaster. People, Technology and Geography are common critical points of failure. Lets keep our mistakes Original !

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 →

272 Power of Ready PowerUp Dallas Final pdf
Wednesday May 22, 2024 9:15am - 10:15am CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience

9:15am CDT

401: Enterprise Design Thinking at Scale
EVALUATION
Speakers
avatar for Felix Portnoy

Felix Portnoy

Design Principal, IBM
Felix Portnoy is a Design Principal at IBM, where he serves as a key driver in the transformation of IBM Power, with a focus on delivering exceptional customer experiences and elevating design culture and practices across the organization. Felix is a published researcher and the recipient... Read More →

Wednesday May 22, 2024 9:15am - 10:15am CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  IT Strategy

9:15am CDT

218: Using RDi to Refactor RPG Code
EVALUATION
The best way to protect your investment in the IBM i is by transforming your applications into a "Next Generation" architecture. This session demonstrates how RDi accelerates this process and provides an agile approach to modernizing/refactoring RPG Code

Learning Objectives:
Best Practices and examples for the following will be covered:
1) How to use the refactoring capabilities of RDi
2) Moving from Fixed to Free Format RPG
3) How to extract business logic into procedures using RDi
4) Implementing a Database Abstraction Layer"
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 →

Wednesday May 22, 2024 9:15am - 10:15am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools

9:15am CDT

106: 30 PHP Tips in 60 Minutes
EVALUATION
Inspired by longtime presenters at the Summit, this discussion looks at the most popular tweaks, hacks and just plain good practices the for IBM i PHP community to enjoy. Sometimes you just need a shopping list of things to watch out for and many of the tips that are scattered throughout these presentations are consolidated in a single place. Performance, security and best practices and more will be discussed.

Learning Objectives:
• Common tips useful to all PHP shops
• Common mistakes to overcome with PHP in most shops
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 →

PHP tips in 60 minsV7.2 pdf
Wednesday May 22, 2024 9:15am - 10:15am CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Programming - PHP
  • Session Level All
  • Award BRONZE
  • Audience PHP developers and IBM i System Administrators where they are running PHP workload

9:15am CDT

189: How to set up your IBM I system and applications with a layered security defense using MFA
EVALUATION
While the IBM i is more securable than distributed systems, it is still vulnerable to potential security risks. This is especially true as you modernize the applications through API creation to engage the data and applications that live on the system. In this session, we’ll discuss how you can build out a layered defense against security threats, including integrating IBM i with your existing enterprise SSO architecture.

Learning Objectives:
*Why IBM i specific security is critical and how to convince the business it should be part of the security policy
*How to set up MFA for IBM i using MFA
*How to integrate MFA into your applications like terminal emulation, and your SSO infrastructure
Speakers
avatar for Tim Hill

Tim Hill

Distinguished Engineer, Rocket Software
Tim Hill is a Distinguished Engineer and VP of Engineering at Rocket Software.  He’s responsible for security, cloud, and AI/ML products on Power and Z.  Technology areas of personal focus include model-based reasoning, deep learning, complex event correlation, network management... Read More →
avatar for Hrithik Govardhan

Hrithik Govardhan

Software Lead, Rocket Software
Long time Rocketeer working in the Security/MFA/Cloud spaces on Power and Z.

PMFA Powerup2024 pdf
Wednesday May 22, 2024 9:15am - 10:15am CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level All
  • Audience Those who want to ensure data and applications on the IBM i are secure by layering on MFA.

9:15am CDT

375: 30 Information and Cyber Security Tips in 60 Minutes
EVALUATION
Security is a big topic but it doesn’t have to be overwhelming. Just like weight lifting, where you can start with smaller weights and work your way up, so to in cyber security you can reduce your risk by doing some basic things as you work toward bigger goals. Examining the most common causes of security failures and a few simple countermeasures can help you take some action now.

Learning Objectives:
You know security is important, you do what you can to keep your IBM I and ERP secure, but is there anything more you could and should be doing? Get your checklist out and start checking the boxes of Robert’s 30 Security Tips in 60 Minutes. From no-brainers like MFA and limited ALLOBJ Authority to more detailed considerations like antivirus software and various security tools, this presentation will tell you what you should be doing, a little about how to do it, and a lot about what you may not be thinking of.
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 →

30 Security Tips in 60 minutes pdf
Wednesday May 22, 2024 9:15am - 10:15am CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level All
  • Audience CISOs, System admins, Managers and Directors of IT departments, and anyone else responsible for information security.

9:15am CDT

131: Cool things in Navigator to be a RockStar System Administrator
EVALUATION
IBM Navigator for i is a powerful new tool to better manage your i environment. Get expert advice for installation and set up to make sure you get this powerful tool up and running at peak efficiency. Step through the functionality of this product and learn how to leverage the Performance Data Investigator to turn the collection services data into graphs you can use to identify performance issues. Learn ways to protect your system from intrusions, as well as close security holes such as FTP. See how this tool can help you select and install Logical files on your system to improve performance. Learn about the enhancements to this valuable tool in the latest release, while we see how this tool provides tips and techniques for better and more easily managing your IBM i.

Learning Objectives:
1) Learn how to close down various TCP/IP servers like FTP from intruders. 2) How to use the Index Advisor to improve performance. 3) Identify if someone is trying to access your IBM i with Intrusion Detection. 4) Performance Management graphs.
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 →

Cool things in Navigator for IBM I to be a Rock Star System Administrator 2024 pdf
Wednesday May 22, 2024 9:15am - 10:15am CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Systems Management

9:15am CDT

231: iSee with Scott and Tim
EVALUATION
In this session Scott and Tim will show, ie live demo how to solve real problems that we get asked, using ACS and the power of SQL.

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 →

Wednesday May 22, 2024 9:15am - 10:15am CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level All

9:15am CDT

353: Using SQL to Help Keep Your System Clean
EVALUATION
Have you recently taken over responsibility for a LPAR? Or are you concerned there is too much “rubbish” on your systems? Use these techniques to identify the most common wastes of space you have, & plan your cleanup efforts.

Learning Objectives:
1. How to identify the big three “wasters” of space
2. Simple ways to clean this up
3. How to monitor that this does not happen again
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 353 Using SQL to Help Keep Your System Clean pdf
Wednesday May 22, 2024 9:15am - 10:15am CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Digital Badge SQL
  • Audience Any system admin or anyone who is responsible for a LPAR looking to increase the amount of available space, & reduce the amount of old & unneeded “stuff” taking up that space.

9:15am CDT

120: Managing Startup and Shutdown of your IBM i
EVALUATION
In days gone by the IBM Supplied program QSTRUP combined with a couple options on CHGIPLA was good enough for most IBM i shops. It started what seemed to be needed and anything else we stumbled through after each IPL. When it was time to shut down a PWRDWNSYS or ENDSBS command took down whatever was running. We were happy.

Today though we often see dozens of subsytems running many web servers, other needed batch jobs and services. We see monitors and queue processing jobs and many writers. For security purposes we should be starting only the TCP servers that we need, not all of them. Likely we should not start IPV6 and start things in sequence as well.

Further considerations may be needed in an HA environment. These include not starting jobs until iASPS are available and starting different IP interfaces and services depending on production or backup mode of the server. We may want to handle special startup modes while doing PTFs, backups or other system maintenance.

In this session we will work with customizing that startup. We'll discuss staring PASE jobs with QSH, web server jobs and more. We'll discuss prestart jobs and autostart jobs. And finally we will also work with sequencing the shutdown of the system. As part of this we'll discuss some simple ways to know what needs to be shut down and smoothly handling that.

Learning Objectives:
1) Learn how to control which startup program will run on your IBM i.
2) Examine the various servers to start and how to control them.
3) Learn options for starting different services.
4) Consider ways to control the startup of your server in different operting modes.
5) Understanding an orderly shutdown of your IBM i server.
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 →
avatar for Larry Amond

Larry Amond

Director of Application Development, Greater Regional Alliance of REALTORS®
Larry began his career working and IBM and NCR mainframes in 1977, and has been working on IBM midrange systems since 1993. He has spent most of his career as an application systems developer and has been developing web site applications on IBM systems since 1999.He is currently Director... Read More →

Managing Startup and Shutdown of IBM i pdf
Wednesday May 22, 2024 9:15am - 11:30am CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Advanced
  • Award GOLD
  • Audience IBM i System Administrators

10:30am CDT

392: API Enable Your Database
EVALUATION
How important is delivering business data to your users and customers? I’d bet it’s among the top concerns of any development effort. How do you deliver data in the modern world? Rest API are one of the most common methods. We’ll explore, though live demos, how to expose data in a safe and secure manner using Integrated Web Services (IWS). Our focus will be on directly leveraging the database, not using RPG or Service program.

Learning Objectives:
1. How to exose data using Select, Insert, Update, and Delete statements
2. How to expose data using SQL Stored Procedures
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 →

392 API Enable Your Database pdf
Wednesday May 22, 2024 10:30am - 11:30am CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience SQL developers delivering data to any part of the business

10:30am CDT

347: How to Begin a Real-life DevOps Journey
EVALUATION
A DevOps strategy unites your software development and IT operations teams so you can deliver software faster. In this session, we share tips, advice, and anecdotes from teams just like yours who are implementing DevOps along with CI/CD pipelines to integrate and automate essential processes. Moving forward seems less daunting when we learn from the experiences of others.

Learning Objectives:
1. DevOps fundamentals
2. First steps to take to prepare for implementing DevOps and CI/CD pipelines
3. How DevOps and CI/CD best succeed with an evolutionary approach
4. Tips on where to start, how to make regular progress, and set realistic goals to deliver on time and within budget.
Speakers
avatar for Donna Westmoreland

Donna Westmoreland

CTO, Midrange Dynamics North America
Experience gained from leading major projects, including application modernization, at 100s of corporations has given Donna a well-rounded view of development needs, audit requirements, and testing principles.

Wednesday May 22, 2024 10:30am - 11:30am CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  DevOps
  • Session Level All
  • Audience Those interested in implementing DevOps methodologies.

10:30am CDT

338: DB2 Mirror - Logistics for 400K trucks - Driving Business Outcomes
EVALUATION
Transflo generates over 3.2M downloads to equip over 400,000 truck drivers 7 x 24 with all the features they need for their workday. Near zero downtime was the only way to keep the fleets connected and moving around the clock. This CASE Study will present through the eyes of the customer a roadmap : IBM lab DB2 Assessment, building a reference architecture, implementation, testing failover and day to day management for DB2 Mirror.

Learn how Transflo leveraged an IBM Cloud On Net solution by staying on IBM Power Technology connected to AWS and Azure. The solution enabled Transflo to scale easily, reach best-in-class system availability.

Learning Objectives:
1. Gain insight into the critical step for a successful DB2 Mirror Implementation
2. Explore operational testing with DB2 Mirror
3. Stay-up-to-date with the latest new features available for DB2 Mirror
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 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 →

338 DB2 Mirror – Logistics for 400K Trucks Final pdf
Wednesday May 22, 2024 10:30am - 11:30am CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience

10:30am CDT

139: Everything They Never Taught You!
EVALUATION
Ok, maybe we're setting the bar a little high by saying EVERYTHING, but did you ever feel like all the people around you seem to just KNOW things, things you don't? Sure, you're a wiz with SQL, and no one codes RPG like you do, but when it comes to people skills, to working in teams, to communicating well, to building your career... Well, they never taught you THAT! Come to this session to learn everything you've been missing out on.

Learning Objectives:
Attend this session to learn to:
* Collaborate more effectively with other team members
* Resolve conflict with coworkers
* Improve your relationship with your boss
* Negotiate to get what you want
* Effectively market yourself in your current position
* Communicate better with everyone
* Understand EVERYTHING THEY NEVER TAUGHT YOU!
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 →

Everything They Never Taught You! Steven Wolk pdf
Wednesday May 22, 2024 10:30am - 11:30am CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Personal Development
  • Session Level All
  • Award GOLD
  • Audience Anyone who must work with other people will benefit from this session!

10:30am CDT

382: Intro to Developer Productivity Engineering (DPE)
EVALUATION
The tech ecosystem has been changing drastically, and there are some technologies that are disrupting the way developers are expected to operate. For instance, we're seeing the VSCode ecosystem grow, we're seeing AI do amazing things, and we have more open source CI/CD options than ever before.

What does all this mean? In short, it has caused a strategic shift of focus to developer productivity. That is, how do we enable developers to be productive as possible? Developer Productivity Engineering, or DPE, is the study of how to analyze and improve efficiency for programmers. In this session, get an overview of DPE so that you can apply the concepts within your organization. Doing so will increase efficiency and decrease cost.

Learning Objectives:
Learn what DPE is and discuss how it can be applied in a realistic setting
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 →

Wednesday May 22, 2024 10:30am - 11:30am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools
  • Session Level All
  • Audience IT planners, executives, IT managers, or even developers

10:30am CDT

356: AI Ethics: Balancing Innovation and Responsibility
EVALUATION
As AI technology advances and its use becomes more widespread, the debate of ethical concerns becomes more prominent.

On one side of the debate, some argue that AI should be used to improve the lives of people and make difficult decisions with fewer mistakes.

On the other side, some argue that AI should not be used to make decisions that affect people’s lives, as it could lead to biased results or decisions that are not in the best interest of society.

Either way, as the debate continues, the importance of ethical considerations when creating and using AI will become increasingly important
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 →

Wednesday May 22, 2024 10:30am - 11:30am CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Programming - General

10:30am CDT

216: Test Data Management : Are You Compliant?
EVALUATION
When it comes to testing, training, or even disaster testing, often real data is used. This may be the entire set of tables of production or a subset, but it's real data. Real private personal information. With the European GDPR or the CCPA out of California, protecting this data is now more than keeping a hacker away. It's about protecting the bottom line and away from fines. This is where you need to use anonymization to mask your data so that it's usable and masked.

Learning Objectives:
1) Are you compliant with PII policies?
2) Is your data exposed in non-production environments.
3) Do you know the difference in anonymization and pseudoanonymization.
4) Data Extraction
5) Using temporary environments
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 →

Wednesday May 22, 2024 10:30am - 11:30am CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Intermediate
  • Audience If you are an application owner, security admin, or an auditor, then understanding the possible expose in non-production environments is key. This session will cover those questions and answers to protect those environments.

10:30am CDT

389: Fortify and Conquer: Secure Coding Strategies for IBM i Developers
EVALUATION
Embark on an exploration of IBM i security challenges as we navigate the dangerous landscape of common vulnerabilities on IBM i. Don't miss the chance to fortify your coding skills and conquer the challenges of secure IBM i development!

In this session tailored for ILE developers (including RPG and CL developers), we'll dissect real-world examples of security pitfalls in our sample software, exploring issues like object authority, adopted authority, and library list vulnerabilities. Discover actionable solutions that empower you to reinforce your IBM i code so it is ready to face threats lurking in the wild.

Learning Objectives:
1. Learn from correcting real-world examples of vulnerabilities in a set of sample applications.
2. Understand the basics of creating more secure software on IBM i.
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 →

Wednesday May 22, 2024 10:30am - 11:30am CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Intermediate
  • Audience IBM i software developers

10:30am CDT

160: A Day in the Life of a Systems Admin
EVALUATION
What tasks do you need to complete every day, every week, and on a regular basis to successfully administer your IBM i? This session will take you through the base tasks that every System Admin should be doing to monitor and administer the system to its best efficiency.

Learning Objectives:
1. Learn what to monitor regularly to ensure optimization
2. Learn what tasks to complete regularly to keep the system on track.
3. Learn how to streamline your administration tasks efficiently
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 →

Wednesday May 22, 2024 10:30am - 11:30am CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Beginner
  • Audience System Admins who are new to the position or to IBM i in general.

10:30am CDT

194: What to know when moving to the Cloud
EVALUATION
In this session, we'll discuss what you need to think about when moving to the cloud. It’s not as easy as just moving your workload from one machine to another. Pete will cover: Costs associated with moving to the cloud, what you should be moving, understanding planning, migration, testing and more.

Learning Objectives:
Is the cloud right for you? What to expect from a cloud provider? Migration issues.
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 →

Things to Consider When Moving to the Cloud 2024 pdf
Wednesday May 22, 2024 10:30am - 11:30am CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level All
  • Audience Anyone thinking of moving their IBM i to the cloud.

10:30am CDT

Expo Open
Lunch in Expo from 12PM-1PM

Passport to Prizes Drawing in Expo 1PM-1:15PM
Wednesday May 22, 2024 10:30am - 1:30pm CDT
Exhibit Hall A, First Floor 1508 Houston St, Fort Worth, TX 76102

12:00pm CDT

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

1:30pm CDT

302: Database Modernization An Evolution not a Revolution
EVALUATION
Modernizing applications and neglecting the database? Think converting from DDS to DDL is enough database modernization? It may be enough, although there’s more to the database than the way it’s defined. This session explores database modernization techniques from an evolution perspective for continuous change. And, how that type of database modernization compliments application modernization.

Learning Objectives:
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 →

302 Database Modernization – An Evolution not Revolution pdf
Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Anyonme intereted in database moderization

1:30pm CDT

310: Elevate your SQL Capabilities with Lateral Joins, Pivots, and Window Functions
EVALUATION
Take your SQL skills to the next level with this session on Lateral joins, Window functions, and Pivoting. Discover how LATERAL joins simplify complex queries, learn new insights with Window Functions, and master the art of pivoting data for dynamic reporting. Whether you're an SQL pro or beginner, join us to unlock the full potential of these powerful tools and techniques.

Learning Objectives:
1. Learn how and when to use the Lateral keyword (along with correlation and cross joins).
2. Learn all the available Window Functions and how/when to use them.
3. Learn what pivoting is and how to setup an SQL procedure to do it dynamically.
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 →

Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Advanced
  • Audience Anyone looking to further their SQL skillset would benefit from this

1:30pm CDT

265: Ask Dr. *nix
EVALUATION
As Dr. *nix any questions about the PASE/Linux/USS/*nix environment and shell. Dr. *nix will have his laptop open and logged in to various systems to demonstrate solutions. The mysteries of shell scripting explored! If Unix-like environments are as puzzling to you as IBM i is to Linux weenies, this is your session!

Learning Objectives:
1. Learn more about the shell
2. Learn more about scripting
3. Learn more about utilities, pipelines, and shell job control
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 →

AskDrStarNix pdf
Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Programming - General
  • Session Level All
  • Audience Anyone with questions about the *nix facet of IBM i can benefit from this session.

1:30pm CDT

371: Secure Rest APIs
EVALUATION
Rest is a key technology in todays world. Security has to be at the for front of any conversation. In this session we will look at best practices in creating a secure Rest API experience. Leverage TLS to encrypt all communication, JWT as an authentication mechanism. Like many session, not only we will review the best practices, we will show the possibilities with live demos.


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 →

Secure Rest interactions on IBM i pdf
Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Programming - General
  • Session Level All

1:30pm CDT

163: What's the Fuss? Using Procedures and Service Programs
EVALUATION
This session discusses the advantages of using modern techniques in your RPG programs. After a short introduction to modularity in programming; we go step-by-step through the process of replacing called programs with sub-procedure modules and then converting these modules to procedures in a called service program.

Learning Objectives:
  • Internalize the benefits of using modular coding practices.
  • Understand the steps in coding modular subprocedures and service programs.
  • Develop reusable subprocedures and service programs.
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 →

Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level All
  • Audience Any developer that wants improve their coding methods and write modern RPG code

1:30pm CDT

290: How to Use SQL in RPG
EVALUATION
In this session, I will walk through how to use SQL in your RPG modules/programs. We will talk about static and dynamic concepts, how to write SQL in an RPG module/program, use of host variables, and more.

Learning Objectives:
1. To start using SQL in RPG modules/programs
2. Have examples and then be able to try at home
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 →

Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level Beginner
  • Digital Badge SQL
  • Audience Developers

1:30pm CDT

308: Best Practices for Preventing and Recovering from Ransomware
EVALUATION
You need to implement a ransomware preventions strategy to protect your IBM i. However, what happens if you do get compromised? What if you could restore back to a point before the ransomware attack occurred?

Come learn about how by the combination of external storage, Flash Copy and logical replication can be used to rewind a large database to a point back in time.

Learning Objectives:
* Understanding Ransomware prevention strategies
* Preventing most common ransomware vulnerabilities
* How to get back to a point before the ransomware attack
Speakers
avatar for Barry Kirksey

Barry Kirksey

Principal Sales Engineer, Precisely
avatar for Bill Peedle

Bill Peedle

Principal Sales Engineer, Precisely
avatar for Gavriel Meir-Levi

Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level All
  • Audience IBM i administrators and security professionals

1:30pm CDT

107: Why Wait? Discover the Power of IBM i Wait Accounting
EVALUATION
IBM i wait accounting is a powerful capability to determine what your jobs are doing when they are not using the CPU. This session will review wait accounting and how Collection Services data can provide insight into your wait times. It will then focus on how to use Job Watcher, the power of the data it provides, and how to leverage Performance Data Investigator (PDI) to analyze the data.

The presentation will work through example scenarios, showing performance graphs and describing what those graphs tell you. These examples will reinforce how you can use Job Watcher data in combination with PDI to analyze your performance data and resolve issues in your own environment

This session will reveal the power of IBM i wait accounting and the insight it can provide so you can optimize the performance of your applications and system environment.

Learning Objectives:
You will learn about IBM i Wait Accounting and how to use wait information and Job Watcher to improve the performance of your system and/or applications.
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 →

Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience Systems administrators responsible for managing their IBM i partitions, and in particular, managing performance. Application developers interested in using wait accounting to optimize the performance of their applications.

1:30pm CDT

116: Clean Up Your IBM i Disk
EVALUATION
How much disk storage do you have on your system? The most common answer is 'not enough!' Attend this session and find out where all that space went, what you can clean up, and what should be left alone. Learn about reporting, automating, and managing your disk space in IBM i. Develop a deeper understanding of the tools IBM has built into IBM i and how to leverage them to help keep your system clean. Especially learn how to leverage SQL to find consumers of disk QUICKLY! Walk away with a solid understanding of how to clean up your disk space both QSYS and the IFS.

Learning Objectives:
How to determine where all your disk space has gone.
How to clean up unused space in physical files.
How to search for object filling up the IFS
How to use *nix and PASE tools to work in the iFS.
How to use SQL to find disk users and usage.
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 →

Clean up your IBM i pdf
Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level All
  • Audience This session is for you if you are the person in charge of administering your IBM i and what's filling up it's disk storage!!

1:30pm CDT

134: Discovering your IBM i Data - For System Administrators issues
EVALUATION
There’s plenty information on IBM i that is so valuable for the daily tasks. Many commands, APIs, and SQL functions, let you gather information from your IBM i. You can exploit it online, or build your own database tables with it..

I like to dig into this info. There is always something new to discover. Particularly related to system administration activities: analyzing object sizing, resolving lock conflicts, obtaining job statistics, documenting TCPIP configurations, checking backup activities, investigating PTFs installed, and the list goes on and on.. All this information is as valuable to IT System Managers, as it is enterprise information to Business executives. You need to understand, evaluate, and take advantage of this knowledge.

In this session we will review the different types of system information you can find on IBM i, that are important for System Administrators. We'll see how to interpret and prepare the info for future exploitation.

Learning Objectives:
Identify different kinds of Information available in your IBM i.
Analyze different ways of obtaining and/or finding this information in your systems.
Prepare information for better use with modern tools.
Speakers
avatar for Cecilia Howlin

Cecilia Howlin

Owner, PYRAMIS S.R.L.
Cecilia Howlin has been working on this platform from the very beginning. On her first job at IBM Argentina, she learned S/38. And never left the platform, since she thinks it never appeared other operating system as good as this one.She usually worked on technical issues, like installing... Read More →

Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience System Administrators and Technical Advisors who need to find and exploit System Information

1:30pm CDT

309: PowerVS is the Destination, Understand the Journey!
EVALUATION
Join us as we enhance your Journey to the Cloud. PowerVS, is an enterprise solution that will allow you to deploy your Power IBM i Development, Disaster Recovery, High Availability and Production workloads into the IBM Public Cloud. We will discuss topics to take into consideration when creating your Roadmap for a successful migration to a robust and secure PowerVS solution.

Your traveling agents are Tonny Bastiaans WW offering manager PowerVS at IBM and David Contreras, IBMI i Power Specialist at Meridian

Learning Objectives:
1. Introduction/learning about IBM PowerVS.
2. Considerations when migrating to the Cloud.
3. Understanding how to plan to their Journey to the Cloud.
4. Slides will reflect some topics covering analysis and design when migrating.
5. Backup and Restore in the cloud will not have a tape drive, what now? Talk about solutions they will need to consider filling this gap.
Speakers
avatar for David Contreras

David Contreras

IBM Power Systems Specialist, Meridian IT
My over 35 years of experience range from Senior System Architect, Systems Analyst, Senior System Engineer, Project Manager, Technical Manager and I.T Specialist. I have the ability to work effectively with different levels of staff from executive to technical. I have traveled extensively... Read More →

Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Virtualization
  • Session Level All
  • Audience Admins, Managers, and others who are thinking or planning to migrate to the Cloud/PowerVS

2:45pm CDT

187: Streamline your SQL Routines
EVALUATION
The SQL procedural language makes it easy to create your business logic in stored procedures, triggers, and user-defined functions. Each of these routines have options that performance, but most programmers usually take the default option values without giving any thought to their impact. Learn about these overlooked performance options and other procedural language coding best practices.

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 →

Streamline SQL Routines pdf
Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Developers, data base engineers, performance analysts

2:45pm CDT

351: Simon’s Top Ten SQL
EVALUATION
Simon has written a lot about modern Db2 for i and SQL on his blog for the past ten years. In this fast past session he will take you through his top 10 favorites. You will have to attend to learn what these cool SQL tricks and tips are & how they can help you be a SQL super hero! (this will be updated to include any cool new things added to SQL in the intervening time)

Learning Objectives:
1. Get a quick overview of my favorite SQL table functions & views that allow you to get to information you did know you could do
2. Simple examples shown
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 351 Simon’s Top Ten SQL pdf
Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level All
  • Audience Examples anyone can use these examples to maximize their use of SQL to make their lives simpler.

2:45pm CDT

102: What IBM i Professionals can learn from NASA
EVALUATION
The NASA moonshot initiative in the 1960s and 1970s was groundbreaking in the use of information technology and advanced developments. Correspondingly testing and quality assurance was mandatory, extensive, and equally inventive. Using examples from history we will discuss current issues such as disaster recovery (the Apollo One fire), test coverage (Apollo 13), specifications and prototypes (the development of the LM), user ability and experience (Apollo 14), and further education development (Apollo 17).

Learning Objectives:
Explore disaster recovery, High Availability, testing, and implementation of quality assurance in a unique and informative way.
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 →

Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience
  • Session Level All
  • Digital Badge HA/DR
  • Audience Testers and Developers interested in furthering QA knowledge. Anyone who was interested in the Mercury/Gemini/Apollo program in the 1960s.

2:45pm CDT

128: Testing your DR Plan - Reality Check - 5 Yearly Must Haves
EVALUATION
Exercising the recovery elements that make up your Disaster Recovery Plan is an integral part of any effective business strategy. Business and Technology has evolved. Ensure you test for today’s digital business world and Cloud computing. Testing your plan is essential to see how to do it right.

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 →

128 Testing your DR Plan Reality Check PowerUp Dallas Final pdf
Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience

2:45pm CDT

364: I've Moved Over to Cloud. Now What?
EVALUATION
You've successfully migrated to the cloud, but what's next? Join this session as we explore essential strategies to extract maximum value from your cloud presence. Discover next-step initiatives that go beyond migration, ensuring your organization leverages the full potential of the cloud.

Key Points:

Optimizing Cloud Performance: Learn strategies to enhance the performance and efficiency of your applications and resources in the cloud.

Cost Optimization Tactics: Explore initiatives to manage and optimize costs, ensuring your cloud investment remains efficient and cost-effective.

Security and Compliance in the Cloud: Delve into best practices for maintaining robust security and compliance standards in your cloud environment.

Learning Objectives:
Session Highlights:

- Post-Migration Excellence
- Innovative Cloud Initiatives
- Real-world Case Studies
Speakers
avatar for Lief Morin

Lief Morin

GM, Cloud Services, Fresche Solutions

Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  IT Strategy
  • Session Level All

2:45pm CDT

267: Open Source WALSTIB
EVALUATION
The floodgates of Open Source via PASE on IBM i opened up about a decade ago. Where were we, where have we been, where are we now, where are we going, and how did we find ourselves in this handbasket? Presentation and open discussion of What A Long, Strange Trip It's Been.

Learning Objectives:
1. What has been the impact of open source becoming prevalent on IBM i PASE?
2. What have we learned to do, and what have we learned not to do?
3. What should we do next?
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 →

OpenSourceWALSTIB pdf
Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools
  • Session Level Intermediate
  • Audience Open source users who with enough experience to make some judgement calls.

2:45pm CDT

224: Build a Phenomenal Web App on IBM i in Under 10 Minutes — No Coding Required!
EVALUATION
Just released! Valence 6.3, the latest incarnation of the popular web and mobile framework for IBM i, includes a browser-based low-code development utility called Nitro App Builder (NAB), through which anyone with a solid understanding of their IBM i database can create dazzling web or mobile apps, including dashboards and data grids with download-to-Excel functionality, all in a matter of minutes! Running entirely on IBM i, the NAB tool can also be used to create intricate file maintenance apps, through which users can adjust content in one or more physical files — you control which fields they can see and/or edit.

All of this can be achieved with no coding, though IBM i developers can easily extend the app's functionality with RPG or SQL code to handle business logic as needed. Advanced programmers comfortable with HTML Living Standard and JavaScript code can take things even further, creating super elaborate data-entry apps that work hand-in-hand with server-side RPG logic through the Valence Portal.
The bottom line: With Valence, whether you're a seasoned RPG developer or a super user with intimate knowledge of your system's physical files, you can crank out highly functional web and mobile apps on IBM i in no time — no prior experience in web or mobile development required. Come to this quick demo session to see the latest release of the Valence framework, and how easy it is to quickly build and deploy such an app on your system.

All of this can be achieved with no coding, though IBM i developers can easily extend the app's functionality with RPG or SQL code to handle business logic as needed. Advanced programmers comfortable with HTML Living Standard and JavaScript code can take things even further, creating super elaborate data-entry apps that work hand-in-hand with server-side RPG logic through the Valence Portal.

The bottom line: With Valence, whether you're a seasoned RPG developer or a super user with intimate knowledge of your system's physical files, you can crank out highly functional web and mobile apps on IBM i in no time — no prior experience in web or mobile development required. Come to this quick demo session to see the latest release of the Valence framework, and how easy it is to quickly build and deploy such an app on your system.

All of this can be achieved with no coding, though IBM i developers can easily extend the app's functionality with RPG or SQL code to handle business logic as needed. Advanced programmers comfortable with HTML Living Standard or JavaScript code can take things even further, creating super elaborate data-entry apps that work hand-in-hand with server-side RPG logic through the Valence Portal.

The bottom line: With Valence, whether you're a seasoned developer or a database-savvy user, you can crank out highly functional web or mobile apps on IBM i in no time — no prior experience in web or mobile development required! Join us in this quick demo session to see this latest release of the Valence framework, and how easy it is to build and deploy such an app on your system.
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 →

Valence Demo pdf
Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programming - Frameworks

2:45pm CDT

395: Building APIs with Jakarta (Java)
EVALUATION
Speakers
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.

Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Programming - General

2:45pm CDT

423: A Practical Guide to IBM i Authority Collection
EVALUATION
This session explores practical applications for Authority Collection, including standard and creative use cases. Authority Collection can be used to reduce the security exposure of privileged user profiles and to lock down objects/libraries/IFS. We will cover these in detail, along with some “outside the box” ways of using this technology to answer questions and solve problems.

Learning Objectives: Learn how to:
1. Enable the different types of Authority Collection
2. Analyze data from the Authority Collection repository
3. Turn the data into actionable information
4. Discover creative ways to harness the power of Authority Collection
Speakers
avatar for Steve Riedmueller

Steve Riedmueller

Certified IBM i Admin - Speaker, Mentor, and Advocate, John Wiley & Sons, Inc.
I am a COMMON Certified IBM i Administrator with over 20 years experience on IBM i, as well as a COMMON speaker, N2i mentor, and IBM i advocate.I've been working on the platform since 2001 as a system admin/engineer. I have experience with OS upgrades and patching, system security... Read More →

PU24 Authority Collection Scripts sql
PU24 Authority Collection pdf
Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level All

2:45pm CDT

280: 35 Tricks & Treats
EVALUATION
Celebrating 35 years of IBM I, this presentation will cover 35+ tricks and treats discovered over the year, including Operating System, Built in commands, licensed packages, 3rd party packages, IBM and 3rd party hardware and appliances. Many of these tricks and treats were learned at COMMON over the years and many have helped justify the cost of a COMMON conference with the value of the knowledge gained.

Learning Objectives:
1. Remember some older concepts and technologies.
2. Learn a few legacy tips still relevant today.
3. Learn new technologies and tips to help move forward with IBM i.
Speakers
avatar for Rob Mineo

Rob Mineo

IBM i Senior Administrator/SME, (Independent)
I started my IT career in 1984. I started working on an IBM SYSTEM/38 in 1986, and upgraded to the AS/400 in 1989.  I worked for STERIS Corporation from 1991 until I semi-retired in 2022. Since then, I have worked as an Independent IBM i Administrator.  My career started as a programmer... Read More →

Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Beginner
  • Audience IBM i Administrators

2:45pm CDT

348: Architecture to Optimize IBM Backup with FalconStor StorSafe Virtual Tape Library
EVALUATION
FalconStor® StorSafe® Virtual Tape Library is software that works with any leading backup software, emulating physical tape drives and libraries while shrinking backup images with advanced compression and deduplication. This technical session will present how StorSafe Virtual Tape Library can modernize and optimize AIX and IBM i environments both on-premises and in the cloud. Five use cases will be explored, including on-premises backups, migrating workloads and legacy tapes from on-premises to IBM Power Virtual Server, hybrid cloud backup between on-premises and the cloud, backup and restore for Power Virtual Server-resident workloads, including use of IBM Cloud Object Storage with immutability for Ransomware protection, and replication in Power Virtual Server to another cloud for disaster recovery. Architectural diagrams for technical understanding will be presented and explained.

Learning Objectives:
1. How to optimize IBM i and AIX backup and recovery both on-premises and in the cloud for improved performance and reduced backend storage needs.
2. How to migrate IBM i and AIX workloads to IBM Power Virtual Server.
3. How to help protect against Ransomware with immutability in IBM COS.
Speakers
avatar for Niel Balsino

Niel Balsino

Regional Pre Sales Consultant, Falconstor
Niel is FalconStor’s Regional Pre Sales Consultant and is a systems engineer with 30 years of data center infrastructure experience. Niel began his professional career at UPS, where he first worked on the IBM i platform as an AS/400 Systems Programmer. While at IBM, Niel was a development... Read More →
avatar for Paul Cinquegrane

Paul Cinquegrane

Regional Sales Director, Falconstor
Paul is FalconStor’s Regional Sales Director for the Americas, and his team works with customers and partners on their pressing storage, backup, and infrastructure challenges. Paul started his professional career as a business consultant for PwC Consulting and IBM, and takes a consultative... Read More →

FalconStor POWERUp 2024 Presentation pdf
Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level All
  • Audience Both sellers and technical audience offering solutions to IBM customers

2:45pm CDT

142: Take Control of Your IBM i Prestart Server Jobs
EVALUATION
Prestart jobs are used to service requests from clients in the network. There are many uses of prestart jobs on IBM i, the most common is the database server. Prestart jobs present many challenges for how to understand what is happening on the system, what work requests these jobs are handling, and generally how to manage them. This session will review all the key characteristics of prestart jobs, provide many tips to better understand what is happening on your system, and review how you can use subsystem configuration to better manage your prestart jobs.

Learning Objectives:
The attendee will learn how to better manage prestart server jobs. The topics are many, but will include managing job logs and output, using Watches to debug intermittent problems, determining what the job is doing, including the SQL statement the job is running, how to determine the rate at which prestart jobs are being used and reused, subsystem configuration for prestart jobs, and much more.
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 →

Wednesday May 22, 2024 2:45pm - 5:00pm CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience System Administrators in environments with a lot of remote database access that uses either the QZDASOINIT or QSQSRVR jobs.

4:00pm CDT

393: Visual Explain - IBM's SQL Performance Show-&-Tell
EVALUATION
For many years now IBM have positioned SQL as the primary interface to the database on IBM i. At the same time, new capabilities are being added only to SQL, not to the native database interface.

We need a different tool to understand and analyze query implementation plans and feedback from the optimizer – the SQL component that determines the most effective way to deliver the data we ask for in SQL statements. Visual Explain is just such a tool, and it both shows us graphically what plan the optimizer has chosen, as well as tells us details about each step along the way. It can also give us suggestions on ways to improve performance of our queries.

Learning Objectives:
1. A brief description of optimization with SQL
2. The several ways of invoking Visual Explain
3. The various panes of the Visual Explain window
4. Some features of Visual Explain for managing how it behaves
5. Examples of improved performance after using suggested changes
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 →

Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Database

4:00pm CDT

115: Accelerate Your Excel!
EVALUATION
Are you intimidated by spreadsheets? Do you use Excel for the basics, but know you could be so much more productive with it if only you knew how? Do you cringe when other business people within your company ask for data in spreadsheet form? Excel is a wonderful tool, especially when paired with the IBM i! It's incredibly powerful, and can save you lots of time.

This session will begin with the basics and then progress through more advanced Excel topics such as functions, pivot tables, and array formulas. Using real life examples, you'll see how these new skills will help you in your career. Finally, we'll review powerful methods of pulling data from your IBM i directly into Excel spreadsheets! You'll even leave with sample code you can leverage within Excel to give you one click access to run an SQL statement from your desktop and have the results returned in a spreadsheet.

Learning Objectives:
After participating in this session, attendees should have the skills and techniques to:
- Understand the benefits of using Excel
- Use spreadsheets to improve your own productivity as well as that of your company
- Pull data from your IBM i directly into a spreadsheet in a variety of ways
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 →

Accelerate your Excel Steven Wolk pdf
Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Developing Business Skills
  • Session Level All
  • Award BRONZE
  • Audience Anyone who has ever had to work with a spreadsheet will benefit from the skills gained during this session. We will start with the basics, but even experienced Excel users will find useful information in this session.

4:00pm CDT

414: We’re Going to the Cloud, but How Do We Get There?
EVALUATION
Your leadership has decided your IBM i system is going to the cloud or you know that day is coming. Then reality sets in and the first question is, how do I move business critical apps on IBM i to the cloud and still keep the business running while I migrate? What choices should I make to reduce the risk? Are some clouds better for me than others?

This session will help you answer all these questions and give you the tools to plan a successful migration. We will also share some ideas on how to get the most from your cloud experience once you get there.
Speakers
avatar for Keith Zblewski

Keith Zblewski

Product Manager - IBM Hybrid Cloud, First National Technology Solutions
As a Product Manager at FNTS, Keith develops and grows cloud services to help clients modernize their IBM environment by leveraging hybrid cloud technologies. Keith uses 25+ years of experience on IBM Power Systems to help clients on their journey to cloud for applications running... Read More →

PowerUp 2024 Going to the Cloud pdf
Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  IT Strategy
  • Session Level All

4:00pm CDT

376: So You Want to Be a Contractor or Consultant
EVALUATION
Whether you're looking to retire from full-time work but still do a little work on the side, move to part-time work, or explore a new career path, consulting and contracting work for IBM i developers has become extremely popular. Learn from Bill Onion a consultant turned consulting shop owner and Robert Nettgen, a Director of IT turned consultant about their experiences in the field. Gain valuable insight into the pros and cons of contract work, what companies are looking for, and how to make yourself more marketable as a consultant.

Learning Objectives:
1. Insight into the world of contracting and consulting and tips on how to succeed
2. The pros and cons of consulting vs in-house developer
3. Learn the biggest challenges we see in the industry as consultants for a variety of IBM i run shops
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 →
avatar for Bill Onion

Bill Onion

Managing Director, Briteskies
I'm a life-long IBM i Fan! Basically born and raised on this awesome platform. Now, I'm leading the Briteskies team as we help companies to: 1) Leverage their investment in IBM i by extending the life of their RPG-based applications, 2) Integrate their IBM i systems with 3rd party... Read More →

2024 So You think You Want to be a Contractor pdf
Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Personal Development
  • Session Level All
  • Audience Anyone who is interested in becoming or hiring RPG consultants including RPG Developers, IT Directors, and IT Managers.

4:00pm CDT

408: Unleash the Power of RDi and VS Code for IBM I
EVALUATION
This session is designed for both seasoned developers and newcomers eager to enhance their productivity and coding experience on the IBM i platform. We will discuss practical tips, live demonstrations, and insights into how these tools can transform your IBM i development process, making it more efficient, enjoyable, and aligned with the evolving demands of the tech world.
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 →

Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools

4:00pm CDT

241: How Refactoring Helps Bulletproof Your Application
EVALUATION
Do you (or does your manager) doubt the value of refactoring your code into a modular design? This session goes in-depth about how you save time and create higher quality programs by refactoring into small, independent routines. We will discuss how this improves your ability to test and maintain your application over time, saving you tons of time in the long run.

This session is co-presented by expert developer, Scott Klement, and expert tester, Yvonne Enselman to help you see it from both perspectives.

Scott and Yvonne are the coolest people you'll ever meet. If you don't come to this session, you'll be very very sad.

Learning Objectives:
1. How refactoring into a modular design saves you time in maintenance.
2. How refactoring into a modular designed simplifies and expedites the testing process.
3. How much better your life will be.
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 →
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 →

Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programming - General
  • Session Level Intermediate
  • Audience Programmers who want fewer headaches.

4:00pm CDT

221: PHP Today and Tomorrow
EVALUATION
PHP has come a LONG way since it's inception as a quick and dirty web scripting solution. PHP also stands the test of time more than many other technologies given is wide adoption and adaptable roadmap. In this session we'll catch you to current PHP features and standard and get a glimpse into the future of the web scripting language that runs more than 75% of the known web.

Learning Objectives:
1. Review some the latest features of PHP.
2. Explore where PHP is headed
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 →

PHPPastPresentFutureV6.3 pdf
Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Programming - PHP
  • Session Level Intermediate
  • Audience Experienced PHP developers and those looking to compare other languages to PHP

4:00pm CDT

409: Modernization and 21st Century Skills - How to Move your Business into the 21st Century on IBM i
EVALUATION
Faced with pressure from upper management, learn how different companies moved their company's software into the 21st century. Why 21st century technologies, require systematic training. We will discuss the steps these companies have followed to modernize their business and IT staff spending significantly less money and time than moving off the platform.

Topics Covered
1. Modernization requirements
2. Modernization and Staff training
3. Where to find IBM i Developers for your company
4. What about me… where do seasoned developers fit in?
5. Basics of training developers in 21st Century skills
6. Myths and truth
7. A sad alternative
Spoiler alert - abandoning the IBM i platform was not the answer!
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 →

Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level All
  • Audience Managers and developers will benefit from this presention

4:00pm CDT

369: Why Should You Use HTML Living Standard and Not Static HTML to Build New UIs
EVALUATION
Users don’t accept two-dimensional experiences. They want rich media. They want real-time information. They want an interactive experience. And they want it all at their fingertips. Long gone are the days when users were okay with going to five different sources to get the information they needed. To build the modern user experiences users want, you need to use HTML Living Standard.

In this session, we’ll discuss:
o The value of HTML Living Standard, including bi-directional communication and responsive error handling
o How to integrate with third-party solutions to build an interactive, rich experience
o What are other ways to use HTML Living Standard, such as local storage, database queries, and leveraging local technology such as device cameras and location data.
Speakers
avatar for Jeroen van Dun

Jeroen van Dun

Product Manager, Rocket Software

Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Programming - UI
  • Session Level All

4:00pm CDT

332: The Expert’s Guide to Power Systems Cloud Security
EVALUATION
Many IBM i organizations are considering a move to the cloud or have already done so, but what does this mean for cybersecurity? Unfortunately, migrating your IBM i workload to the cloud will not eliminate cybersecurity concerns. No matter where your data resides, staying ahead of emerging threats requires a well-planned strategy and the cloud presents unique challenges.

This session will give you valuable insight from IT experts who’ve seen it all—Tom Horan, Vice President of mPower at Meridian IT, and Tom Huntington, Executive Vice President of Technical Solutions at Fortra.

Learning Objectives:
1) The division of security responsibility between customer and cloud provider
2) Cybersecurity best practices specifically for Power systems in the cloud
3) How to best configure your system to optimize performance and security
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 →
avatar for Tom Horan

Tom Horan

Vice President, Cloud & Managed Services, Meridian IT
I consult with clients regarding Cloud and Managed Services.

Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level All
  • Audience System Administrators, IT Managers, CIOs, IT Directors

4:00pm CDT

122: Tales from the Datacenter: Worst Practices in Systems Management
EVALUATION
We've all heard stories of things gone wrong, some were just bad, some were horrible, and some were just plain hilarious! The more you know of these gruesome Tales from the Datacenter the more likely you can avoid them.

This session will also allow for user feedback where the horrible terrible and very bad experiences of audience members will be added to the speakers experiences and used as educational tools to prevent those problems from killing us. You have been warned!

System admins, facility managers, developers - everyone has an opportunity to be the "hero" or the "zero" in their company. This session will help you learn from the mistakes of others and lessen the cases of you being the "zero".

Learning Objectives:
1. Learn how the "Titanic effect" of cascading failures and mistakes often compounds a problem.
2. Learn simple tips and tricks for avoiding being the cause of an outage or disaster
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 →

Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level All
  • Audience System admins, facility managers, anyone interested to learn how others got things wrong, and learn how NOT to do those things themselves.

5:15pm CDT

346: Database Features in VSCode
EVALUATION
Come explore the new Db2 capabilities in VSCode! These features, geared toward the database developer, enable full-stack development on IBM i. Come to this session for a demo and discussion of how to use these new features and why they may be beneficial to your workflows

Learning Objectives:
Understand the new Db2 features in VSCode.
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 Adam Shedivy

Adam Shedivy

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

Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Beginner
  • Digital Badge VS Code
  • Audience Application Developers or IT Planners

5:15pm CDT

209: Back Up to the Cloud with IBM Cloud Storage Solutions for i
EVALUATION
You can use Cloud Storage Solutions to store IBM i files securely in the cloud, eliminating the need for tape drives, tape cartridges, and courier services for off-site storage. ICC should also be a core part of your Hybrid Strategy. When your IBM i LPAR is already on the cloud, the only backup medium available is cloud storage! You can use Backup, Recovery, and Media Services (BRMS) for i with Cloud Storage Solutions to transfer virtual save media to and from the cloud. This session will cover backups of Cloud LPARs, and also the use of ICC to simplify your on-prem to Cloud hybrid strategy.

Learning Objectives:
1- How to set up and configure an IBM i environment in the cloud with ICC
2- Setting up Cloud Storage for ICC, with Proxies
3- Configuring BRMS for ICC
4- Using the above to simplify your on-prem to cloud migration
Speakers
avatar for Hrithik Govardhan

Hrithik Govardhan

Software Lead, Rocket Software
Long time Rocketeer working in the Security/MFA/Cloud spaces on Power and Z.

icc powerup2024 pdf
Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience
  • Session Level All
  • Digital Badge HA/DR
  • Audience Users interested in DR solutions in a Hybrid Cloud environment

5:15pm CDT

215: Benefits of Continuous Availability with Db2 Mirror for i
EVALUATION
Discover how Db2 Mirror for i is a continuous availability solution that can improve your business continuity. Also learn about some of the new and unique features of Db2 Mirror.

Learning Objectives:
1. Learn about how Db2 Mirror can be used to eliminate outages or load balance workloads
2. Learn about the newest features of Db2 Mirror
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 →

215 Db2MirrorContinuousAvailabilityBenefits pdf
Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience
  • Session Level All
  • Digital Badge HA/DR
  • Audience System Administrators or Business Executives looking for an RTO and RPO of zero.

5:15pm CDT

417: Data Corruption? Cyber Attack? Recover Your IBM i Data in Some Minutes Instead of Many Hours
EVALUATION
  • The creation of several daily recovery copies of your PROD partition is a must-have in today’s world of cyberattacks.
  • Without ‘Flash for i’, in the event of a successful ransomware or hacker attack, you have to proceed a long time-consuming restoration from tape.
  • With ‘Flash for i’ you can very quickly and automatically recover your IBM i data!
  • On top, it's extremely easy to create many consistent and immutable instant-copies, using few disk space!
Speakers
avatar for Pascal Ruckebusch

Pascal Ruckebusch

M81
Pascal Ruckebusch adopted IBM i at the exact beginning of AS/400, three decades ago, and never left it … Pascal's experience on IBM i covers system and application development, training and operations. Twice CTO of 2 major IBM business partners in France, his technical skills and... Read More →

Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience
  • Session Level All

5:15pm CDT

396: IBM Client Innovation Stories
EVALUATION
IBM i clients around the world are transforming their businesses with the integrated technology available in the IBM i portfolio. In this session, Steve Will, Distinguished Engineer and CTO of IBM i; Brandon Pederson, IBM i and Power Product Marketing Manager; and Douglas Gibbs, IBM i Product Manager, will highlight the business value clients are getting in application modernization, cloud, availability and more. Come hear what others are doing, and get inspired to innovate with IBM i!

Learning Objectives:
1. Learn about what peers are doing on the platform through real-life examples.
2. Get inspiration for new ideas and applications.
3. Acquire new knowledge about what is possible on the platform and ask questions.”
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 →
avatar for Douglas Gibbs

Douglas Gibbs

IBM i Product Manager, Program Director, IBM
Douglas Gibbs is the offering manager for IBM Power Systems I/O and works closely with the overall Offering Management, Sales and Development teams regarding all manners of I/O. Douglas has worked in the IT Industry for more than 25 years and has been in a variety of positions at... Read More →
avatar for Brandon Pederson

Brandon Pederson

IBM i and Power Product Marketing Manager, IBM
Brandon Pederson is the Product Marketing Manager for IBM i and Modernization within the IBM Power business. Prior to this role, Brandon was Content Marketing Manager for IBM WebSphere and Content and Community Manager for IBM Power. He has a degree in Marketing from Concordia University... Read More →

IBM i Client Innovation Stories POWERUp 2024 Session pdf
Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  IT Leadership and Management
  • Session Level All

5:15pm CDT

297: IBM i Integration - What's the Best Option For You?
EVALUATION
Looking to connect your IBM i to more outside applications and tools? What’s the best way to make those pathways? In this talk we’ll review the various industry options and when each should be used. We’ll discuss traditional integration paths, APIs, FTP, SFTP, Webservices, Middleware platforms, utilizing node, etc. in a clear pros and cons format. We will also discuss the security of each option and what needs to be taken into consideration for keeping your system secure when opening it up to the “outside world”. Attendees will leave the session armed with options and knowledge to make the choice that best fits their need, timeline, and budget.

Learning Objectives:
1. Learn about the various integration pathways and tools
2. Analyze integration tools in a pros and cons format from an unbiased source (we aren’t a tool provider and have no skin in this game!)
3. Identify key security concerns to keep in mind when making integration plans for the future
Speakers
avatar for Bill Onion

Bill Onion

Managing Director, Briteskies
I'm a life-long IBM i Fan! Basically born and raised on this awesome platform. Now, I'm leading the Briteskies team as we help companies to: 1) Leverage their investment in IBM i by extending the life of their RPG-based applications, 2) Integrate their IBM i systems with 3rd party... Read More →

2024 COMMON Integration pdf
Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Middleware (other)
  • Session Level All
  • Audience Modern language developers, System Admins, RPG developers

5:15pm CDT

287: Troubleshooting Tips and Tricks
EVALUATION
Have you ever tried to figure out a problem and you don’t know where to begin? Have you ever received a level 1 or level 2 help desk call and want to scream? How many times have you looked at your code and wanted to figure out how to troubleshoot the problem? This session is for you. We are going to give you some tips and tricks to help you overcome most common developer and user issues.

Learning Objectives:
1. How to troubleshoot user problems
2. How to add error handling to your programs.
3. How to overcome program issues.
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 →
avatar for Shelly Petty

Shelly Petty

Application Support, Everbrite LLC
I am a Junior Full Stack Developer at Everbrite LLC. We run our production applications on the IBMi Power Server. Primary languages are CL, RPG, DB2 SQL and Java, and the UI: HTML, CSS, JavaScript, Drupple, React, and Sencha.My position is a fast paced job and it includes Help Desk... Read More →

Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools
  • Session Level All
  • Audience Developers, Help desk support, n2i

5:15pm CDT

288: Build a Web Application on IBM i
EVALUATION
There are plenty of options when it comes to building and hosting an web application on IBM i so we'll take a look at a simple approach using current technologies. In this session we'll walk through building a CRUD application using open source tools. We'll create the solution, deploy the solution, secure it and then access it from the Internet. You'll be able to see all the pieces together to help you architect your next killer web app.

Learning Objectives:
1. Learn the common components of modern web applications
2. Put that knowledge to work building a CRUD web app.
3. Learn how to configure the HTTP Server for IBM i or Apache to serve your app.
4. Learn how to secure that application in your IBM i environment.
Speakers
avatar for Pete Helgren

Pete Helgren

Technical Program Manager, Bible Study Fellowship
Currently Technical Program Manager at Bible Study Fellowship. Pete is a developer with broad experience across multiple languages and platforms, including over 29 years of system 3X/AS400/iSeries/IBM i experience. He holds certifications as a GIAC Cloud Penetration Tester, GIAC Secure... Read More →

Build a web app iCrudApp pdf
Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Programming - General
  • Session Level Beginner
  • Audience Folks who want to get started with web application development in a simple and direct way

5:15pm CDT

178: Handling JSON With DATA-INTO and DATA-GEN in ILE RPG
EVALUATION
Two of the most significant features added to ILE RPG recently are the DATA-INTO and DATA-GEN opcodes. The most common use case is to read and/or create JSON files.

Since JSON has become crucial to IBM i businesses, these are must-know features!

Learning Objectives:
1, Learn the basics of the JSON format.
2. Learn about DATA-INTO and how to use it.
3. Learn about DATA-GEN and how to use 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 →

Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG

5:15pm CDT

305: The Cyber Security News Report - A Fun Look At Current Information Security News Stories
EVALUATION
You know that cyber security is a real issue - even if your boss doesn’t get it. Time to stress less about it and enjoy a fun look at real, Information and Cyber Security stories in the news. These are a sampling of current security news stories from the last 3 months.

Robert Nettgen will read a sampling of these stories in a dramatic, over the top, radio announcer style. While usually not mentioned by name, it’s a safe bet that some of these companies in the news have an IBM i server hiding in the data center. ?A list of the stories will be shared, so if your boss thinks this stuff is overblown and not a real risk, feel free to share some of these stories - or even the whole list.

Learning Objectives:
1. Gain a deeper understanding about the seriousness of cybersecurity
2. Learn from others' cybersecurity mistakes and how to avoid them in your own systems
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 →

Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level All
  • Audience CISOs, System admins, Managers and Directors of IT departments, and anyone else responsible for information security.

5:15pm CDT

403: SQL for System and Storage Management
EVALUATION
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.
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.

SQL for Storage and Systems Management pdf
Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Systems Management

5:15pm CDT

411: Leveraging IBM i (SQL) Services for Performance Management
EVALUATION
For system administrators figuring out how to call system management or performance related APIs on IBM i can be a challenge. Luckily, many of those APIs have equivalent IBM i Services that can easily be invoked using simple SQL statements. Learn how to take advantage of these services for everyday performance management tasks.

Learning Objectives:
1. Learn which IBM i Services are most useful for performance
2. See examples of how Services can be combined to do more advanced tasks quickly and easily
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 →

Leveraging IBM i (SQL) Services for Performance Management pdf
Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level All
 
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