Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel
Table of Contents

Anchor
JCL Procedure
JCL Procedure
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.


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 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.

Anchor
JCL
JCL
JCL

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

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&#45;db/db/index.html


HTML Table
cellspacing0
styletext-align: left; width: 100%;
classTable_with_Header


Table Row (tr)


Table Cell (td)
stylebackground-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;

Anchor
1096875
1096875
Option Name


Table Cell (td)
stylebackground-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;

Anchor
1096877
1096877
Description



Table Row (tr)


Table Cell (td)
styleborder-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;

Anchor
1096882
1096882
DATABASE_FILE


Table Cell (td)
styleborder-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;

Anchor
1096884
1096884
Database file to be loaded.



Table Row (tr)


Table Cell (td)
styleborder-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;

Anchor
1096889
1096889
OVERWRITE


Table Cell (td)
styleborder-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;

Anchor
1096891
1096891
Specification to overwrite the database file, not update it.




Note
titleNote

UDBLOAD accepts configuration options only on the PARM keyword of the EXEC statement.

Anchor
Command Line Syntax
Command Line Syntax
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.


Panel
[-o]
database