Running a Health Check
The Health Check is a function provided by the IMS Recovery Solution Pack Database Recovery Facility: Extended Functions (DRF/XF). It is used to identify databases that indicate problems in the RECON data sets that might make them unrecoverable.
Health Check can be run from three different locations within the IMS Recovery Expert ISPF interface:
- From the System Level Backup Display, by selecting a system level backup with the H line command.
- During the Disaster Recovery preparation job, when the Disaster Recovery profile indicates that Health Check should be run.
- From the Application Profile, by selecting a profile with the H line command.
For Health Check to run, the DRF/XF library must be specified in the BSYV220 CLIST using the IMSTOOL1, IMSTOOL2, or IMSTOOL3 variable. If this is not done, Health Check will not be available.
When executing Health Check from the System Level Backup or Application Profile display, the JCL build panel will include the Edit Health Check Options option. Specifying Y on this line will display the current Health Check options, which you can change. From the Disaster Recovery Profile, specify U for the Run Health Check option to get to this panel.
When the panels are displayed, you can individually select the options that you want to execute, as well as any time or range parameters that are required for those options. These setting are saved in your ISPF profile so that they are remembered. If you do not change these options, a default set of options is used.
Some of the Health Check options require a parameter to specify the timeframe for which to perform the health check. This parameter can be specified in one of three formats:
- DAYS – The number of days from the current time backward to check. The DAYS value can be any number from 1-999.
- HOURS – The number of hours from the current time backward to check. The HOURS value can be any number from 1-999.
- RANGE – A range of time during which to perform the check. The RANGE consists of four
different parts:
- timestamp – Any valid timestamp in the format accepted by DBRC.
- direction – Whether to check back or forward in time from the specified timestamp.
- amount – How far back or forward to check.
- scale – The scale associated with the amount. This might be ‘SECS’ for seconds, ‘MINS’ for minutes, ‘HRS’ for hours, or ‘DAYS’ for days.
For options that require a timeframe, select the type you want to use, and then specify the required values. Only one timeframe type can be selected for a given option.
The Health Check Report Options panels are shown in the following examples, followed by a description of the options.
BSY$HCOP V2R2 -------- Health Check Report Options -------- 2021/06/24 15:20:3
Option ===>
-------------------------------------------------------------------------------
Enter options for the Health Check Report utility. Options will be
saved to your ISPF profile and used to generate all Health Check jobs.
More: +
Y DBs for which no ICs exist (Y/N) ICNONE/ICFREQ
Days (1-999)
Hours (1-999)
Range( , , , ) (tmstmp,dir,amt,scale)
Y DBs for which no batch ICs exist (Y/N) MINBAT
Days 007 (1-999)
Hours (1-999)
S Range( 15123123456789000 , - , 059 , SECS ) (tmstmp,dir,amt,scale)
Y DBs for which no online ICs exist (Y/N) MINONL
Days 007 (1-999)
Hours (1-999)
S Range( 15336123456789000 , + , 023 , DAYS ) (tmstmp,dir,amt,scale)
N DBs for which ICs are needed (Y/N) ICNEED
BSY$HCOP V2R2 -------- Health Check Report Options -------- 2021/06/24 15:20:3
Option ===>
------------------------------------------------------------------------------
Enter options for the Health Check Report utility. Options will be
saved to your ISPF profile and used to generate all Health Check jobs.
More: - +
N DBs for which ICs are needed (Y/N) ICNEED
N DBs for which ICs are recommended (Y/N) ICREC
N DBs not in a CA group (Y/N) DBNOTCA
Y CA groups with no valid CAs (Y/N) CARUN
Days 007 (1-999)
Hours (1-999)
S Range( 15336123456789000 , + , 111 , DAYS ) (tmstmp,dir,amt,scale)
N HALDBs with disabled partitions (Y/N) HALDBD
N HALDBs with non-init partitions (Y/N) HALDBN
N DEDBs that have EEQEs (Y/N) EEQE
BSY$HCOP V2R2 -------- Health Check Report Options -------- 2021/06/24 15:20:3
Option ===>
-------------------------------------------------------------------------------
Enter options for the Health Check Report utility. Options will be
saved to your ISPF profile and used to generate all Health Check jobs.
More: - +
N DEDBs that have EEQEs (Y/N) EEQE
N DEDBs with no area data sets defined (Y/N) NOADS
N DEDBs with no area data sets avail (Y/N) NOADSAVAIL
N DBs that have backout needed (Y/N) BACKOUT
N DBs with PROHIBIT AUTH on (Y/N) PROAUTH
Y IC1 with no IC2 (Y/N) PISEC
Days 007 (1-999)
Hours (1-999)
S Range( 15001001001001001 , - , 023 , SECS ) (tmstmp,dir,amt,scale)
N Minimum CAs not available for a DB (Y/N) MINCARECS
BSY$HCOP V2R2 -------- Health Check Report Options -------- 2021/06/24 15:20:3
Option ===>
-------------------------------------------------------------------------------
Enter options for the Health Check Report utility. Options will be
saved to your ISPF profile and used to generate all Health Check jobs.
More: -
N DBs with PROHIBIT AUTH on (Y/N) PROAUTH
Y IC1 with no IC2 (Y/N) PISEC
Days 007 (1-999)
Hours (1-999)
S Range( 15001001001001001 , - , 023 , SECS ) (tmstmp,dir,amt,scale)
N Minimum CAs not available for a DB (Y/N) MINCARECS
Minimum number of CAs 007 (1-999)
N PRILOG with no SECLOG (Y/N) SECLOG
N PRISLDS with no SECSLDS (Y/N) SECSLD
N Verify recovery assets are catalogued (Y/N) VERIFY The following Health Check options can be executed. For additional information, refer to the IMS Recovery Solution Pack: IMS Database Recovery Facility Extended Functions User's Guide.
- DBs for which no ICs exist
- This option checks for databases that either have no ICs available or no ICs available within the specified timeframe. If you do not select a timeframe, then the entire RECON is checked for the existence of an IC for the database. If a timeframe is selected, then only that timeframe is processed.
- DBs for which no batch ICs exist
- This option checks for databases that have no batch ICs within the specified timeframe. A timeframe specification is required.
- DBs for which no online ICS exist
- This option checks for databases that have no online ICs within the specified timeframe. A timeframe specification is required.
- DBs for which ICs are needed
- This option checks for DBs for which ICs are needed.
- DBs for which ICs are recommended
- This option checks for DBs for which ICs are recommended.
- DBs not in a CA group
- This option checks for DBs that are not in a change accumulation group.
- CA groups with no valid CAs
- This option checks for change accumulation groups with no valid CAs within the specified timeframe. A timeframe specification is required.
- HALDBs with disabled partitions
- This option checks for HALDBs that have disabled partitions.
- HALDBs with non-init partitions
- This option checks for HALDBs that have partitions that are not initialized.
- DEDBs that have EEQEs
- This option checks for DEDBs that have outstanding error queue elements (EEQEs).
- DEDBs with no area data sets defined
- This option checks for DEDBs that do not have any area data sets defined.
- DEDBs with no area data sets avail
- This option checks for DEDBs that do not have any area data sets marked as available.
- DBs that have backout needed
- This option checks for databases that have the BACKOUT NEEDED flag on.
- DBs with PROHIBIT AUTH on
- This option checks for databases that have the PROHIBIT AUTH flag on.
- IC1 with no IC2
- This option checks for databases that have an image copy 1, but no image copy 2 within the specified timeframe. A timeframe specification is required.
- Minimum CAs not available for a DB
- This option checks for change accumulation groups that do not have the minimum number of change accumulation records. The minimum number to use must be specified.
- PRILOGs with no SECLOG
- This option checks for any PRILOG records that do not have a corresponding SECLOG record.
- PRISLDS with no SECSLDS
- This option checks for any PRISLDS records that do not have a corresponding SECSLDS record.
- Verify recovery assets are catalogued
- This option checks to make sure that any recovery assets that might be needed to recover the database are catalogued.