What is the correct format for the utility RESTART parameter on the JCL EXEC card for the Database Management for Db2 for z/OS - Utilities suite?
Depending on the utility in use these type of messages may be seen as one possible cause requiring a restart:
PRR0507E - Data object in RESTART mode - RESTART parameter required
UTILID database.tablespace Checksum nnnnn
PFI0410E - Data object in RESTART mode - RESTART parameter required
UTILID database.tablespace Checksum nnnnn
PFR0610E - Data object in RESTART mode - RESTART parameter required
UTILID database.tablespace Checksum nnnnn
This is not a complete list. Each Utility may produce a similar message.
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 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.