How to format the CA DB2 utilities for z/OS RESTART parameter on the JCL EXEC card.

Document ID : KB000024008
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

What is the correct format for the utility RESTART parameter on the JCL EXEC card for the DB2 for z/OS tools suite?

 

Answer:

The RESTART parameter is included in the PARM= statement on the EXEC JCL card.  It is an optional statement that specifies how the utility should be restarted.

Example:

//stepname EXEC PGM=PTLDRIVM,PARM=('SUFFIX=xx,EP=UTLGLCTL/ssid,RESTART(parm),plan,utilid')

The SUFFIX defines the suffix to use for the PTISYSxx hlq.CDBAPARM member when multiple members exist.  If defined, it overrides the SUFFIX value of the ENVDEF hlq.CDBAPARM member.  If ENVDEF is not present in hlq.CDBAPARM and you do not define the SUFFIX parameter, the suffix defaults to 00.

The ssid names the DB2 subsystem where the objects reside. This parameter is required.

The format of the RESTART parameter is

RESTART(nnn,restart option)

The nnn is optional and identifies the SYSIN statement number from which to begin execution.

The restart option specifies what type of restart will be done and may be any one of the following: CURRENT, PHASE, TERM, or BYPASS.
Various parameters, depending on the utility being restarted, are validated prior to initiating the restart.

CURRENT - Restarts the utility at the beginning of the next incomplete phase.
PHASE - Restarts the utility at the beginning of the next incomplete phase.
TERM - Deletes the existing RESTART record from the RESTART table and terminates processing for the object.
BYPASS - Deletes the existing RESTART record from the RESTART table and resets the status of the objects to their original state. Note that if any partition independence tasks fail, RESTART(BYPASS) leaves the status of partitions in UT status. The utility is executed from the beginning when RESTART(BYPASS) is specified.

The plan optionally defines the CA DB2 Utilities plan name. If not specified the default plan name from the hlq.CDBAPARM member PLANSxx is used.

The utilid optionally defines the utility ID to be used. If not specified the default of userid.jobname will be used.