StorageTek 312564001 manual JCL requirements, SYSIN parameter specification

JCL requirements

The following JCL may be used to execute the utility:

//*

//STEP100 EXEC PGM=OTDBP100,REGION=4096K //*

//STEPLIB DD DSN=Database.Manager.load.library,DISP=SHR

//DD DSN=Archive.Manager.load.library,DISP=SHR

//*

//SYSIN	DD	DSN=Execution.parameter.file,DISP=SHR
//SQLIN	DD	DSN=Migration.criteria.file,DISP=SHR
//SYSPRINT	DD	SYSOUT=*
//*

DD entries should be specified as follows:

STEPLIB: Enter the names of the DB2 Manager and Archive Manager product load libraries.

SYSPRINT: This entry is used for all print reports created during utility execution.

SYSIN: This is a sequential dataset or in-stream JCL file containing fixed-length 80 byte records, and is used for specification of the parameters used to control utility execution. Refer to “SYSIN parameter specification” on page 82 for a description of how to specify parameter entries in this file.

SQLIN: This is a sequential dataset or in-stream JCL file containing fixed-length 80 bytes records, and is used for specification of the migration selection criteria to be used by the utility for selection of rows for migration from DB2 to DB2 Manager. Refer to “SQLIN entry specification” on page 85 for a description of how to specify a migration selection criteria entry in this file.

SYSIN parameter specification

Parameters used to control execution of the utility are specified in file SYSIN. This must be a sequential dataset or in-stream JCL file containing one or more fixed-length 80-byte records, each record containing one or more separate parameter entries. Each parameter entry must be completely contained within one record (ie) continuation of any single parameter entry from one record to another is not permitted. A single record may contain multiple parameter entries, each being separated by one or more spaces, and optionally a single comma (‘,’).

A parameter entry has the general format:

keyword = value

Each keyword and its associated value are separated by an '=' sign, and optionally one or more spaces. The first keyword parameter in a record may begin in any character position from 1 onwards. Parameters may extend up

82	DB2 Manager User Guide
	StorageTek Proprietary