Restore Databases

Use the SARRSP utility program to restore all panels, messages, or SYSOUT groups that reside in disk status to the database. These entities can be from either SARDBASE UNLOAD tapes or
View
backup tapes. This utility must be executed after the normal restore process provided with the SARDBASE utility (RESTORE control statement).
view
Use the SARRSP utility program to restore all panels, messages, or SYSOUT groups that reside in disk status to the database. These entities can be from either SARDBASE UNLOAD tapes or
View
backup tapes. This utility must be executed after the normal restore process provided with the SARDBASE utility (RESTORE control statement).
In certain situations, the restore function provided with the SARDBASE utility cannot fully restore the contents of the database.
It works this way:
  • The SARDBASE restoration process attempts to copy panels, messages, and SYSOUT groups from the old database, if specified, to repopulate the database.
  • When the old database is severely damaged or does not exist, panels, messages, and SYSOUT groups that are unsuccessfully copied occupy an empty file.
    In this case, the SARTDR utility (tape dump restore utility) is normally used to reload entire tapes or generations back to the database.
  • With the ability of the expanded retention option to maintain SYSOUT on disk for long periods of time, the restoration process requires a vast amount of disk space. There must be enough space to hold SYSOUT that didn't previously reside on disk.
The SARRSP utility attempts to restore any panel data, message data, or non-resident SYSOUT group in two ways:
  • From a
    View
    unload tape (if the SARLOAD DD statement is specified)
  • Dynamically, from the
    View
    backup tape
    The backup tapes are dynamically allocated, if needed, by tape sequence number. In cases where the backup tape is damaged or unusable, the respective SYSOUT groups are removed from disk status.
Note: If all panel and message data is not completely restored, after the restore process you must reload the online library (panels and messages) to the database with the SARDBASE utility (OLOAD control statement).
Job Control Statements
Sample execution JCL is in member HAEXRSP in your CVDEJCL data set.
These job control statements are required to execute SARRSP:
  • JOB
    Initiates the job.
  • EXEC
    Specifies the program name (PGM=SARRSP) and the high-level name of the database as the PARM parameter (PARM='VIEW.SYSTEM1').
  • STEPLIB DD
    Defines the load library containing SARRSP.
    If the program resides in a linklist library, omit this statement.
  • SYSPRINT DD
    Defines a sequential output data set (normally SYSOUT) used for messages.
    If not a SYSOUT data set, data set must be coded with RECFM=FBA, LRECL=133, and a BLKSIZE that is a multiple of 133.
  • SARLOAD DD
    Defines a
    View
    unload tape created by the SARDBASE utility (UNLOAD control statement) from which panels, messages, and SYSOUT groups can be restored.
    FREE=CLOSE can be coded on the DD statement to dismount the tape at the end of the SORT input phase as opposed to step termination. The DD statement is optional and must only be specified when a
    View
    unload tape exists.
  • SORTLIB DD
    Defines the load library that contains the SORT program library.
    This DD statement might not be needed if the sort program library is moved to LPA.
  • SYSOUT DD
    Defines a sequential output data set (normally SYSOUT) to which SORT messages are written.
  • SORTWKnn DD
    Defines temporary sort work disk space where nn represents a numeric number.
    Normally a minimum of three sort work DD statements are specified.
Example
To restore panels, messages, and SYSOUT to the VIEW.SYSTEM1 database, use the following JCL:
//SARRSP JOB ACCOUNT,PROGRAMMER //STEP1 EXEC PGM=SARRSP,PARM='VIEW.SYSTEM1' //STEPLIB DD DSN=CAI.CVDELOAD,DISP=SHR //SARLOAD DD DSN=VIEW.SYSTEM1.UNLOAD(0), // DISP=SHR,FREE=CLOSE //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSOUT DD SYSOUT=* //SORTLIB DD DSN=SYS1.SORTLIB,DISP=SHR //SORTWK01 DD UNIT=SYSDA, // SPACE=(CYL,(10),,CONTIG) //SORTWK02 DD UNIT=SYSDA, // SPACE=(CYL,(10),,CONTIG) //SORTWK03 DD UNIT=SYSDA, // SPACE=(CYL,(10),,CONTIG)