COMMON POWERUp 2026

As applications are modernized, it is common to move from green screen interfaces to browser-based applications. In many cases, the associated HTTP server runs on the IBM i in the QHTTPSVR subsystem. These web applications access the database, perhaps directly, but also by using SQL CLI, which results in the database access running in an QSQSRVR jobs in the QSYSWRK subsystem. As environments become more complex, one may see several web instances using a large number of QSQSRVR jobs. This default configuration can make it difficult to understand system resources used by the application, as well as related challenges in troubleshooting problems. This session is a case study of using subsystems to isolate web applications to their own subsystem; the HTTP server instance and related QSQSRVR jobs running in the same subsystem.

Learning Objectives:

In this session you will learn how to: - Configure HTTP instances to run in their own subsystem - Set up the system so QSQSRVR jobs run in the subsystem of the requester - How to use the Performance Data Investigator to review performance by subsystem after the configuration changes are made