Prevent Db2 tools for z/OS Health Check routines from executing
Article ID: 50174
Updated On:
Products
Issue/Introduction
How to prevent Database Management for Db2 for z/OS health check routines from executing.
Cause
- The Db2 tools for z/OS health check routines are registered to IBM Health Checker for z/OS during Execution Manager for Db2 for z/OS (PXM) startup.
The intended implementation of IBM Health Checker for z/OS is that by default, health check routines should execute as part of the product "out of the Box" installation. - Db2 tools for z/OS health checks conform to this standard. Db2 tools for z/OS health check routines, depending on execution Interval time, may run once or periodically for the duration of the Xmanager started task.
Resolution
- Stopping a Db2 tools health check from executing can be accomplished by using IBM Health Checker for z/OS operator modify commands to temporarily delete the health check(s) or long term through the use of the IBM Health Checker for z/OS parmlib member HZSPRMxx.
- Db2 tools health check routines deleted using the IBM Health Checker for z/OS operator modify commands will remain deleted only for the duration of the Xmanager task that owns the health checks.
- When using a DELETE CHECK in the IBM Health Checker for z/OS parmlib member HZSPRMxx, health check routines will be deleted with each execution of Xmanager. Be sure to recycle the IBM Health Checker for z/OS address space to affect these changes.
- If the IBM Health Checker for z/OS address space is stopped, abnormally terminates or is recycled, Health Checker retains the deleted state of health check routines for the duration of the Xmanager task that added the health checks.
- For additional information on using IBM Health Checker for z/OS operator modify commands or parmllib member HZSPRMxx see the IBM Health Checker for z/OS User's Guide.
DELETE a health check using an operator modify command:
F hcheck,DELETE,CHECK=(HEALTH CHECK OWNER, HEALTH CHECK NAME)
Below are some examples of deleting Db2 tools for z/OS health checks:
- Delete a specific Db2 tools for z/OS health check:
F hcheck,DELETE,CHECK=(CA_DB2,DB2_PLC_PLC_DCOMP_ACT@PTXRUN14) - Delete all Db2 tools for z/OS health checks:
F hcheck,DELETE,CHECK=(CA_DB2,*) - Delete all Db2 tools for z/OS health checks with a health check name beginning with DB2_:
F hcheck,DELETE,CHECK=(CA_DB2,DB2_*)
DELETE a health check using SYS1.PARMLIB member HZSPRMxx:
Following is the format of an ADDREPLACE POLICY statement used to delete health checks.
ADDREPLACE POLICYDELETE CHECK(HEALTH CHECK OWNER, HEALTH CHECK NAME) DATE(YYYYMMDD) REASON('Do not run DB2 tools health checks.')
The following ADDREPLACE POLICY statement will cause all Db2 tools for z/OS health checks to be deleted:
ADDREPLACE POLICY DELETE CHECK(CA_DB2,*) DATE(20110718) REASON('Do not run DB2 tools health checks.')
The following ADDREPLACE POLICY statement will cause a specific Db2 tools for z/OS health heath check to be deleted:
ADDREPLACE POLICY DELETE CHECK(CA_DB2,DB2_PLC_PLC_DCOMP_ACT@PTXRUN14) DATE(20110718) REASON('Do not run DB2 tools health checks.')
The following ADDREPLACE POLICY statement will cause all Db2 tools for z/OS heath checks to be deleted with a health check name beginning with DB2_:
ADDREPLACE POLICY DELETE CHECK(CA_DB2,DB2_*) DATE(20110718) REASON('Do not run DB2 tools health checks.')
Health check(s) may remain active with ADDREPLACE POLICY DELETE statements in HZSPRMxx.
When Db2 tools for z/OS health checks remain active, it is recommended that the date specified on the ADDREPLACE POLICY DELETE be set to the current date. The date specified on the ADDREPLACE POLICY DELETE can become out of date due to subsequent maintenance to the Db2 tools for z/OS health check routines.
System symbolics may also be used for the POLICY DATE so it will not expire.
The following is an example of using system symbolics within the DATE syntax:
ADDREPLACE POLICY DELETE CHECK(CA_DB2,*) DATE(&YR4&LMON&LDAY) REASON('DO NOT RUN DB2 TOOLS HEALTH CHECKS')
Feedback
