Restart parameter in the Database Management Db2 utilities for z/OS
search cancel

Restart parameter in the Database Management Db2 utilities for z/OS

book

Article ID: 24008

calendar_today

Updated On: 07-16-2024

Products

Fast Load for DB2 for z/OS Fast Unload for DB2 for z/OS Rapid Reorg for DB2 for z/OS Quick Copy for DB2 for z/OS Fast Recover for DB2 for z/OS Database Management for DB2 for z/OS - Utilities Suite Database Management for DB2 for z/OS - Recovery Suite DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS

Issue/Introduction

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?

Cause

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. 

 

 

Resolution

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.

Additional Information