How can CA-DB2 Tools health check routines be prevented from executing?

book

Article ID: 50174

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

How can CA-DB2 Tools health check routines be prevented from executing?

Cause

The CA-DB2 Tools health check routines are registered to IBM Health Checker for z/OS during CA 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. CA-DB2 Health Checks conform to this standard. CA-DB2 Tools health check routines, depending on execution Interval time, may run once or periodically for the duration of the Xmanager started task.

Solution:

DELETE the CA-DB2 Tools health check routine(s).

Stopping a CA-DB2 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.

CA-DB2 Tools health check routines deleted using 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, CA 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

Following are some examples of deleting CA-DB2 Health checks.

Delete a specific CA-DB2 health check:

F hcheck,DELETE,CHECK=(CA_DB2,[email protected])

Delete all CA-DB2 health checks:

F hcheck,DELETE,CHECK=(CA_DB2,*)

Delete all CA-DB2 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 POLICY
DELETE 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 CA-DB2 heath 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 CA-DB2 heath check to be deleted:

ADDREPLACE POLICY
DELETE CHECK(CA_DB2,[email protected])
DATE(20110718)
REASON('Do not run DB2 tools health checks.')

The following ADDREPLACE POLICY statement will cause all CA-DB2 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 CA-DB2 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 CA-DB2 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')

Environment

Release:
Component: PXM