Universal Database Load for zOS
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.
ddname | Description |
---|---|
STEPLIB | Load library in which program UDBLOAD program is located. |
UNVIN | Database dump file prodcued by Universal Database Dump. |
SYSPRINT | UDBLOAD standard output ddname. |
SYSOUT | UDBLOAD standard error ddname. |
SYSIN | UDBLOAD standard input. |
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
Option Name | Description |
---|---|
Database file to be loaded. | |
Specification to overwrite the database file, not update it. |
Note
UDBLOAD accepts configuration options only on the PARM keyword of the EXEC statement.
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.