Skip to main content

Universal Database Dump for z/OS

JCL Procedure​

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

//UDBLPRC  PROC DBOPTS=-r,
//             DBFILE=,
//             SHLQ=#SHLQ,
//             DMPDSN=,
//             DBHFS=
//*
//S1       EXEC PGM=UDBDUMP,
//PARM='ENVAR(TZ=EST5EDT)/&DBHFS &DBOPTS &DBFILE'
//STEPLIB  DD  DSN=&SHLQ..UNV.SUNVLOAD,
//             DISP=SHR
//*
//UNVOUT   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 Dump for z/OS JCL procedure, above.

ddname

Description

STEPLIB

Load library in which program UDBDUMP program is located.

UNVOUT

Database dump file. The dump data set must be a physically sequential data set with a variable-block record format, a record length of 32756, and a block size of 32760.

SYSPRINT

UDBDUMP standard output ddname.

SYSOUT

UDBDUMP standard error ddname.

SYSIN

UDBDUMP standard input.

JCL​

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

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

Configuration Options​

The following table identifies the Universal Database Dump 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

Database file to be dumped.

DUMP_OPTIONS

Controls database dump behavior, including the format of the dump output and the extent to which data is recovered from a possibly corrupt database file

info

UDBDUMP 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 Dump for z/OS. It identifies only those options that are relevant for database recovery.

[-r-p]
database