Universal Database Dump for zOS

Owned by Stonebranch (Deactivated)
Feb 06, 2023
2 min read

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


Note

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