About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Troubleshooting
Problem
This document lists options to limit the amount of resources that are used by all or some of the QZDASOINIT prestart jobs to make more resources available for other jobs. It also provides more helpful references.
Resolving The Problem
This document lists options to limit the amount of resources that are used by all or some of the QZDASOINIT prestart jobs to make more resources available for other jobs. It also provides more helpful references.
The following are options to limit the amount of resources that are used by all or some of the QZDASOINIT prestart jobs to make more resources available for other jobs:
Query Supervisor
Starting at IBM i 7.3:
"The Db2 for i SQL Query Engine (SQE) provides a Query Supervisor, which enables real-time monitoring of resource consumption by SQL and native queries, for example the Open Query File (OPNQRYF) command. Query Supervisor threshold levels can be established for general or specific scenarios. When a threshold is met or exceeded, the query execution is interrupted, and user-supplied exit programs are called."
|
Workload capping |
Work Management Resources |
Pool |
Temporary Storage |
CPU Time |
Query timeout |
IBM Navigator for i Monitors "IBM® Navigator for i monitors track current information about the performance of your system. Additionally, you can use them to carry out predefined actions when a specific event occurs. Monitors continue to monitor and perform any threshold commands or actions you specified until you stop the monitor." |
SMP (Symmetric Multiprocessing) |
QAQQINI library The IBM i client data providers all have properties that allow setting the library containing a customized QAQQINI file. See the QAQQINI documentation for all the query options that file allows. IBM Toolbox for Java (jt400.jar) uses "qaqqinilib". IBM i Access ODBC data sources provide a setting for the "Query options file library" on the "Diagnostic" tab of an ODBC DSN. The same value can be set as a connection property in an ADO/OLE DB connection. The Db2 for i .Net provider (IBM.Data.DB2.iSeries) uses property "QueryOptionsFileLibrary" For all data providers, the user profile used for the DB2 connection must have authority to the CHGQRYA command and the QAQQINI file residing in the specified Query Options File Library. |
Related Information
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"Host Servers","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Historical Number
351081544
Was this topic helpful?
Document Information
More support for:
IBM i
Software version:
Version Independent
Operating system(s):
IBM i
Document number:
643975
Modified date:
24 October 2022
UID
nas8N1019190
Manage My Notification Subscriptions