Database Utilities › Restore a Complete Disk Archival Generation or Selecting SYSOUT Entries (SARTDR) › TLOAD

TLOAD

Use the TLOAD control statement to reload an entire disk archival generation from tape, specific reports, specific resource groups, or the entire contents of a tape. Sysouts are reloaded regardless of where they were originally archived, that is, Sysout groups originally archived Direct-to-Tape are reloaded to disk during the TLOAD.

Before reloading a disk archival generation with this function, you must verify that:

• All archival tapes required for the generation are known to the product. Any tapes not known to the product can be re-added with the SARTDR TADD control statement.
• All archival tapes required for the generation are available and error free. The SARTCP utility can be used to salvage an archival tape containing errors.

Syntax:

/TLOAD ID=(sysout-id,…)
GEN=(gen,…)
RESOURCE=(name,…)
TAPESEQ=sssss
SECOND

where:

ID=(sysout-id,…)

Optionally specifies a SYSOUT identifier, generic SYSOUT identifier, or a list of SYSOUT identifiers to be reloaded to primary or secondary disk.

If the id contains embedded blanks, commas, equal signs, parentheses, or quotes, it must be enclosed in quotes (single or double). Any quotes in Report-id must be entered as a pair of quotes because a non-paired quote ends the ID. For example, if the value is JIM’S REPORT, it must be entered as ‘JIM’’S REPORT’ or “JIM’S REPORT”.

A generic SYSOUT identifier is specified by suffixing a portion of the SYSOUT identifier with an asterisk.

GEN=(gen,…)

Optionally specifies the archival generation number or a list of archival generation numbers for which SYSOUT is to be reloaded to primary or secondary disk.

RESOURCE=(name,…)

Optionally specifies a resource group or a list of resource groups to be reloaded to disk.

Note: Resource groups are never loaded to the secondary disk.

TAPESEQ=ssssss

Specifies the tape sequence number of the backup tape for which SYSOUTs are to be reloaded to primary or secondary disk

If the last SYSOUT on the requested tape spans multiple tapes, SARTDR requests additional tape mounts to reload the entire SYSOUT.

SECOND

Specifies the Sysouts that are to be loaded to secondary (Optical, Centera, etc.,) disk rather than primary disk. Resource groups are never loaded to secondary disk. Resource groups on a tape are bypassed. SECOND requires all secondary disk initialization parameters be established before execution of the /TLOAD SECOND function.

If both the generation number and the tape sequence number are specified, SYSOUTS for the specified generation that reside on the specified tape are reloaded to primary or secondary disk.

Example 1

In this example, suppose generation 1221 is to be loaded back to primary disk from the archival tapes. The name of the database is VIEW.SYSTEM1.

The following job is run:

//EXAMPLE  JOB ACCOUNT,PROGRAMMER
//STEP1    EXEC PGM=SARTDR,PARM='VIEW.SYSTEM1'
//STEPLIB  DD DSN=CAI.CVDELOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSIN    DD *
/TLOAD GEN=1221
/*

Example 2

In this example, CA View backup tape VIEW.SYSTEM1.SARTAPE.T0000143 is to be loaded back to secondary disk. The name of the database is VIEW.SYSTEM1.

The following job is run:

//EXAMPLE  JOB ACCOUNT,PROGRAMMER
//STEP1    EXEC PGM=SARTDR,PARM='VIEW.SYSTEM1'
//STEPLIB  DD DSN=CAI.CVDELOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSIN    DD *
/TLOAD TAPESEQ=143
/*