Identifying packages with characteristics that affect performance, concurrency, or the ability to run
You can run a query to identify packages with characteristics that might cause problems when you run their applications.
About this task
Packages that meet any of the following criteria can cause their applications to run more slowly, prevent other processes from running concurrently, or prevent the applications from running.
- VALIDATE(RUN) bind option packages
- Validity checks might be repeated at run time. If an invalid object or missing authority is found, Db2 issues a warning and checks again for the object or authorization at run time.
- ISOLATION(RR) bind option packages
- Packages use repeatable read isolation. The data that an application references cannot be updated by any other applications before the application reaches a commit point.
- Invalid packages
- Invalid packages must be rebound before their applications can run. Actions such as deleting an index or revoking authority can render a package invalid. For more information, see Changes that invalidate packages.
- Inoperative packages
- Inoperative (OPERATIVE='N') packages must be explicitly bound or rebound before they can run. Among the actions that cause a package to be marked inoperative is an unsuccessful REBIND operation.
Procedure
To check for packages with any of the above characteristics, issue the following SQL statement:
SELECT COLLID, NAME, VERSION, VALIDATE, ISOLATION, VALID, OPERATIVE
FROM SYSIBM.SYSPACKAGE
WHERE VALIDATE = 'R' OR ISOLATION = 'R'
OR VALID = 'N' OR OPERATIVE = 'N';
What to do next
Correct the indicated condition, and bind or rebind the package before running its application.