...
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.
| Panel |
|---|
| Html bobswift |
|---|
<pre>
//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
</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 Load for z/OS JCL using the UDBLPRC JCL procedure, above.
| Panel |
|---|
| Html bobswift |
|---|
<pre>
//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=*
//*
</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 loaded. |
|
| 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; |
|---|
| | OVERWRITE |
| 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; |
|---|
| | Specification to overwrite the database file, not update it. |
|
|
...
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.