HCHECK usage examples

You can set up the Health Check function (HCHECK) in several different ways.

You can set up HCHECK to run on a scheduled basis to periodically check for problems that can affect database recovery. You can also use HCHECK at the Disaster Recovery (DR) site to verify that your DR site is recoverable. You must specify the options to be checked individually, each with its own HCHECK keyword. You can although, specify multiple HCHECK keywords within the same job step.

Example 1: Identify problems related to image copies

To identify problems that are related to image copies, specify the following control cards:

To report on any databases that do not have a batch or online image copy within the last 14 days, issue the first line in the next example.

To report on any databases for which one of the following conditions are true, issue the second line that is shown in the next example:

No image copy has been taken
An image copy is needed
An image copy is recommended

   HCHECK(ICFREQ DAYS(14))
   HCHECK(ICALL)

Example 2: Identify problems with partitions or unavailable areas

To identify problems that are related to disabled partitions, partitions that are not initialized, or unavailable areas, specify these control cards:

   HCHECK(HALDBDISABLEDPART)
   HCHECK(HALDBNOTINIT)
   HCHECK(NOADS)

Example 3: Identify databases with potential backout or authorization problems

To identify databases with potential backout or authorization problems, use this input:

   HCHECK(BACKOUT)
   HCHECK(PROAUTH)