Utilize a new procedure to better manage host server job performance.
Written by Kent Milligan
The good news in the IBM i world is that more and more applications and tools are using modern, industry-standard interfaces such as ODBC, ADO.NET, and JDBC to access DB2 for i databases. The bad news from a systems management perspective is that all of those interfaces by default run in the same subsystem (QUSRWRK) on your IBM i servers. Analysts utilizing an ODBC-based reporting tool are competing for the same resources as those users who are using a JDBC-based OLTP application. Both sets of users have workloads running in QZDASOINIT jobs in the same subsystem.