JCL Procedure

The following figure illustrates the Universal Database Load for z/OS JCL procedure (UDBLPRC, located in the SUNVSAMP library) that is provided to simplify the execution JCL and future maintenance.

//UDBLPRC  PROC DBOPTS=-o, 
//             DBFILE=,
//             SHLQ=#SHLQ,
//             DMPDSN=,
//             DBHFS=
//*
//S1       EXEC PGM=UDBLOAD,
//  PARM='ENVAR(TZ=EST5EDT)/&DBHFS &DBOPTS &DBFILE'
//STEPLIB  DD  DSN=&SHLQ..UNV.SUNVLOAD,
//             DISP=SHR
//*
//UNVIN    DD  DSN=&DMPDSN,
//             DISP=SHR
//*
//SYSPRINT DD  SYSOUT=*
//SYSOUT   DD  SYSOUT=*
//SYSIN    DD  DUMMY
//CEEDUMP  DD  SYSOUT=*
//SYSUDUMP DD  SYSOUT=*
//         PEND

DD Statements used in JCL Procedure

The following table describes the DD statements used in the Universal Database Load for z/OS JCL procedure, above.
 

JCL

The following figure illustrates the Universal Database Load for z/OS JCL using the UDBLPRC JCL procedure, above.

//S1 EXEC PGM=UDBLOAD,
// PARM='ENVAR(TZ=EST5EDT)/&DBHFS &DBOPTS &DBFILE'
//STEPLIB DD DISP=SHR,DSN=&SHLQ..UNV.SUNVLOAD
//*
//UNVIN DD DISP=SHR,DSN=DB.DUMP
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD DUMMY
//CEEDUMP DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//*

Configuration Options

The following table identifies the Universal Database Load for z/OS configuration options. Each Option Name is a link to detailed information about that option.

It describes only those options relevant for database recovery. For details on all options, see the Oracle documentation on the db_dump utility at URL:

http://www.oracle.com/technology/documentation/berkeley-db/db/index.html

Command Line Syntax

The following figure illustrates the command line syntax of Universal Database Load for z/OS. It identifies only those options that are relevant for database recovery.

[-o]
database