...
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.
| Panel |
|---|
| Html bobswift |
|---|
<pre>
//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
</pre>
|
|
| Anchor |
|---|
| DD Statements used in JCL Procedure |
|---|
| DD Statements used in JCL Procedure |
|---|
|
DD Statements used in JCL Procedure
...
The following figure illustrates the Universal Database Dump for z/OS JCL using the UDBDPRC JCL procedure, above.
| Panel |
|---|
| Html bobswift |
|---|
<pre>
//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=*
</pre>
|
|
| Anchor |
|---|
| Configuration Options |
|---|
| Configuration Options |
|---|
|
Configuration Options
...
http://www.oracle.com/technology/documentation/berkeley-db/db/index.html
| HTML Table |
|---|
summary |
|---|
| cellspacing | 0 |
|---|
| style | text-align: left; width: 100%; |
|---|
| class | Table_with_Header |
|---|
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| style | background-color: #F0F0F0; border-bottom-color: #E8E8E8; border-bottom-style: solid; border-bottom-width: 1px; border-left-color: #E8E8E8; border-left-style: solid; border-left-width: 1px; border-right-color: #E8E8E8; border-right-style: solid; border-right-width: 1px; border-top-color: #E8E8E8; border-top-style: solid; border-top-width: 1px; padding-bottom: 3pt; padding-left: 4pt; padding-right: 4pt; padding-top: 4pt; vertical-align: middle; width: 144pt; |
|---|
| | Option Name |
| Table Cell (td) |
|---|
| style | background-color: #F0F0F0; border-bottom-color: #E8E8E8; border-bottom-style: solid; border-bottom-width: 1px; border-left-color: #E8E8E8; border-left-style: solid; border-left-width: 1px; border-right-color: #E8E8E8; border-right-style: solid; border-right-width: 1px; border-top-color: #E8E8E8; border-top-style: solid; border-top-width: 1px; padding-bottom: 3pt; padding-left: 4pt; padding-right: 4pt; padding-top: 4pt; vertical-align: middle; width: 288pt; |
|---|
| | Description |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| style | border-bottom-color: #E8E8E8; border-bottom-style: solid; border-bottom-width: 1px; border-left-color: #E8E8E8; border-left-style: solid; border-left-width: 1px; border-right-color: #E8E8E8; border-right-style: solid; border-right-width: 1px; border-top-color: #E8E8E8; border-top-style: solid; border-top-width: 1px; padding-bottom: 3pt; padding-left: 4pt; padding-right: 4pt; padding-top: 4pt; vertical-align: top; |
|---|
| | DATABASE_FILE |
| Table Cell (td) |
|---|
| style | border-bottom-color: #E8E8E8; border-bottom-style: solid; border-bottom-width: 1px; border-left-color: #E8E8E8; border-left-style: solid; border-left-width: 1px; border-right-color: #E8E8E8; border-right-style: solid; border-right-width: 1px; border-top-color: #E8E8E8; border-top-style: solid; border-top-width: 1px; padding-bottom: 3pt; padding-left: 4pt; padding-right: 4pt; padding-top: 4pt; vertical-align: top; |
|---|
| | Database file to be dumped. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| style | border-bottom-color: #E8E8E8; border-bottom-style: solid; border-bottom-width: 1px; border-left-color: #E8E8E8; border-left-style: solid; border-left-width: 1px; border-right-color: #E8E8E8; border-right-style: solid; border-right-width: 1px; border-top-color: #E8E8E8; border-top-style: solid; border-top-width: 1px; padding-bottom: 3pt; padding-left: 4pt; padding-right: 4pt; padding-top: 4pt; vertical-align: top; |
|---|
| | DUMP_OPTIONS |
| Table Cell (td) |
|---|
| style | border-bottom-color: #E8E8E8; border-bottom-style: solid; border-bottom-width: 1px; border-left-color: #E8E8E8; border-left-style: solid; border-left-width: 1px; border-right-color: #E8E8E8; border-right-style: solid; border-right-width: 1px; border-top-color: #E8E8E8; border-top-style: solid; border-top-width: 1px; padding-bottom: 3pt; padding-left: 4pt; padding-right: 4pt; padding-top: 4pt; vertical-align: top; |
|---|
| | 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 |
|
|
...
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.
