Database Utilities › Database Maintenance (SARDBASE) › Job Control Statements

Job Control Statements

Sample execution JCL can be found in member HAEXDBSE in your CVDEJCL data set.

These job control statements are required to execute SARDBASE:

JOB

Initiates the job.

EXEC

Specifies the program name (PGM=SARDBASE) and, optionally, the high-level name of the database as the PARM parameter (PARM='VIEW.SYSTEM1').

STEPLIB DD

Defines the load library containing SARDBASE.

If the program resides in a linklist library, omit this statement.

SYSPRINT DD

Defines the sequential output data set (normally SYSOUT) used for listing the control statements and messages.

If not a SYSOUT data set, DCB=BLKSIZE=nnn must be coded where nnn is a multiple of 133.

SARIOUT DD

Defines a sequential output data set into which the master index is unloaded.

The attributes of the data set are to be set to RECFM=VB, LRECL=6129, and BLKSIZE=0. The output data set blocksize is to be determined by the output media or can be specified on the JCL DD statement. For tape it will default to 32760 and for 3390 DASD it will default to 27998.

The DD statement is only required for an IDXOUT operation.

SAROLIB DD

Defines the online library containing the panel, message, and skeleton JCL members to be loaded to the database.

The DD statement is only required for an OLOAD operation.

SARBLIB DD

Defines the banner page library containing the model banner page members to be loaded to the database.

The DD statement is only required for a BLOAD operation.

SARRECV DD

Defines the recovery file.

This statement is only used for a RESTORE operation. While this DD statement is optional, it can be included for a more efficient RESTORE operation.

SARTAPE DD

Defines the archival or DR tape containing the backup of the master index.

This statement is only used for a RESTORE operation. For a RESTORE operation, the DD statement is optional and is only used when there is no recovery data set or the SARRECV DD statement is missing. When used, the file sequence number of the LABEL parameter must specify the position number of the master index backup on the tape. The position of the backup can be obtained by mapping the tape with the SARTCP program.

Note: Due to IBM JCL limitations, the LABEL parameter cannot exceed 9999. When the file number of the master index exceeds this value, use the SARRCOV utility to create a recovery file that contains the dataset name of the backup or DR tape and the file number of the master index. Then leave out the SARTAPE DD statement and specify the name of the recovery file on the SARRECV DD statement. For more information about SARRCOV, see the chapter "Database Utilities." Sample JCL for this function can be found in CVDEJCL member HAEXRCOV.

SARLOAD DD

Defines the device containing the unloaded database.

This statement is only used for a LOAD operation.

SARUNLD DD

Defines the device to which the database is unloaded.

This statement is only used for an UNLOAD operation.

SARMERGn DD

Defines the unloaded databases that are to be merged together.

Replace n with a number from 1–9 so that each unloaded database is defined with a unique DD statement. These statements are only used for a MERGE operation.

SYSOUT DD

Defines a sequential output data set (normally SYOUT) to which SORT messages are written.

The SYSOUT DD statement is needed for the CONVERT, COPY, LOAD, MERGE, REORG (standard), RESTORE, and VERSION operations.

SORTWKnn DD

Defines temporary sort work disk space where nn represents a numeric number.

Normally, a minimum of three sort work DD statements are specified.

The SORTWKnn statements are needed for the CONVERT, COPY, LOAD, MERGE, REORG (standard), RESTORE, and VERSION operations.

SYSIN DD

Defines a card image data set containing the control statements to be input.