What are PTFs? Why do I need them? How do I get them? Which ones do I need? Does my technology really need a refresh?
In this session we will describe PTFs, Cumultative PTFs, and other PTF Groups. We'll discuss how to find out what you have, how to get them, and how to put them in place. We'll help you determine what PTF strategy is the one for you and your system.
Learning Objectives: 1. What PTFs, and PTF Groups are and why you need them. 2. How to get PTFs and load them onto IBM i. 3. The use of Virtual Image Catalogs and Virtual DVD drives to save time and problems in the PTF process. 4. How to determine which PTFs you need for your system.
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 →
Monday April 24, 2023 10:15am - 11:15am MDT
Plaza Court 6
Come learn about all the content that IBM i has produced for common IBM i uses cases. This includes patch management, security and CI/CD. We will also show all the modules that have been produced and how you can build them into a playbook for your own use cases.
Kris Whitney is a Senior Technical Staff Member at IBM Rochester. He has worked at IBM for the last 22+ years and currently is leading the development for Db2 Mirror for i and IBM i Public Cloud enablement.
IBM i Access Client Solutions is a platform independent client that is supported running on multiple Operating Systems like Macintosh, Linux, and Windows. Familiarity with IBM i Access Client Solutions is very important as this is the future of the IBM i Access Family software on workstation operating systems. Being a platform independent product the install or deployment of IBM i Access Client Solutions onto the workstation is approached via approaches and mechanisms unique to this product. This session will walk though the tooling and capabilities available to deploy IBM i Access Client Solutions and the best practice approaches to get this new client out and updated in your enterprise including the newer support to automatically update from an IBM i!
Learning Objectives: 1. Learn best practice approach to deploying and updating IBM i Access Client Solutions
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 →
Bill Starke, the Chief Architect of the Power10 processor, will talk about Power10’s key features and capabilities and how they provide value for the IBM i platform.
William Starke is an IBM Distinguished Engineer and Chief Architect for Power microprocessors. Since graduating from Michigan Tech University, Bill has been employed by IBM for over 30 years in several roles, spanning mainframe and Power systems performance analysis, logic design... Read More →
Monday April 24, 2023 11:30am - 12:30pm MDT
Plaza Court 5
These days RDi and Merlin aren't the only options for IBM i developers looking for an SEU alternative. If those IBM products aren't your cup of tea or are beyond your budget, there's a new free tool that you may find intriguing.
In this session, Susan will introduce you to her explorations of the open source extension to Visual Code Studio called Code for IBM i. Come to see how to make the transition from the green screen to a powerful, expandable and more productive free alternative. Join Susan to see what all the hype is about and explore another modern way to develop RPG/CL/COBOL code for IBM i applications.
Learning Objectives: 1. Understand what Code for IBM i offers RPG/COBOL/CL programmers 2. Learn how to make a transition from green screen editors to a modern IDE
Susan's 30+ year career began as an application programmer for companies in Atlanta, Georgia, working on a variety of hardware and software platforms. She joined IBM in 1985 and developed a close association with the Rochester lab during the development of the AS/400 system. Susan... Read More →
IBM i often runs well with little or no focus on the performance of the system. But what if something unexpected does occur? If you understand the performance signature of your system when it is running well, it becomes much easier to identify problems if something goes wrong. This session will show you how to use the Performance Data Investigator to understand your day-to-day performance signature, as well as Graph History to understand long-term trends over weeks, months, and years.
Learning Objectives: 1. Learn how to interpret performance charts in PDI 2. Understand what wait metrics mean 3. Learn how to review historical performance data
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 →
Monday April 24, 2023 11:30am - 12:30pm MDT
Plaza Court 7
The integrated file system has become more integrated into every day processing for many customers over the years. The other integrated file system sessions discuss technical details of what it is and the different functional support provided. This session will discuss real life scenarios of file system usage and some common problems experienced by customers.
Learning Objectives: Understand some of the common problems experienced with the file systems and solutions to those problems
Margaret started working for IBM in 1983 on the S/36. From 1986-1994 she worked in various areas of what is now the IBM i including Authorization Management support of POSIX and the integrated file system. She worked on the port of SAP R/3 from 1994-1997. In 1998 Margaret joined the... Read More →
Audience System administrators and application developers that have experience with the integrated file system or have attended the other integrated file system sessions.
IBM i applications have been successfully serving business operations for decades. Modern technologies are enabling new levels of automation, scalability, resiliency, and flexibility. In this session, IBM i business & IT strategy expert Greg Patterson will discuss what application modernization and transformation is and the various options available to help businesses realize the full potential of their IT, while building on the value of their IBM i applications. Greg will also explore:
- Modernization approaches and automated solutions - Code and DB conversion - Cloud infrastructure and strategies - DevOps’ principles and tools - Open-source software
Greg Patterson has been in the IT field for over 20 years, the last 13 with Fresche Solutions where he is currently a Modernization Specialist. In addition to business development activities, Greg also coordinates pre-sales technical demonstrations and discussions, performs business... Read More →
Monday April 24, 2023 2:45pm - 3:45pm MDT
Plaza Court 2
You've heard a lot about Node.js, and know how to download packages, write interesting applications, and even connect to Db2 for i. But you are still a little hazy on how to integrate Node.js with all of the RPG, C, COBOL, and CL programs you have running on your system. This talk will focus on interacting with ILE programs from Node.js, including sending data to programs as parameters, getting results back in Node.js, and leveraging the power of Node.js to use the results in a novel way. By the end of the talk, you should have a better sense of how Node.js can interact with traditional IBM i programs and where to find answers to questions you have about Node.js and IBM i.
Learning Objectives: 1. What options are available to integrating Node.js with IBM i programs, commands, and workflows 2. How to interact with Node.js and IBM i from the same system 3. How to remotely interact with IBM i from Node.js on another system
I am a software engineer at IBM working on open-source software enablement for the IBM i. I am particularly knowledgeable about Node.js and Machine Learning software libraries. Feel free to talk to me about your open-source questions and tell me what open-source software you'd like... Read More →
Monday April 24, 2023 2:45pm - 3:45pm MDT
Plaza Court 6
Audience This session is useful for CIOs who think that Node.js and IBM i programs are not compatible and application developers who want to use Node.js with the ILE programs they already have written.
Web services have become a critical-to-know technology in business programming. This session shows you how to create them in ILE RPG on IBM i using software that is included at no charge with the operating system. Both the Integrated Web Services tool from IBM, and writing your own web service by hand with XML-INTO and DATA-INTO will be discussed.
Learning Objectives: 1. Understand what a web service is, and why they are useful 2. Understand the types of web services and their terminology 3. Demonstrate how to create a web service in RPG with Integrated Web Services 4. Demonstrate how to create a web service in RPG without a web service tool
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 →
Have you noticed a common thread in many of the features added to RPG in the last few years? RPG's enhanced support for arrays has been a dominant theme in many recent announcements.
We've had new ways to define them, including data structure arrays and varying dimension arrays. There also new ways to utilize them, such as the For-Each operation and new built-ins like %Split, %ConcatArr and %List, along with the new operator IN. And that's just the start!_
In this session, Susan will explore ways to put this new array support to work with code examples and use cases where they come in handy.
Learning Objectives: 1. Keep up to date with new powerful RPG language features. 2. Understand ways to take advantage use the new array support in RPG.
Susan's 30+ year career began as an application programmer for companies in Atlanta, Georgia, working on a variety of hardware and software platforms. She joined IBM in 1985 and developed a close association with the Rochester lab during the development of the AS/400 system. Susan... Read More →
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!"
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 →
Monday April 24, 2023 2:45pm - 3:45pm MDT
Plaza Court 5
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
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 →
With Symmetric Multiprocessing (SMP) now available as a no-charge feature in IBM i, you've gained access to a powerful feature that can significantly improve the speed of query execution. However, SMP must be approached carefully, as improper usage may produce lackluster results. This session will cover the inner workings of SMP, when to utilize SMP, and tools for controlling system-wide SMP usage.
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.
The cloud can be a great place to run your IBM i workloads but there are some differences in how you manage your system. This session will discuss common user admin tasks like backup/restore, networking, dynamically assigning resources, console, and software licensing.
Kris Whitney is a Senior Technical Staff Member at IBM Rochester. He has worked at IBM for the last 22+ years and currently is leading the development for Db2 Mirror for i and IBM i Public Cloud enablement.
When the number of IBM i nodes that are interacted with using IBM i Access Client Solutions increase the complexity of interacting with the IBM i ACS environment can increase. In this short 20 minute sessions we will go over some of the ease of use items that have been added that help when managing multiple systems. Users who manage a smaller number of systems may also find value in approaches taken.
Learning Objective: Learn how to leverage the IBM i Access Client Solutions capabilities directed at users having to manage multiple IBM i nodes in their environment.
Audience: IBM i ACS users who have to manage a large number of IBM i systems.
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 →
User Acceptance Testing should not be the only testing tool in your arsenal. Building a solid Python application is easy if you automate the boring testing process. In this session we’ll explore how easy testing can be in Python and how to get it done with several examples.
Learning Objectives: 1) Explore benefits of test Driven Development. 2) Work through a basic framework for architecting TDD. 3) Build an example case from scratch using Python and the unittest module.
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 →
Monday April 24, 2023 5:15pm - 5:35pm MDT
Plaza Court 2
...maybe! IBM i is very resilient OS, but there are still issues that can sneak up and actually bring an LPAR down. Learn about issues affecting IBM i, how to prevent and mitigate them before your system crashes. Learning objectives: Learn as an admin how to mitigate these and as a user/developer how to avoid contribution to them: 1. Temporary space growth 2. Journal Receiver growth 3. When job tables attack
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 →
Monday April 24, 2023 5:15pm - 5:35pm MDT
Plaza Court 4
Managing software updates can be a time consuming and even frustrating endeavor of IT shops. IBM i Access Client Solutions is working to simplify things by adding function to enable Auto Update capability. In this session I will show you how easy it is to setup IBM i ACS for automatic updates.
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 →
This session will examine working examples of IBM SQL PL stored procedures, for maintaining and inquiring upon an item master file. We will also touch upon a number of additional SQL PL stored procedure master file access patterns, that were generated out of one of my employer's tool packages, so that you are better prepared to provide and understand alternate, hybrid or equivalent techniques to RLA if and when they arise. As a set, the stored procedures are probably best described as a simple data layer. We will add an RPG ILE trigger program to capture after images in an audit log file as the final piece of the data layer (which will work correctly to capture all changes even those made via a stored procedure call from the web or other external environment).
IBM SQL PL is standardized across all of the versions of Db2. The source code for the SQL PL stored procedures and ILE trigger program will be provided to conference attendees, as we seek to show how one might separate data access and update logic from the high-level language program, and facilitate broader ease of use and consistency of Db2 for i data across the enterprise (interactive, batch and/or remote web server)).
We'll hit inquiry, delete, add, update, record lock and several combinations of these for dealing with a single database row in a mission-critical master file. The update stored procedures include working examples of those that achieve the optimistic row locking technique even from a remote web server, so that accidental overlays are prevented in high volume, multi-user environments (without first soft locking a field in the record and/or checking it). The optimistic technique reviewed does require use of commit/rollback boundaries from within your high-level language program to fully rollback, however row/record locks are removed with rollback without requiring journaling. An important idea also is that this technique significantly reduces the situations that necessitate actual rollback of updates (like inability to allocate the record) and is more fine-tuned than techniques relying on use unique time stamps or isolation levels.
We won’t have time to get into the language syntax required to consume the stored procedures, so the source code of high-level languages calling the stored procedures won’t be covered in this session.
Learning Objectives: 1. See and understand standard Db2 for i SQL PL and stored procedure syntax that performs all of the DB access used within this data layer pattern example 2. Seek to show how one might separate data access and update logic from the high-level language program, and facilitate broader ease of use and consistency of Db2 for i data across the enterprise (interactive, batch and/or remote web server)) 3. See differences in syntax and create steps for stored procedures using *LIBL and system naming
Sr. Developer (ERP & Web), Tegratecs Development Corp.
Rex is a Sr. Developer at Tegratecs and enjoys developing business applications in traditional IBM i environments and in web environments. Rex enjoys interacting with customers and designing business application software that solves problems and meets user needs. He is currently... Read More →
Audience Developers looking to see and compare data update techniques between an SQL PL data layer and traditional record level access (RLA), and see examples what might be considered a hybrid between the two.
The IBM i OS network communications has changed a lot since the AS/400 primarily communicated to workstations and printers using Twinax and to other computer systems using specialized communications lines. In some ways things are more complex because our IBM i OS systems communicate to a lot of other devices in many different ways, but in other ways things are simpler today because nearly all network communications are built on top of the foundation of Ethernet and TCP/IP.
This session will take a look at these foundation Ethernet and TCP/IP and how they are built up within the IBM i OS. We will look at your communications adapters, Line Descriptions, and IP addresses, subnets, routes and more including the commands and interfaces used to manage these.
We will also look at some of the most commonly used networking servers like Telnet and FTP and cover their basics of configuration, management and even troubleshooting.
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 →
Charles has been asked this question a _million_ times (Editor’s note: this might be slightly exaggerated…). He will demonstrate how similar functions are done using each technology and also what’s different between the two. Please let me know if this is possible.
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 →
Are you an IBMi developer looking to streamline your workflow and optimize your coding practices? Join Wim Jongman, CTO of Remain Software, for an informative presentation on RDi Debugging and Code Coverage. Wim will guide you through the features and capabilities of these powerful tools. Discover how RDi can help you identify and fix issues faster, avoid common pitfalls, and improve your coding practices. With practical tips, real-world examples, and easy-to-follow guidance, you'll be able to unleash the full potential of RDi for your IBMi development.
I am the CTO of Remain Software, home of TD/OMS and various other products. I am a committer and project lead for various Open Source projects.In my, not existing, free time, I like to gaze at the stars, shoot some pool, and enjoy my family.Please come and have chat at our booth... Read More →
Tuesday April 25, 2023 8:00am - 9:00am MDT
Plaza Court 7
Do you still use DDS to create physical files? Do you create an "extension" file when you need to add a field to an existing file? Are you worried that moving to SQL is too difficult? This session is for you.
Do you need to prevent bad data from from getting into your system regardless of how it's being added? This session is for you. Do you need to mask sensitive data, or protect data from unauthorized users? This session is for you. If you love working really hard, enjoy cryptic column-oriented codes, or the thought of recompiling all your RPG programs gives you a thrill, then maybe this session isn't for you.
Learning Objectives: 1. Convert DDS physical files to SQL tables 2. Add audit fields that are automatically updated 3. Use constraints to ensure data integrity 4. Use Row And Column Access Control (RCAC) to control access to your data
In everyday life when we asks questions like “Where is the nearest coffee shop” or “How far away is the airport” we are asking questions about geospatial data. Geospatial data is used to represent objects and events that occur on the surface of the earth. Geospatial analytics allows you to not only store geospatial data representing real location in your database, but to also compare and analyze geographic relationships and trends.
Learning Objectives: This session will introduce the set of new user-defined geospatial data types, scalar functions, and table functions that make up Geospatial Analytics with Watson and provide many real-world examples of how to use them.
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 →
Tuesday April 25, 2023 9:15am - 10:15am MDT
Plaza Court 4
Are you confused about IBM i Integrated File System security? You're not alone! Come to this session and learn the principles and best practices of securing your file systems. This session will cover more than just setting permissions (authority) on your objects. Other topics include virus scanning, controlling remote access, object audit, and more.
Learning Objectives: - Understand the semantics of integrated file system security - Learn other methods of securing beyond permissions including virus scanning, and more - Learn ways to manage and improve integrated file system security
Margaret started working for IBM in 1983 on the S/36. From 1986-1994 she worked in various areas of what is now the IBM i including Authorization Management support of POSIX and the integrated file system. She worked on the port of SAP R/3 from 1994-1997. In 1998 Margaret joined the... Read More →
Audience IBM i system administrators and application developers who wish to learn more about integrated file system security. Most beneficial for those that have working knowledge of the IFS or have attended the introduction and/or advanced sessions.
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 →
SQL is THE recommended interface from applications into your data. It is imperative to understand how to embed SQL or otherwise interface to SQL from RPG. We also need tools to enhance our use of SQL in our applications.
Learning Objectives: 1. Learn the basics of embedding SQL in RPG 2. Discover how RDi and ACS cooperate to enhance using SQL in our applications 3. Examine features in ACS that can have an impact on RPG development
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 at Ecolab. He also serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs... Read More →
A deep dive into the IDE that comes with Merlin: IBM i Developer. We’ll look at what it takes to use the IDE, setting up a Workspace, writing + compiling code, and how it integrates with git.
Learning Objectives: 1. Using Merlin IDE for the first time 2. Understanding git for ILE code 3. Managing projects through Merlin IDE
In this followup session to "Intro to IBM i Services (SQL) for Admins" we dig deeper into the capabilities of IBM i Services. This session will cover more complex and powerful use cases for monitoring, automation, and system administration.
Learn how to: 1. Join data from multiple IBM i Services to create ""SuperTools"" 2. Use QCMDEXC() scalar function (what's that??) 3. Create your own User Defined Function (UDF)"
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 →
When virtualizing IBM POWER Systems you have two primary choices for the hosting environment, VIOS and IBM i. Each of these offers strengths and each has weaknesses. In this session we'll go over more than 35 comparison points putting the two hosting choices side by side. Well cover technical capabilities as well as usability and visual items. We'll look at costs and requirements for each host.
Come and select your choice for a hosting partition or confirm that you've gone down the right track.
Learning Objectives: What requirements would lead you to select VIOS as your hosting environment What requirements would lead you to select IBM i as your hosting environment What are the costs or need-to-knows for each of the two hosts.
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 →
Tuesday April 25, 2023 9:15am - 10:15am MDT
Plaza Court 6
For RPGers, ILE brings with it procedures, modules, service programs, binding directories and binder language - it can get confusing!
In this interactive session, Susan will take her life in her hands by walking through a live step by step demonstration of some of those topics. In the process, we'll discover some of the problems that can occur - how they show themselves and how to fix or avoid them.
Our roadmap includes the following steps: - Creating a (very) simple RPG procedure in a module - How (and why) to put that module into a service program - Using a binding directory to simplify creating programs that use our procedure - Add a new procedure to the same module and service program - Guidelines for testing procedures in service programs - How to maintain the service program over time and avoid signature violations
To get the most from this session, it would be helpful if you're already familiar with the basic syntax of RPG procedures (aka subprocedures) and if you know a bit about what modules and service programs are.
Learning Objectives: 1. Understand the value of service programs 2. Understand how ILE entities interact with each other 3. Avoiding common pitfalls and frustrations with developing and maintaining ILE applications
Susan's 30+ year career began as an application programmer for companies in Atlanta, Georgia, working on a variety of hardware and software platforms. She joined IBM in 1985 and developed a close association with the Rochester lab during the development of the AS/400 system. Susan... Read More →
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.
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 →
The green screen isn't the only place where users can interact with IBM i file system data. Find out how and when to share your integrated file system to other platforms to let your users get more done with less effort. The latest updates to these file sharing methods will be included.
Learning Objectives: - Understand the file sharing options on the IBM i and their differences - Understand how to set up/use the file sharing options on the IBM i - Understand how policy settings can affect IBM i NetServer functionality
Margaret started working for IBM in 1983 on the S/36. From 1986-1994 she worked in various areas of what is now the IBM i including Authorization Management support of POSIX and the integrated file system. She worked on the port of SAP R/3 from 1994-1997. In 1998 Margaret joined the... Read More →
Over the past ten years RPG has transformed itself into a modern free form language. In recent the recent releases, 7.4 and 7.5, there have been additions there have been enhancements made that have passed many people by. Simon will demonstrate his favorite additions. (This will be updated with the RPG enhancements included in TRs before the conference).
Learning Objectives: 1. Learn Simon’s favorite additions to RPG, and the releases they can be used with 2. See examples of each one.
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 →
Focusing on the unique needs of IBM i environments we look at the testing needed for system and OS upgrades/migrations. From strategic test management and planning to risk management and resource allocation. Concepts covered include how to identify testing points, determine risk, and implement responsible quality assurance.
Updated to include templates and planning examples.
Learning Objectives: Understanding testing strategies, tactics, and design. Determine risks to system quality. Aligning testing with risk exposure._ When to use risk based testing, static testing, behavioral testing, or structural testing for best results.
Principal Architect for Quality Assurance on IBM i, Yvonne Enselman Professional Services
I am a Quality Assurance, Project Management, and Professional Services expert.Named IBM Champion 2024I have twenty-five years of experience in the IBM i industry starting in application development, transitioning through quality assurance, and into management. My passion has been... Read More →
Tuesday April 25, 2023 10:30am - 11:30am MDT
Plaza Court 5
Audience Audience: IT department personal who want to deliver solid testing for upgrades. Any system administrator who is concerned about the testing their system is subjected to. Consultants who are in the upgrade/hardware/admin sphere and want to enhance their testing offering. QA professionals who want understand what the technical team is testing and evaluating before hand off.
Best Practices is all about meeting IBM system compliance to achieve optimal results. Don’t let old myths or newly formed bad habits be the difference between success or a failure in service delivery. This session will examine V7R4/R5 Operating System, Configurations, Backups, Disaster Recovery, and Security Management best practices. We will discuss technical gaps, blunders, and recommendations. Hear actual lessons learned so you don’t make the same IBM i assumptions others have made.
Learning Objectives: IT is not a game of chance. Configuration management to produce optimal results
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 →
Bill Starke, the Chief Architect of the Power10 processor, gives his perspective on the technologies, architectures, and business conditions underpinning the past several generations of Power processors and systems.
William Starke is an IBM Distinguished Engineer and Chief Architect for Power microprocessors. Since graduating from Michigan Tech University, Bill has been employed by IBM for over 30 years in several roles, spanning mainframe and Power systems performance analysis, logic design... Read More →
So now that you understand the extent of your technical debt, the questions is, how to start addressing it. You can't undo 30 years of debt in 30 days, but there are ways to pick away at it little by little, without the stress and deadlines associated with a big bang event. Join us as we explore some simple techniques to eliminate instances of one of the most prevalent forms of technical debt - hard coding. Plus, we'll also discuss one more form of debt that we didn't cover in "On the Clock", one that will most certainly rear its ugly head in the future.
Most of my peers know me as the brains behind Inuendo, an open source database model and API layer. But I'm just an IBM i geek like everyone else. In recent years, I've tackled the sensitive topic of Technical Debt, and how to eliminate it. Check out my open source projects on GitHub... Read More →
Just released! Valence 6.2, 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 HTML5 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 HTML5 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.
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 →
It seems like a new open source language or project is ported to IBM i every week! How much water, fertilizer and other nutrients do they need to thrive along side of your RPG stack? This session will cover how to install OSS on i and know they are installed, how to use them and how best to integrate them into your IBM i development efforts. Learning objectives: 1. Know how to install OSS packages on IBM i. 2. Brief overview of how and why to use open source languages 3. Examples of integrating OSS into the IBM i environment
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 →
Take a modular approach to your IBM i modernization plan and see meaningful results faster. A one size fits all approach to modernization isn’t flexible enough in today’s ultra-competitive landscape. Go above the typical modernization plan with the ability to make more informed business decisions by extending and enhancing your applications with BI. BI allows companies to get instant insights and access to key business metrics. In this session you will learn:
Why modernization is important Reimagining your legacy apps Modular modernization basics Applying modular modernization to your business Enhance your modernization with Business Intelligence
Mike Mahan is LANSA’s Global Sales Director. With over 20 years of enterprise sales, management, and engineering experience, he has helped countless businesses and development teams modernize, integrate, and upgrade their IBM i systems. At LANSA, Mike has ramped up customer satisfaction... Read More →
Andrew Vaiciunas is a Senior Sales Engineer at LANSA. He has over 30 years of business systems analysis, design, and development experience and has been with LANSA for more than 20 years. Andrew’s technical expertise has allowed him to help hundreds of clients develop and maintain... Read More →
In this session, you will learn about the many aspects that an IBM i Security suite product will cover. This includes multi factor authentication (MFA), auditing and SEIM features, access control, authority elevation, and more.
Learning Objectives: 1. You will know what to look for when you consider adding a security product to your IBM I IT infrastructure. 2. You will learn how to take a holistic approach to IBM i Security 3. You will understand all the components to be considered for a comprehensive, effective security strategy for IBM i
I have been working with the IBM i platform for 35+ years, initially at IBM Rochester for 9 years, working on DB2 and the Storage Management. Then onto ShowCase Corp. working on Essbase OLAP engine for IBM i. Currently I with Precisely, (formerly Syncsort, Vision Solutions, and Lakeview... Read More →
Tuesday April 25, 2023 1:30pm - 2:30pm MDT
Plaza Court 2
Yes ‘Flash for i’ solution can perform all this ... and more : - quick roll back to a recent safe Database (or IFS) after a data loss or a corruption, - less than 2 minutes to update your Datawarehouse, - zero stress to do a role swap exercise (for HA validation). Find out how your external storage’s magic FlashCopy technology (SnapShot) enable you to save a lot of daily work. From your IBM i production LPAR ‘Flash for i’ solution automates, manages, secures and reports operations. Our customers found ‘Flash for i’ extremely easy to setup (less than 3 hours) and to operate. Your time is money! Note : ‘Flash for i’ solution is installed on more than 500 LPARs (170 end-customers) in 16 countries including Americas.
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 →
Do you have a disaster recovery plan? Are you really prepared? The difference in surviving in business depends on how well you prepare for the unexpected. This session breaks down the components of Disaster Recovery Planning as it relates building an effective Plan for the recovery of your Data Center. Testing your plan is essential as we examine critical points of failure, assumptions, technical gaps, and blunders.
Learning Objectives: DR methodology proven in actual Computer room and FEMA disasters Effective DR run books and testing for success
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 →
Do you have monolithic programs that you have to start breaking up into manageable pieces? Have you been tasked to start unit testing and don’t know where to start? This session is meant for you.
Learning Objectives: We will work through the benefits to modernizing your code and why you want to adopt unit testing. We will work through breaking apart monolithic programs and how to write their respective unit tests. We will discuss some best practices in unit testing and how you can take some of those best practices and apply them to your everyday development processes.
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 works as a Senior Programmer Analyst at Everbrite and her primary development... Read More →
The CL programming language is under appreciated and is used by many as just a JCL. In the past few releases a lot has been added to CL that gives the IBM I programmer an alternative to doing everything with RPG or Cobol. (This will include any additions to CL that will come in TRs between now & the conference)
Learning Objectives: 1. Learn Simon’s favorite additions to CL, and the releases they can be used with 2. See examples of each one.
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 →
Are you new to unit testing or looking to optimize your process? Join Wim Jongman, CTO of Remain Software, for a comprehensive overview of unit testing on IBM i. In this session, we'll cover the basics of unit testing, including why it's important, how it works, and what tools you need. We'll also dive into best practices for unit testing on IBM i, including effective testing strategies and integration with your development workflow. Then, with practical tips, real-world examples, and a friendly, approachable style, you'll learn how to master unit testing on IBM i.
I am the CTO of Remain Software, home of TD/OMS and various other products. I am a committer and project lead for various Open Source projects.In my, not existing, free time, I like to gaze at the stars, shoot some pool, and enjoy my family.Please come and have chat at our booth... Read More →
Tuesday April 25, 2023 2:45pm - 3:45pm MDT
Plaza Court 6
PHP is moving fast these days. PHP 7.4 is out of support by the community, while PHP 8.1 and 8.2 include features that help developers reduce bugs and enjoy writing high quality code. In this fast-paced session, Alan will share his favorite new features in PHP 8.1 and 8.2, and how to prepare for them. Alan will also show tips on upgrading from older releases and will go over recent security enhancements.
Learning Objectives: 1. Power of PHP in today's market with IBM i 2. Why and how to get on a regular upgrade cycle with PHP 3. Features and benefits of PHP 8.1 and 8.2 for security, performance, and ease of programming
Companies across industries are leveraging the benefits of the cloud, while also maintaining control and flexibility. IT leaders are achieving this by adopting a ‘cloud smart’ strategy, and carefully considering which workloads are best suited for the cloud, rather than blindly moving everything into it. By adopting hybrid models and optimizing certain workloads (such as testing, DevOps, and OS upgrades), IBM i organizations are capturing the benefits of the cloud, while also avoiding unnecessary technical debt.
Raymond Hammell brings a wealth of experience in Cloud, High Availability, and Disaster Recovery Solutions. His expertise lies in defining Cloud Solutions, rigorous DR and HA Plan testing, and architecting solutions for both Fortune 100 corporations and SMEs. As a certified Master... Read More →
Understanding how to use git with VS Code or Merlin IDE, writing RPGLE/COBOL/etc locally, deploying and building to IBM i. You'll also see the available git and IDE tools to make your development life so much simpler.
Learning Objectives: 1. Available tools in your IDE to make writing code locally much simpler 2. What git tools are available to make you a better developer 3. Benefits of moving source code into git
I come from the world of the traditional RPG developer. And I arrive bearing open-source peace offerings for my fellow IBM i travelers. When I started my IBM i development journey back in the eighties I was constantly developing custom RPG programs and CL command utilities to help get work done easier. After 30+ years the journey continues to discover the perfect integration for IBM i.
Even though there is no perfect integration technology, in this session you’ll learn about useful ways to integrate between traditional languages such as RPG and CL and the open-source stack available on IBM i, allowing you to do many of the things you thought were impossible with RPG.
Our RPG and CL integration examples will primarily focus on Python. However, this integration approach is relevant for any of the open-source languages or applications, including Python, Bash Scripts, QShell/PASE commands, Java, PHP, Node.JS and others.
By attending this session and adopting the techniques learned in this session your RPG and CL utility toolbox has just tripled in size. You won’t want to miss this inspiring open-source technical session.
Learning Objectives: 1. Learn the benefits of Integrating open-source apps with RPG and CL 2. Learn the development pattern for using open-source with RPG and CL 3. Adopt and utilize the provided RPG/CL/Open-Source examples right away in your own shop
Richard has over 30 years of software development, system integration, document management and process automation experience on all system platforms including IBM i, Windows, Linux and Mac. Richard started RJS Software Systems in 1990 and served as President and CTO until the company... Read More →
Tuesday April 25, 2023 4:00pm - 5:00pm MDT
Plaza Court 7
Audience Any RPG, CL or Open-Source developer looking to expand their usage of RPG and CL to quickly integrate the ability to take advantage of open-source apps and utilities written in bash, PHP, Python, Node, Java and more.
SQL is THE recommended interface from applications into your data. This session focuses on how using SQL services extends what you can do in these application.
Learning Objectives: 1. Learn what SQL services are and where to get more information 2. Focus on SQL services that are most useful for developers
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 at Ecolab. He also serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs... Read More →
Tuesday April 25, 2023 4:00pm - 5:00pm MDT
Plaza Court 5
We’ll talk about many examples of how to write modern RPGLE correctly, as well as what not to do. From this fairly technical talk, you’ll walk away with new methods on development and coding standards.
Learning Objectives: 1. Learn how to not write bad code 2. Learn how to write good code 3. Pick up some new best practices when writing RPGLE
Like any new offering, the Geospatial Analytics support features cool technology with lots of bells and whistles. When integrating a new technology like this into your applications, it's easy to focus just on the functional implementation and to overlook the performance considerations.
Learning Objectives: In this session, learn how to streamline a Geospatial Analytics solution by leveraging the Geohash functionality and other advanced features.
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 →
Tuesday April 25, 2023 5:50pm - 6:10pm MDT
Plaza Court 7
One of the coolest new features in ILE RPG is the ability to overload your prototypes! With overloading, you can accept differing parameter types while keeping the same routine name. Overloading can be used with programs, but the biggest value comes when using it with subprocedures.
Learning Objectives: - What is overloading? Why use it? - Technical details of parameters, candidates, etc - Full examples you can use yourself
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 →
Do you work in a sea of legacy RPG programs? Have you slowly started embedding SQL into your RPG programs, but struggle with taking full advantage of what SQL has to offer? I struggled with this, and still do. Join me as I walk through a real life case study where I reduced my RPG program from hundreds of thousands of I/O to one.
Learning Objectives: Learn one code monkey's approach to incrementally increasing the SQL statement to include all the data needed to process.
Gregory Simmons is a Software Engineer at P.C. Richard & Son. He is a COMMON certified Application Developer – ILE RPG on IBM I on Power. He is also a registered instructor with IBM’s Academic Initiative and an RPG and IBM i instructor at Scott Regional Technology Center, where... Read More →
Tuesday April 25, 2023 5:50pm - 6:10pm MDT
Plaza Court 5
In the past few releases and TRs IBM has introduced a number of SQL views and table functions that allow anyone to do things to spool files that they would have had to use APIs or complex programming. Become the superstar at your company with the knowledge on how to do all of this with just a few SQL statements.
Learning Objectives: 1. How to find the biggest/oldest spool files on your systems. 2. How to delete old spool files. 3. How to extract data from a spool file into spreadsheet format 4. How to build views over spool files, even when they are not there 5. How to copy one spool file to PDF 6. How to copy many spool files to PDF
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 →
Learn through live demonstrations how to take advantage of all the exciting new enhancements in PowerHA with a focus around automation, simplification and integration.
Learning Objectives: 1. A brief review of PowerHA_ 2. Learn and see the exciting new features 3. A preview of what is to come in the future
In addition to his role as Associate 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... Read More →
Wednesday April 26, 2023 8:00am - 9:00am MDT
Plaza Court 6
If you’ve ever done web app development on IBM i you probably know that you can use RPG to write CGI based web applications and services. However these apps require you to use an external web server such as Apache to host the application and there is complexity in debugging these apps. You can also use IWS to host RPG-based web services, but it requires a special Java server to make those services available to the outside world which can make life unnecessary complex.
What if there was a way to create fully self-contained web applications and web services with RPG? This session will cover how to quickly get started creating your own self-contained, RPG-based web applications and web API servers. You will learn a pattern for creating simple RPG-based web apps. You will learn how to expose DB2 data and existing RPG logic as web services. And you will learn how to interact with and debug your new services from RPG as well as other open-source languages, external web applications and services.
Attend this session to see how quickly your RPG application business logic can be modernized and used in web apps and web services without re-engineering your entire RPG code base.
Learning Objectives: 1. Use RPG as a web application server 2. Use RPG as a REST web API server 3. Eliminate the need to use an Apache web server 4. Re-purpose your existing RPG business logic easily with web apps and services
Richard has over 30 years of software development, system integration, document management and process automation experience on all system platforms including IBM i, Windows, Linux and Mac. Richard started RJS Software Systems in 1990 and served as President and CTO until the company... Read More →
Wednesday April 26, 2023 8:00am - 9:00am MDT
Plaza Court 4
Audience Any RPG developer looking to modernize their RPG code and easily make business logic available in web apps and services without resorting to open-source languages.
Network communications require encryption. This session provides the foundation to configure and manage network security on IBM i using Digital Certificates assigned to Application Definitions to establish industry standard Transport Layer Security (TLS) encryption.
Learning Objectives: 1. Understand the cryptography related to Transport Layer Security. 2. Use the latest Digital Certificate Manager web application to create certificates. 3. Assign the certificates to application definitions and perform verification tests to ensure required TLS protocols and cipher suites are selected.
Robert Andrews is a Principal Security Consultant, Senior Technical Staff Member (STSM), and the Team Lead for the IBM i Security and Authentication Technology Expert Labs team in Rochester, MN. He is an IBM certified Thought Leader and The Open Group certified Distinguished Technical... Read More →
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 →
You will gain a new perspective on how to separate PHP from HTML. Your application doesn't need to be written all in one. Take advantage of API's and Javascript. Utilize front-end frameworks live VueJS
Learning Objectives: Divide the load. Use different team members to achieve your goal.
Guido Faecke has been working with IBM midrange systems since 1989. In the year 2000 he discovered PHP and is writing software in PHP ever since. While contributing to several Open-Source projects, he promotes best practices and good coding standards every chance he gets. His current... Read More →
Wednesday April 26, 2023 9:15am - 10:15am MDT
Plaza Court 4
Gluing applications together in the 21st century relies on loosely coupled services. Python has several methods for provisioning and consuming web services. In this session we will explore several approaches to leveraging APIs or Web Services including some of the powerful modules in the python world that make this process incredibly simple.
Learning Objectives: 1) Review of Python fundamentals. 2) Explore modules used with services 3) Review several examples of services consumption and provisioning
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 →
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.
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 →
This session explains how the SQL Plan Cache is used by Db2 for i to support the execution of your SQL & non-SQL queries. In addition, you'll learn about the various Plan Cache related tools & services that you can leverage to identify and remedy query performance problems.
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 →
One of the challenges of managing IBM i source with Git is we don't want to Build ALL of our objects for a few changes like a Java project. We want just the changes specific to our project. How do we get JUST those changes and what impact does that have on branch management, merging and conflicts? I thought Git made concurrent development easier, why is this SO HARD?
Now that we at Arcad have been providing Git integration for a number of years we have experience on why a rebase or a fetch from master can have unintended consequences. Well what do we DO with stale branches that conflict with master if we can't fetch? Ho can we just avoid a conflict or resolve it with the least pain?
Learning Objectives: 1, Recognize how IBM i source and business requirements require different branch management. 2. Best workflow for IBM i shops with concurrent development 3. Most efficient way to resolve or avoid merge conflicts
Jeff Tickner has worked in Change Management on the IBM I for 17 years at different companies. He is certified in Rational Team Concert as well has having experience with other Change Management packages from SourceSafe to Subversion. Jeff currently works for ARCAD Software, an international... Read More →
Wednesday April 26, 2023 10:30am - 11:30am MDT
Plaza Court 4
SCM and Containers and Pipelines and Private cloud oh my! DevOps can sound confusing and even overwhelming, but fear not! It really isn’t all that hard… This session will center on an easy, non-technical demonstration where we’ll compare and contrast what you’re doing today with “best practices” in DevOps. From there, we’ll give you some quick and easy baby steps to get you started on the DevOps path.
Learning Objectives: 1. Learn DevOps terminology 2. DevOps ROI 3. Compare and Contrast with existing development/operations 4. Baby steps to start on the DevOps path
Andrew Clark has been working on Enterprise platforms for more than 30 years, starting his career as an intern at IBM working on the secret "Mankato Project” with RS/6000, mainframe, and pre-release versions of OS/400; advancing from testing to a Team Leader on the QQ (Query) team... Read More →
Audience Existing developer and operations personnel who want to implement or learn more about DevOps, and C-level decision-makers that need to understand DevOps better and how to cost-justify their decisions
Case Study of 3 DR Events: Can your IBM i survive a sudden, unplanned event? Learn from multiple computer room and regional disasters, and experience from over 400 recovery tests to know your DR Solution works in an actual Disaster.
People, Technology and Geography are common critical points of failure.
Learning Objectives: Impact on People Picking the right Technology Location, Location and Separation .
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 →
This presentation will cover various best practices in using the integrated file system and integrated file system APIs to improve the performance of your applications.
Learning Objectives: Learn what features are available that can help with application performance and apply them to new and existing applications which use the integrated file system.
Margaret started working for IBM in 1983 on the S/36. From 1986-1994 she worked in various areas of what is now the IBM i including Authorization Management support of POSIX and the integrated file system. She worked on the port of SAP R/3 from 1994-1997. In 1998 Margaret joined the... Read More →
In order for developers to improve productivity by reusing code created by others, a plan for encouraging reuse must be put in place. RDi provides the ability to share Templates and snippets between developers. This session explores how to capitalize on that capability.
1. Improving developer productivity with Templates & Snippets 2. Creating Templates & Snippets 3. Sharing Templates and Snippets with other Developers
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 April 26, 2023 10:30am - 11:30am MDT
Plaza Court 2
Be prepared to hear ideas and concepts that will make your head spin as Scott Forstie and Carol Woodbury shake up the world of IBM i Security, mixing the dull foundational concepts of IBM i Security with the vibrant and rich features of SQL. Before you know it, you’ll be sipping on the refreshing features of SQL and pouring out your current processes that have reached their ‘consume by’ date. A note of caution, however. You may leave a bit shaken (but not stirred.)
Learning objectives: 1. Foundational knowledge of IBM i security 2. Why and how SQL is useful to the Security Officer and beyond 3. Have an idea of where to start and how
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 →
With over 25 years experience in the area of IT security, Carol is known world-wide as an expert in the area of computer security. During her career, Carol has architected security solutions for Fortune 100 companies as well as small and medium-sized organizations. Carol is passionate... Read More →
FIPS 140-2 Level 4 is the gold standard for protecting sensitive data and IBM i on Power Systems provides an efficient solution to meet this standard with Hardware Security Modules called IBM cryptographic coprocessors. As IBM i users and software vendors move to cloud-based solutions, some find it complex and costly to use cryptographic coprocessors in the cloud. For example, PowerVS and other cloud solutions running IBM i do not support this technology natively due to the cost and complexity of delivering cryptographic hardware in a shared cloud computing model. To address this market need, a new solution was needed to deliver a flexible and scalable cryptographic solution for all IBM i users. FNTS, an IBM managed services provider and CLAI Payments, a payment solution provider worked together with IBM to build an encryption-as-a-service solution using a hybrid cloud architecture and IBM i software. Learning Objectives: • Learn how to leverage an IBM i encryption solution as-a-service to avoid the cost of buying and managing cryptographic hardware. • Learn how this solution provides an extra level of defense against data breaches by provisioning encryption keys at the edge separate from encrypted data. • Learn best practices for consuming IBM encryption technology from external applications to ensure best response time, availability and agility while adapting to ever-changing security requirements.
Fernando Carmona holds a Computer System Engineering degree from Universidad Nacional of Colombia, and has had grad education in Online System Design from the Okinawa International Center (Japan), as well as in Industrial Process Automation from Universidad de Los Andes in Colombia. An... Read More →
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 →
Have you been curious how you can integrate IBM i with Ansible? Do you want to manage IBM i and other systems from one interface? Do you want to automate your workflows to free up time to be more productive? With Ansible, you can manage your systems and deploy applications all from one place. We will cover the basics of Ansible, how to set Ansible up on IBM i, and how to automate IBM i workflows with playbooks. These integrations will include executing commands, configuring systems and applications, managing fixes, and deploying applications. We will also cover and demo the AWX Project, the Red Hat open-source community project that gives a modern user interface for managing your Ansible playbooks and systems. By the end of the session, you should be able to understand how Ansible fits into your wider technology infrastructure, and how it can make working with IBM i easier than ever before
Learning Objectives: 1. Learn how to create an Ansible instance to manage IBM i systems 2. Learn how to manage IBM i with Ansible 3. Learn how AWX can simplify managing your workflows
I am a software engineer at IBM working on open-source software enablement for the IBM i. I am particularly knowledgeable about Node.js and Machine Learning software libraries. Feel free to talk to me about your open-source questions and tell me what open-source software you'd like... Read More →
Wednesday April 26, 2023 10:30am - 11:30am MDT
Plaza Court 6
Audience This session will benefit system administrators looking to automate system management and developers looking to automate application deployment.
Nobody likes change, but change is inevitable...especially in your IT environment. To make matters worse, system administrators are blamed for everything. Think about it...How many Monday's have you barely walked in the door, only to find the production system is in trouble and management is in your office screaming? Now you must figure out:
What changed? What caused the problem? How was the system impacted? This session will put you in a position to better answer the tough performance questions AND help you build a performance management culture of proof.
In this session you will learn: 1) The methodologies to do powerful What’s Changed Analysis for all critical performance metrics. 2) The mission critical performance management tasks that most system admins fail to do every month...which can cause performance problems later. 3) How to change your IT performance management culture from a "reactive" mode to a successful "proactive" mode. 4) How to measure the impact of memory tuning changes 5) How to measure the impact of Capacity Planning projects when the upgrade didn’t go well
As a 30+ year veteran in the IT industry, I have always been passionate about both customer service and helping others. I have been to hundreds of sites worldwide, and it has been one of the most rewarding opportunities of my life to work with the talented and dedicated people in... Read More →
Wednesday April 26, 2023 10:30am - 11:30am MDT
Plaza Court 5
OmniFind Text Search Server on DB2 for IBM i provides complex text search capability on many different kinds of documents such as XML, HTML, PDF, MS EXCEL, MS Word and lotus documents. DB2 for IBM i integrates this powerful text search capability into the SQL language. Come and explore this new powerful Text search engine and learn how you might incorporate it into your applications.
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 →
Wednesday April 26, 2023 1:30pm - 2:30pm MDT
Plaza Court 6
You've probably heard about "Cloud-Ready" Next Gen Apps, but do you really understand what that means? "Cloud" means many different things to many different people, and some Cloud methodologies don't fit well into typical IBM i development; but there are also unquestioned advantages to Cloud-enablement that you can take advantage of today!
This session will help you understand all of the cloud-related terms like "Public Cloud", "Hybrid Cloud", "Containers", "Virtual Machines", IaaS/PaaS/XaaS etc. and clarify on-prem vs distributed advantages and disadvantages.
Learning Objectives: 1. Learn what NextGen Apps actually are 2. Learn what "the Cloud" actually is 3. Understand Cloud terminology 4. Understand advantages (and disadvantages) to different cloud methodologies
Andrew Clark has been working on Enterprise platforms for more than 30 years, starting his career as an intern at IBM working on the secret "Mankato Project” with RS/6000, mainframe, and pre-release versions of OS/400; advancing from testing to a Team Leader on the QQ (Query) team... Read More →
Audience Developers and operations personnel who want to implement or learn more about the Cloud, and C-level decision-makers that need to understand Cloud and Next Gen Apps better and how to cost-justify their decisions
IBM i continues to evolve and adopt emerging storage technologies such as NVMe (Non Volatile Memory express)? This session will focus on the configuration and administration of new storage options like NVMe.
Dan Sundt is an IBM i product manager. He has the responsibility for the IBM i business, including defining and guiding future directions and strategies. He works with the IBM i sales, marketing, and development teams as well as customers and partners to ensure that the IBM i operating... Read More →
Wednesday April 26, 2023 1:30pm - 2:30pm MDT
Plaza Court 5
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. 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 focus on backing up Cloud LPARs to Cloud Storage, and discuss ways to get the best performance out of your setup.
In order to perform testing the right way, you need to automate. This is beyond just scripts that run, but building out the entire test landscape. With Next Gen Apps, the ability to spin up, load, test, and remove is key. Whether this is in the cloud or on premise, automating the creation of your test environments and data is critical to a successful DevOps implementation?
So what's involved : Cloud service provider (or on prem), a subset of production data that is protecting PII data, pipeline of tests, producing a record of those tests, and much much more.
Learning Objectives: 1) Discover how test data management plays a role in testing 2) Understand how and why test cases need to be managed 3) Learning the right way to test your Next Gen App.
Jeff Tickner has worked in Change Management on the IBM I for 17 years at different companies. He is certified in Rational Team Concert as well has having experience with other Change Management packages from SourceSafe to Subversion. Jeff currently works for ARCAD Software, an international... Read More →
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 April 26, 2023 1:30pm - 2:30pm MDT
Plaza Court 4
Audience Are you a Project Manager, developer, or a QA specialist, see how learning how to test the right way can benefit application development but the companies bottom line.
Join Wim Jongman and the Remain Software team as they reveal the power of ChatGPT, customized for IBMi Admins and Developers. In this captivating session, learn how ChatGPT can enhance your work, from crafting SQL instructions to decoding legacy code. Additionally, gain exclusive access to a free ChatGPT client, seamlessly integrated with RDi. Bring your laptop and prepare for a groundbreaking experience.
I am the CTO of Remain Software, home of TD/OMS and various other products. I am a committer and project lead for various Open Source projects.In my, not existing, free time, I like to gaze at the stars, shoot some pool, and enjoy my family.Please come and have chat at our booth... Read More →
CL is an underappreciated language in the IBM i world. Many hang on to the ways and methods they code CL from when they were first learning how to use IBM i. Like all languages CL has evolved over many releases to become something more than it ever was, to a point where any modernization project ought to include refactoring your CL programs. Join me as I walk through examples of CL code from our past and how it can be refactored into a format that a modern developer would easily understand.
Learning Objectives: 1. Learn how to use true structured programming in the CL language. 2. Learn how to integrate CL into Service Programs. 3. See examples of refactored CL code & learn how much easier it is to support & maintain."
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 →
The unthinkable has happened and your organization has been breached. Or someone clicked on the wrong link and ransomware has run rampant throughout your organization. Does your incident response plan include IBM i? During this session Richard Dolewski and Carol Woodbury will discuss the steps you’ll want to take now to reduce risk to IBM i and to ensure that you can recover your Business. Real-life incidents and scenarios will be discussed so that you can learn from others’ mistakes.
Learning Objectives: 1. Understand the steps you can take to secure your system to reduce the risk of data loss or being infected with ransomware 2. Learn about the backup technologies and best practices to support both disaster recovery of your Business as well as keep you protected from ransomware 3. Understand the key components of an incident response and where IBM i fits into the continuity of your Business.
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 →
With over 25 years experience in the area of IT security, Carol is known world-wide as an expert in the area of computer security. During her career, Carol has architected security solutions for Fortune 100 companies as well as small and medium-sized organizations. Carol is passionate... Read More →
You're doing more and more with SQL to define a data set for various purposes. Many times that purpose is for reporting to your stakeholders in the business. This session will show how you leverage SQL to define the data set, but use Db2 Web Query to take that SQL and build charts/graphs and dashboards in a jiffy over that SQL result set. Incorporating Db2 SQL and web query simplifies the delivery of requests for information!
Learning Objectives: 1. Learn how to speed up the pace to respond to business requests for information using SQL and web query. 2. Experience detailed examples of building charts with SQL in minutes using Db2 Web Query 3. Expand your use of the power of SQL.
John Westcott is a member of the Db2 for i Database and Analytics team in IBM’s Technology Services (formerly Lab Services). A consultant with over 35 years’ experience on IBM i, his skills include Business Intelligence, Business Analytics, Database Modernization, SQL and RPG... Read More →
Alan and Charlie will open the floor for an open discussion about the value of custom code, and how it gives businesses their proprietary advantages.
What are the responsibilities and roles for everyone in your organization to promote better business continuity, workflows, and overall user experiences?
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 →
IoT is a big deal in IT today. Since RPG can call and host REST APIs, you can integrate it with IoT devices. For my first project, I decided to see if I could use RPG's "open" and "close" opcodes to open and close my garage door -- and it worked!
In this session I will show you how I integrated my RPG program with the Raspberry Pi, and talk about how the Raspberry Pi and similar devices can play a big part in the future of business applications.
Learning Objectives: 1. Learn the basic concept of Raspberry Pi (and other single-board computers) 2. Learn why physical computing and IoT are important. 3. Learn about integrating IoT with RPG programs.
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 →
Best practices recommend using more than one factor to secure logins and other critical processes. Using industry standard algorithms, two factor authentication now comes to IBM i. This quick session covers four of the latest tools to help secure your IBM i!
Learning Objectives: 1. Understand how to use more than just a password for authentication 2. Learn what integration options exist for IBM i MFA
Robert Andrews is a Principal Security Consultant, Senior Technical Staff Member (STSM), and the Team Lead for the IBM i Security and Authentication Technology Expert Labs team in Rochester, MN. He is an IBM certified Thought Leader and The Open Group certified Distinguished Technical... Read More →
Did you know that the entire IBM Power server family has now been refreshed with Power10 processor technology? Starting in September, 2021, IBM introduced the Power10 E1080 enterprise system and in July, 2022, IBM introduced the rest of the product family which includes the S1014, S1022/S1022s and S1024. New IBM i software subscription and hardware/software/support subscription options are available. IBM i customers need to know the capabilities and positioning of the entire Power server family, so attend this session to hear about the latest and greatest.
Dan Sundt is an IBM i product manager. He has the responsibility for the IBM i business, including defining and guiding future directions and strategies. He works with the IBM i sales, marketing, and development teams as well as customers and partners to ensure that the IBM i operating... Read More →
Wednesday April 26, 2023 4:00pm - 5:00pm MDT
Plaza Court 6
Chances are that your organization may have the need for RPG applications to share and exchange data with databases other than DB2. Maybe your order management or ecommerce system is on a web server running SQL Server, PostgreSQL or MySQL/MariaDB. Or maybe you need to create SQLite files to expose data to a mobile application.
In today’s world you may be replicating data files and uploading and downloading data on a scheduled basis. Wouldn’t it be a better idea to use the data real-time where it lives instead of making multiple copies? Using live data also greatly improves performance when communicating between multiple systems.
This session will provide an introduction to how you can utilize RPG and open-source technology to interact in real-time with other databases. No more syncing or importing/exporting data on a scheduled basis. Use live data where it lives without replication.
Attend this session to learn how to cross the divide and immediately extend you RPG applications into the open database database world. No matter what external database platform you want to talk to, you’ll benefit from this session.
Learning Objectives: 1. Learn the benefits of Integrating external databases with RPG 2. Learn the development pattern for integrating external databases with RPG 3. Adopt and utilize the provided RPG examples right away in your own shop
Richard has over 30 years of software development, system integration, document management and process automation experience on all system platforms including IBM i, Windows, Linux and Mac. Richard started RJS Software Systems in 1990 and served as President and CTO until the company... Read More →
Audience Any RPG, CL or Open-Source developer looking to expand their usage of RPG and CL to quickly integrate the ability to take advantage of external databases to use live data where it lives.
Today, there are no known ransomware viruses that run directly on IBM i. However, that does not mean that the IBM i is not at risk. In this practical session, you will learn how to keep your IBM i system safe from Ransomware attacks. Don't miss this critical session!
Learning Objectives: 1. Understanding ransomware and how it can effect the IBM i 2. Know how to secure the IBM i from ransomware attacks 3. Link to resources for further details
Robert Andrews is a Principal Security Consultant, Senior Technical Staff Member (STSM), and the Team Lead for the IBM i Security and Authentication Technology Expert Labs team in Rochester, MN. He is an IBM certified Thought Leader and The Open Group certified Distinguished Technical... Read More →
Come to this session and dissect all the new components and concepts involved with partitioning your IBM Power Systems. Learn how all the pieces connect to each other, what you need to do to set them up, and how to manage and upgrade them. Get a handle on the various components of the Hardware Management Console (HMC), the Flexible Service Processor (FSP), and the Advanced Systems Management Interface (ASMI). Find out about the firmware in your machine, and how to make the required updates to it in an LPAR environment or on a standalone machine. Get tips for upgrading and setting up communications between the HMC and FSP as well as insight on where the ASMI fits in. Leave this session with up-to-date knowledge on these important hardware features of IBM PowerSystems & IBM i
Learning Objectives: 1) Understand how to upgrade & update your HMC. 2) Understand how to upgrade your FSP. 3) Learn how everything connects and interacts.
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 →
When looking to control what functions of IBM i Access Client Solutions are available to the end users it is not a one size fits all solution. IBM i Access Client Solutions can be secured via 3 different approaches that have their own pros and cons. In this quick 20 minute session we will go over these different options and provide some guidance on what you may want to use.
Learning Objective: Learn how to secure IBM i Access Client Solutions using the available capabilities to control what functions of IBM i ACS the user can run.
Audience: Those who manage IBM i Access Client Solutions client deployments and behavior
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 →
Sustainability has become an overarching concern across all aspects of every industry. This presentation will cover the overall IBM view and dedication to sustainability around the world. We will also cover the dramatic savings that the latest Power10-based systems can deliver in your datacenter in the form of energy, datacenter footprint and even core savings.
As a long-time RDi user, Susan will cover some of her favorite RDi features. Many of these features are often overlooked by new - and even experienced - RDi users.
A few examples include: - How RDi answers the question "Where am I?" - Why Object Table can be your best friend - Under-utilized RPG editor navigation features - Customization tips _And many more.
If you're an RDi user, join Susan to see if you may have missed something useful - and bring your own favorite hidden gems to share. If you're not an RDi user, you may find some good reasons to give it a try.
Learning Objectives: 1. Learn to utilize more features of RDi 2. Become a more productive developer
Susan's 30+ year career began as an application programmer for companies in Atlanta, Georgia, working on a variety of hardware and software platforms. She joined IBM in 1985 and developed a close association with the Rochester lab during the development of the AS/400 system. Susan... Read More →
A lack of skilled resources and security knowledge has left many companies vulnerable to attack. With the average ransomware breach costing $4.62M, companies can no longer afford NOT to prioritize security by implementing better system configuration and corrective measures.
This session presented by Pauline Ayala dives into IFS and Object level security to help you learn how to configure the defenses on your IBM i system and guard your valuable data with the TGSecurity Suite.
In this session, you will learn how to: Uncover potential internal/external threats and vulnerabilities Secure and monitor your sensitive DB2 data files and Objects Secure your IFS from ransomware and cybercrime
VP, Compliance and Security Solutions, Fresche Solutions
Pauline has worked on the IBM i platform for over 20 years. She started her software engineering career developing security products at PentaSafe and has worked for many years on IBM i and enterprise-level solutions in various roles. She was a co-founder of Trinity Guard, which was... Read More →
There are times when it is desirable to have functions run without user intervention via scripting and IBM i Access Client Solutions provides what we call Plugin support that allows calling most functions from a command line or script. This is also how we can run IBM i ACS right on IBM i. In this quick 20 minute session we will cover this Plugin capability and go over a couple of scripting examples, including on the IBM i.
Learning Objective: Learn how to use the IBM i ACS Plugin capability to script functions to run without user interaction.
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 →
Audience Those who manage IBM i access functions and want to script some capabilities to run without user interaction, or run some IBM i ACS functions right on IBM i.
One of the most important things needed to improve SQL performance is to have the proper indexing over tables, especially as table grow in size. Indexes are so important that the database provides index advice for assistance. However, advice is no substitute for knowledge and proper understanding of indexes. As with all advice, it must be reviewed and good judgment applied on when to create them. Learning Objectives: 1. Learn about the importance of indexes on SQL performance 2. Learn how to use ACS tools to process Db2 Index Advice 3. Learn how to use ACS tooling to evaluate which indexes are providing value and which indexes are candidates to delete
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 →
Can a data mart or warehouse or even an operational data store elevate your reporting and visualizations? Improve the performance of your reporting? Provide easily accessible information to the business and your users? Find out how even a small effort can yield big results.
Learning Objectives: 1. Basics concepts of data warehousing. 2 .How easy it is to create a functioning data warehouse. 3. How data warehousing improves the businesses agility in making informed intelligent decisions.
John Westcott is a member of the Db2 for i Database and Analytics team in IBM’s Technology Services (formerly Lab Services). A consultant with over 35 years’ experience on IBM i, his skills include Business Intelligence, Business Analytics, Database Modernization, SQL and RPG... Read More →
When properly tuning your IBM i, you need to know the different profiles for database work, Interactive, batch, and data warehouse. You also need to know about how programs can increase waits on your system. The second part of this session will take you through how to do initial memory sizing on memory pools and what to look for as you tune your memory subsystems.
Learning Objectives: 1. Learn the database usage profiles of the 3 types of database work 2. Learn how to get initial sizing of your memory pools 3. Learn signs that your memory pools are missized and how to rectify the situation.
I'm a 40 year veteran of the IBM i (System/38,AS/400, iSeries, IBM i). My background is in Manufacturing and Performance. I specialize is tuning older systems to extend their life.I am also a JDE CNC (18 years), and my second specialty is JDE/IBM i/Weblogic.
In this session we are going to find out if IBM Power Systems Virtual Server is a secure place for your DR Solution, and what needs to be considered and put in place to create that secure place.
And compared to On-premise solutions what security benefits brings PowerVS. Beside the security topic we are also going to look at the cost of a DR environment on IBM Power Virtual Server. Learning Objectives: -Understand how to set up a secure environment in IBM Power Virtual Server -Compare on premise security to IBM Power Systems Virtual Server security -How to build up a cost case around a DR solution
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 →
Thursday April 27, 2023 8:00am - 9:00am MDT
Plaza Court 5
Have you thought about the passwords you use on your systems? What rules or restrictions do you have in place? But more importantly, why?! Have you ever thought about what those rules actually do to your passwords? Do you think they are making you more secure or less secure? In this presentation, we will cover passwords in depth, in theory, and specific to IBM i. Can your IBM i password be hacked? Come and find out at this inquisitive session!
Learning Objectives: 1. Set modern password policy 2. Understand password protection tools
Robert Andrews is a Principal Security Consultant, Senior Technical Staff Member (STSM), and the Team Lead for the IBM i Security and Authentication Technology Expert Labs team in Rochester, MN. He is an IBM certified Thought Leader and The Open Group certified Distinguished Technical... Read More →
If your company is doing .NET programming alongside IBM i development, it is important to be conversant about accessing Db2 for i from any Microsoft or 3rd party OO language that uses the .NET Framework 2.0 through 4.8. This session will hit all of the main steps required for using this data provider (a component of the ACS Windows Application Package) in a c# web forms ASP.NET style project to run in any standard browser on your PC. We will use Visual Studio Community Edition 2022 as the IDE and to run the Db2 for i SQL. This session seeks to show that it is no big deal to get current Db2 for i data into many Microsoft programming environments with little, if any, advance reformatting or data extract steps.
The detailed example will show how to dynamically churn out a nicely formatted list inquiry on a standard browser web page, using the least amount of specifications. The SQL syntax is limited only by your version of Db2 for i. The provider allows Db2 for i stored procedure calls but that will not be covered in this session, we are trying to get from soup to nuts in the fastest manner possible. One of the ways we achieve this is by using a technique that populates an HTML grid (or table) inquiry directly from the SQL and the file(s) metadata.
Complete code of the c# version (c# code, HTML5, CSS3) and steps on how to implement will be offered to POWERUp 2023 attendees during hour of presentation or via email request. Presentation PDF and some other goodies will be available throughout the conference.
The examples respect native authorities (of the profile you decide to use at run time) and do not require elevated authorities other than admin when installing Visual Studio on your PC. The project can also be published to run on MS IIS Web Server once the provider is installed there (instructions for installing the .NET provider subset of ACS Windows Application Package included). However, obviously you would want to first evaluate use of user authentication, user authorization or data owner subsets before going live on a web server.
Learning Objectives: 1. Be conversant with Microsoft developers at your company regarding this efficient way to access Db2 for i in real time. • Be able to anticipate and, in most cases, easily enable delivery of modern language data types and values from your Db2 for i database without data staging prerequisites or physical file changes • Be able to pass along info on how to source this provider from IBM, when and how to install and it and how to enable it within a Visual Studio project • Get an introduction to how the provider interacts w/ .NET OO FW constructs & routines • Be able to prove out via web inquiry prototype demonstration that Db2 for i can do it (and do it well) in these .NET FW environments 2. For developers who choose to implement this web page example out on their own PC: • Use the included source code and instructions to prototype and demonstrate running dynamic SQL select statements against any authorized Db2 for i database file combination from a browser on your PC (c#, xhtml and css download inc
Sr. Developer (ERP & Web), Tegratecs Development Corp.
Rex is a Sr. Developer at Tegratecs and enjoys developing business applications in traditional IBM i environments and in web environments. Rex enjoys interacting with customers and designing business application software that solves problems and meets user needs. He is currently... Read More →
Thursday April 27, 2023 9:15am - 10:15am MDT
Plaza Court 4
Audience IBM i developers who work in companies with .NET or ASP.NET programming that consumes or updates Db2 for i. IBM i developers who want to get a taste of web programming with an integrated GUI on their own time. Developers who would like to get a glimpse of OO programming syntax with an OO framework foundation.
What exactly is all of this hype around Merlin, VS Code and Next Gen Apps? Are you confused about what exactly "Next Gen Apps" really means, how your existing development fits into this new paradigm, and if you should consider embracing one of these new tools? Compare and contrast your development environment(s): SEU, RDi, VS Code and Merlin (and others??) and see what your different options are - then consider each package's inherent strengths and weaknesses as you start to move down the Next Gen path.
Learning Objectives: 1. Learn what NextGen Apps actually are 2. Learn about Merlin 3. Learn about VS Code and all of its "different flavors" 4. Compare and contrast Merlin v VS Code 5. Live demo of both tools
Andrew Clark has been working on Enterprise platforms for more than 30 years, starting his career as an intern at IBM working on the secret "Mankato Project” with RS/6000, mainframe, and pre-release versions of OS/400; advancing from testing to a Team Leader on the QQ (Query) team... Read More →
Audience Existing developer and operations personnel who want to implement or learn more about Merlin and DevOps, and C-level decision-makers that need to understand Merlin and VS Code better and whether either makes sense in their environment
What are the new Power10 scale out offerings and how do the differ from each other and previous generations. Meet the Daniel, the Product Manager for the Scaleout Portfolio.
I embarked on a dynamic career journey leading me to IBM, where I've dedicated over two decades to diverse roles. Beginning as an intern in 2004, I've navigated through Sales Operations, IT Strategy Consulting, and leadership in Systems Technical Sales, making significant contributions... Read More →
Thursday April 27, 2023 9:15am - 10:15am MDT
Plaza Court 5
PowerHA provides complete high availability (HA) solutions for IBM i customers with both internal storage and external storage environments. This interactive demo session will explain the concepts required to manage PowerHA environments, as well as give live demonstrations of the key management tasks used in a PowerHA environment.
Learning Objectives: 1. Learn the basic concepts required to configure a PowerHA environment. 2. Understand how to manage a PowerHA environment and see it in action 3. See tools within PowerHA that help your environment stay secure
In addition to his role as Associate 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... Read More →
Thursday April 27, 2023 9:15am - 10:15am MDT
Plaza Court 6
IBM i has the capability to participate in a single sign on environment. What is single sign on? Single sign on is an authentication process where a user can access various applications in the network using one set of login credentials. This presentation will describe the Kerberos protocol and how to map a domain user ID to an IBM i user profile to safely authenticate the user to an enabled network application without passwords being sent across the network.
Learning Objectives: Learn about the Kerberos protocol and how to configure IBM i to take advantage of the protocol and enable single sign-on.
Robert Andrews is a Principal Security Consultant, Senior Technical Staff Member (STSM), and the Team Lead for the IBM i Security and Authentication Technology Expert Labs team in Rochester, MN. He is an IBM certified Thought Leader and The Open Group certified Distinguished Technical... Read More →
Many system monitoring tools exist but they aren’t free. Though most Independent Software Vendors (ISVs) will also provide some automation for various situations, no vendor knows your every scenario, nor the software you’ve developed in house. If you must do the work to notify or recover anyway, why not take the time to monitor what you know you need to monitor and save a few thousand dollars while you’re at it. Filter and consolidate information for your operators and staff. Delay low priority situations until normal working hours, automate recovery for common issues, and sleep through the night. This presentation is here to help spark ideas, and provide a few tips to help you work towards internal solutions. Tips will pertain to reactive and proactive system monitoring, audit readiness, and system cleanup.
Learning objectives:
Automate: Message, object, and process monitoring Incident recovery
Consolidate monitoring IBM i to IBM i IBM i to other
Learn how to get free coding tools, and the free education to use them.
Starting my 40th year in Automation at 54, my 30th on the IBM i (formerly known by other names). Started my IBM career in '99, and migrated to Kyndryl. Prior to that, I spent most of my time working in the broadcast industry. First with Radio, then Television, then providing... Read More →
Thursday April 27, 2023 9:15am - 10:15am MDT
Plaza Court 7
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
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
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 →
In the tradition of previous Technology Refreshes (TR), the database team is delivering enhancements on the same cadence. Attend this session to hear about the many enhancements to SQL on i, SQL Query Engine, IBM i Services and more. This session will cover the new and enhanced Db2 for i capabilities added to IBM i 7.4 and IBM i 7.5 over the most recent IBM i Technology Refreshes.
This session will include something for everyone and anyone who uses the IBM i. Resources: https://www.ibm.com/support/pages/node/1119129 and http://ibm.biz/Db2foriSQLTutor
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 →
By using Db2 for i’s three-part name it is possible to perform SQL statements on one partitions, initiated from another. This can be as simple as building tables, views, etc. on the remote partition and populating them with data. Or it can be as complex as you like. Become the “go to” guy who is able to gather data from multiple partitions and combine them into one set of results for reports, creating test databases, comparing the set up of two partitions, etc.
Learning Objectives: 1. Learn the syntax of the three-part name 2. Learn what you can, and cannot, do when using the three-part name and overcome the simple road blocks 3. See how to build a RPG program to show the jobs in message wait from multiple partitions all on one screen
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 →
The IBM i OS network communications has changed a lot since the AS/400 primarily communicated to workstations and printers using Twinax and to other computer systems using specialized communications lines. In some ways things are more complex because our IBM i OS systems communicate to a lot of other devices in many different ways, but in other ways things are simpler today because nearly all network communications are built on top of the foundation of Ethernet and TCP/IP. Your IBM i OS Networking health is very important and is it how most of your data and applications are accessed. This session will take a look at approaches to monitoring this IBM i OS Networking health and it's interaction with the network, how to collection diagnostic data and how to troubleshoot problems.
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 →
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.
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 →
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 →
The Power10 platform has a variety of new security features built into it. What are these features and how do they help protect your platform and your data.
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 →
Today data get more and more exchanged between multiple platforms and interfaces, in JSON or XML or other text formats. SQL includes methods for consuming XML and JSON. But quite often the data is not in the format, so we can consume it directly. For example, the first and last name is returned as a single value separated with a comma and must be split. On the other hand, data must sometimes be prepared in a specific way, for example a numeric value must be right adjusted padded with asterics and edited with group and decimal separators. And finally, it is necessary to check the passed data or to search character data if they match a specific format or include a specific sequence. For example, to find all column values that consist not only of digits. Did you know, you can do this directly with SQL? SQL includes a lot of scalar functions for string manipulation including regular expressions for scanning, preparing and converting
Learning Objectives: Learn what scalar functions for string manipulation are available and how they can be used for concatenating, converting, splitting strings. For more complex searches learn which regular expression functions are available and how they can be used.
Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →
We all work in environments where data is changing, often rapidly. At times it would be nice to know what the data looked like an hour, a day, or even a week ago. With conventional files and tables this is hard, that might even involve restoring data from journals. SQL Temporal Tables alleviates all of that work. They allow you to view the data as it was at any time, and allows many people to view the data at different times all at the same time.
Learning Objectives: 1. Learn the syntax of how to create a Temporal Table 2. Learn how to view data from the Temporal Table for various times 3. Learn how to recover delete rows using the Temporal Table
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 →
Db2 for i offers a wide range of security features built into the database that allow you to better secure your data. You can easily and quickly take advantage of these tools to not only understand how your data is secured, but to better secure your data.
Learning Objectives: During this session, we will review a security compliance solution that enables the deployment of security policies across multiple systems. In addition, the tool relies on audit journals and IBM i services to assess the compliance of your security policies. Row permissions can also be utilized to limit access to security compliance data
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 →
John Westcott is a member of the Db2 for i Database and Analytics team in IBM’s Technology Services (formerly Lab Services). A consultant with over 35 years’ experience on IBM i, his skills include Business Intelligence, Business Analytics, Database Modernization, SQL and RPG... Read More →
Thursday April 27, 2023 1:30pm - 2:30pm MDT
Plaza Court 2
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.
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 →
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 →
Our businesses often want reports delivered in Excel format. While there are several ways to create these spreadsheets using RPG, they all have some drawbacks. Writing to the current XLSX format for Excel spreadsheets may seem a formidable challenge, but we will see that the prospect of success is better than it might seem at first. And we will see how to use tools such as CGIDEV2 to accomplish the task of creating these modern, highly-functional spreadsheets.
Learning Objectives: 1. Understand the internal structure of modern Excel (XLSX) files 2. Identify various reporting scenarios, such as multiple sheets, static informational sheets, etc. 3. Understand how to design and implement an Excel (XLSX) application
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 at Ecolab. He also serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs... Read More →
Thursday April 27, 2023 1:30pm - 2:30pm MDT
Plaza Court 5
Audience Developers who want to extend existing skills into writing modern business documents. Perhaps managers and administrators who want to know what is possible by leveraging existing knowledge.
As more and more development teams embrace Open Source technologies on the IBM i OS it will be important that Systems Administrators know the basics of managing these packages on the IBM i OS. This session will predominantly look at the Open Source Package Management capabilities included with IBM i Access Client Solutions as the go to environment for those who are not themselves using the Open Source packages.
Learning Objectives: As a Systems Administrator become familiar with Open Source Package Management on the IBM i OS.
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 →
Yum is how open source software gets installed these days. Alan's presentation will make you a Yum and RPM master, ensuring your packges stay updated, sharing tricks to handle slow connections, how to find out what versions you have, troubleshooting PATH issues, coexisting with older open source packages, going back to an older version of a package, viewing a package's change log, and a lot more. Never be stumped by a Yum issue again!
Learning Objectives: 1. Tricks to upgrade, downgrade, learn what's in a package, and a lot more. 2. How to handle slow connections, an IBM i not connected to the internet, and much more, to prepare for any situation.
Learn about the most recent enhancements for IBM Navigator for i. The new IBM Navigator for i now covers most of the functions from heritage Navigator, plus it has many exciting new offerings! This session will have a few slides but will be mostly live demo. We guarantee you will say, “I didn’t know you could do that” at least once during this session.
Lora Powell is team lead for IBM Navigator for i. Her career with IBM since 1989 has been in Rochester, MN where for the past 10 years she had focused on Performance Data Investigator (PDI). Now the last few years she has expanded her influence to all aspects of Navigator.
Thursday April 27, 2023 1:30pm - 2:30pm MDT
Plaza Court 6
The IBM i operating system has several different tools to collect data for performance analysis. In this session, you will learn when and how to use the following tools: Collection Services, Job Watcher, Disk Watcher, and Performance Explorer. Learning Objectives: 1. Learn which tool is the right tool to use in different scenarios. 2. Learn how to run each tool and use visualization tools to analyze the performance data collected.
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 →
Another part of the company is wanting to leverage a cloud based server for some requirement - advanced analytics, pricing applications, AI/ML project, micro-services, etc. They are coming to IBM i I/T folks to ask how they can get critical data that they need from Db2 for i. This session will answer that question for you, including a couple of approaches using open source Apache Kafka.
Learning Objectives: 1. Learn about Apache Kafka as the glue to stream data 2. Understand different approaches and the advantages/disadvantages of those approaches. 3. Enhance your knowledge of the data streaming into cloud services world
John Westcott is a member of the Db2 for i Database and Analytics team in IBM’s Technology Services (formerly Lab Services). A consultant with over 35 years’ experience on IBM i, his skills include Business Intelligence, Business Analytics, Database Modernization, SQL and RPG... Read More →
Back in 2019 IBM introduced Power Enterprise Pools 2.0 on the Power9 model E980, offering customers the flexibility to tailor system configurations with a mix of purchased and pay-for-use consumption of processors and software. This was expanded in 2020 to scale-out systems which are frequently used by IBM i customers. In 2021 and 2022, systems based on the latest Power10 processor were introduced and new consumption capabilities added. If you are interested in dynamic, flexible consumption or cloud-like economics with on-prem servers, attend this session.
Dan Sundt is an IBM i product manager. He has the responsibility for the IBM i business, including defining and guiding future directions and strategies. He works with the IBM i sales, marketing, and development teams as well as customers and partners to ensure that the IBM i operating... Read More →
Thursday April 27, 2023 2:45pm - 3:45pm MDT
Plaza Court 5
Everyone who uses free-format RPG knows the basics of using prototypes to replace their old parm lists for program calls. However many RPGers don't realize just how much prototypes can do for them. In this session, Susan reviews prototype basics but will concentrate mostly on exploiting their often-overlooked features. She'll even look at how much some of the hot-off-the-presses enhancements from IBM can simplify things. Did you know that prototypes: • Protect against parameter mis-matches • Provide automatic conversion of parameter types and sizes • Enable passing literals, built-in functions or function calls as parameters • Allow you to specify optional parameters • Enable you to call C functions and system APIs that return values We'll also look at how to exploit these features of prototypes effectively, including examples of the right way for called programs (or procedures) to safely handle optional parameters.
Susan's 30+ year career began as an application programmer for companies in Atlanta, Georgia, working on a variety of hardware and software platforms. She joined IBM in 1985 and developed a close association with the Rochester lab during the development of the AS/400 system. Susan... Read More →
The pressures and expectations for the security officer have never been higher. Come to this session to learn how to use SQL to accomplish critical security tasks, including the ability to easily automate security policies. You do not have to be an SQL expert to gain something from this session. I will give you examples that you can take back and use.
In the session, I will explain how the examples work and you'll leave with the skills necessary to be a better and more productive IBM i security officer.
Learning Objectives: 1. Learn how SQL can be used to administer security on IBM i. 2. Discover how to use fully functional SQL examples to improve security on IBM i. 3. Understand how SQL can be used as a tool to train your next IBM i Security officer.
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 →
In 3 decades of performance tuning, I have found quite a few things that almost every IBM i system I have been on can benift from. This session will contain the most common and impactful changes I have used in my career as a performance tuner on the i. Learning Objectives: 1. Learn the most common performance tuning changes that can help increase throughput of your system. 2. Learn how to implement multiple SQL environments for batch, interactive, and JDBC/ODBC workloads.
I'm a 40 year veteran of the IBM i (System/38,AS/400, iSeries, IBM i). My background is in Manufacturing and Performance. I specialize is tuning older systems to extend their life.I am also a JDE CNC (18 years), and my second specialty is JDE/IBM i/Weblogic.
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.
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 →
