Figure 205. JCL File for Data Restore RESTORE of a Full Database
* $$ JOB JNM=DRFRESTR,CLASS=7,DISP=D * $$ LST CLASS=A,DISP=D,PRI=3,DEST=(*,ELADM1) * $$ PUN CLASS=A,DISP=D,PRI=3,DEST=(*,ELADM1) // JOB DRFRESTR RESTORE FULL DATABASE from tape // LIBDEF *,SEARCH=(PRD2.DB2vrm,PRD2.RCV510) // EXEC PROC=SQLVSE02 // EXEC PROC=XTS9DLBL // TLBL ARCHIV // ASSGN SYS006,181 // MTC REW,SYS006 /* PAUSE for monitor // EXEC XTS91001,SIZE=AUTO CONTROL DBNAME=SQLVSE02 RESTORE /* /& * $$ EOJ |
Figure 206. JCL File for Data Restore RESTORE of a Storage Pool
* $$ JOB JNM=DRFRESTR,CLASS=7,DISP=D * $$ LST CLASS=A,DISP=D,PRI=3,DEST=(*,ELADM1) * $$ PUN CLASS=A,DISP=D,PRI=3,DEST=(*,ELADM1) // JOB DRFRESTR RESTORE STORAGE POOL from BACKUP tape // LIBDEF *,SEARCH=(PRD2.DB2vrm,PRD2.RCV510) // EXEC PROC=SQLVSE02 // EXEC PROC=XTS9DLBL // TLBL ARCHIV // ASSGN SYS006,181 // MTC REW,SYS006 /* PAUSE for monitor // EXEC XTS91001,SIZE=AUTO CONTROL DBNAME=SQLVSE02 RESTORE POOL=8 /* /& * $$ EOJ |
Figure 207. Output File from Data Restore RESTORE of a Storage Pool
+--------------------------------------------------------------------------------+ |// JOB DRFRESTR DRF 4.1 RESTORE STORAGE POOL FROM BACKUP | |// LIBDEF *,SEARCH=(PRD2.DB2vrm,PRD2.RCVvrm) | |// EXEC PROC=SQLVSE02 | |// PROC CAT='SQLPCAT' | |// DLBL IJSYSUC,'SQLPCAT.USER.CATALOG',,VSAM | |* ********************************************************** | |* SQLVSE02: SQL/DS DATABASE IDENTIFICATION | |* ********************************************************** | |// DLBL BDISK,'SQLVSE02.BDISK.SQLDIR80',,VSAM,CAT=SQLPCAT | |// DLBL LOGDSK1,'SQLVSE02.LOGDSK1.SQLLOG',,VSAM,CAT=SQLPCAT | |// DLBL DDSK1,'SQLVSE02.DDSK1.POOL1',,VSAM,CAT=SQLPCAT | |// DLBL DDSK2,'SQLVSE02.DDSK2.POOL2',,VSAM,CAT=SQLPCAT | |// DLBL DDSK3,'SQLVSE02.DDSK3.POOL3',,VSAM,CAT=SQLPCAT | |// DLBL DDSK4,'SQLVSE02.DDSK4.POOL4',,VSAM,CAT=SQLPCAT | |// DLBL DDSK5,'SQLVSE02.DDSK5.POOL5',,VSAM,CAT=SQLPCAT | |// DLBL DDSK6,'SQLVSE02.DDSK6.POOL6',,VSAM,CAT=SQLPCAT | |// DLBL DDSK7,'SQLVSE02.DDSK7.POOL7',,VSAM,CAT=SQLPCAT | |// DLBL DDSK8,'SQLVSE02.DDSK8.POOL8',,VSAM,CAT=SQLPCAT | |// DLBL DDSK9,'SQLVSE02.DDSK9.POOL9',,VSAM,CAT=SQLPCAT | |// DLBL DDSK10,'SQLVSE02.DDSK10.POOL10',,VSAM,CAT=SQLPCAT | |// DLBL DDSK11,'SQLVSE02.DDSK11.POOL11',,VSAM,CAT=SQLPCAT | |// DLBL DDSK12,'SQLVSE02.DDSK12.POOL12',,VSAM,CAT=SQLPCAT | |// DLBL DDSK13,'SQLVSE02.DDSK13.POOL13',,VSAM,CAT=SQLPCAT | |// DLBL DDSK14,'SQLVSE02.DDSK14.POOL14',,VSAM,CAT=SQLPCAT | |EOP SQLVSE02 | |// EXEC PROC=XTS9DLBL | |// PROC CAT='VSESPUC' | |// DLBL IJSYSUC,'VSESP.USER.CATALOG',,VSAM | |* ********************************************************** | |* XTS9DLBL: DATARESTORE FEATURE WORKFILES | |* ********************************************************** | |// DLBL LMBRWRK,,,VSAM,CAT=VSESPUC | |// DLBL LMBRLG1,,,VSAM,CAT=VSESPUC | |// DLBL LMBRLG2,,,VSAM,CAT=VSESPUC | |// DLBL LMBRLG3,,,VSAM,CAT=VSESPUC | |// DLBL SYS0001,,0,VSAM,RECSIZE=4096,RECORDS=(100,100),CAT=VSESPUC | |// DLBL HEADER,,0,VSAM,RECSIZE=4096,RECORDS=(100,100),CAT=VSESPUC | |// DLBL DIRWORK,,0,VSAM,CAT=VSESPUC | |EOP XTS9DLBL | |// TLBL ARCHIV | |// ASSGN SYS006,181 | |// MTC REW,SYS006 | |// EXEC XTS91001,SIZE=AUTO | | | |XTS9-143 CONTROL DBNAME=SQLVSE02 | |XTS9-143 RESTORE POOL=8 | |XTS9-143 /* | |XTS9-100 Data restore feature VERSION 7.1.0 | |XTS9-136 Processing SQLVSE02 archived on (02/19/97-15:53:07) | |XTS9-182 Following files are needed for recovery | |XTS9-195 UARCHIVE currently mounted | |XTS9-179 Current log | |XTS9-406 Enter 0(CANCEL) or 1(CONTINUE) | |XTS9-403 Reply is 1 | |XTS9-211 Beginning update of directory | |XTS9-006 Processing DDSK8 | |XTS9-010 2452 blocks restored | |XTS9-307 Start the database manager with parameter "STARTUP=U" | |XTS9-007 Processing successfully completed | |1S55I LAST RETURN CODE WAS 0000 | |EOJ DRFRESTR MAX.RETURN CODE=0000 | +--------------------------------------------------------------------------------+
The following is an example of a RESTORE from an INCREMENTAL backup tape in VSE. The JCL or EXEC used for RESTORE must be modified to add a FULLARC label or FILEDEF is used for the incremental backup file.
The SYSIN file used for RESTORE must be modified to add the WRKSIZE parameter on the OPTIONS statement. The value specified must be the same backup time.
// JOB RESTORE
// LIBDEF *,SEARCH=(PRD2.DB2710,PRD2.RCVvrm)
// EXEC PROC=ARIS71DB
// TLBL ARCHIV,'ARCHIVE.SQL',,,1
---> // TLBL FULLARC,'ARCHIVE.SQL',,,,1
// ASSGN SYS006,180
// MTC REW,SYS006
// EXEC XTS91001,SIZE=AUTO
OPTIONS WRKSIZE=nnnn DEVICE2=TAPE
CONTROL DBNAME=dbname
RESTORE
/*
|
Figure 208. EXEC File for Data Restore RESTORE of a Storage Pool from Tape (RESPOOL EXEC)
/* */ /* FILEDEF FOR INPUT FROM TAPE */ 'FILEDEF ARCHIV TAP1 SL (RECFM VB BLOCK 32760' 'FILEDEF SYSIN DISK RESPOOL SYSIN A' 'FILEDEF DIRWORK DISK DIRWORK DATA A' 'FILEDEF SYSPRINT DISK RESPOOL SYSPRINT A' 'XTS91001' exit rc |
Figure 209. SYSIN File for Data Restore RESTORE of a Storage Pool from Tape (RESPOOL SYSIN)
OPTIONS RECOVERY=NO CONFIRM=NO CONTROL DBNAME=ELDB2A RESTORE POOL=8 |
The following is an example of a RESTORE from an INCREMENTAL backup tape in VM. The JCL or EXEC used for RESTORE must be modified to add a FULLARC label or FILEDEF is used for the incremental backup file.
The SYSIN file used for RESTORE must be modified to add the WRKSIZE parameter on the OPTIONS statement. The value specified must be the same backup time.
/**/
'TAPE REW'
'FILEDEF ARCHIV TAP1 SL 1 (RECFM VB BLOCK 32760'
'FILEDEF SYSPRINT DISK RESTORE SYSPRINT A'
---> 'FILEDEF FULLARC TAP1 SL 1 (RECFM VB BLOCK 32760'
'FILEDEF SYSIN DISK RESTORE SYSIN A'
'XTS91001'
|
The SYSIN file should contain:
OPTIONS WRKSIZE=nnnn DEVICE2=TAPE
CONTROL DBNAME=dbname
RESTORE
/*
|
The output from RESTORE will be modified as follows:
XTS9-143 OPTIONS WRKSIZE=4096 DEVICE2=TAPE
XTS9-143 CONTROL BASE=SQLDS
XTS9-143 RESTORE
XTS9-143 /*
XTS9-196 Do you want to continue the RESTORE process ?
XTS9-406 Enter 0(CANCEL) or 1(CONTINUE)
XTS9-403 Reply is 1
XTS9-100 Data Restore feature VERSION 7.1.0
XTS9-304 Restore from user archive invoked
XTS9-305 Current database will be destroyed
XTS9-406 Enter 0(CANCEL) or 1(CONTINUE)
XTS9-403 Reply is 1
XTS9-008 Restoring directory
XTS9-009 15661 directory blocks restored
XTS9-011 Restoring DDSK1
XTS9-010 7 blocks restored
XTS9-011 Restoring DDSK3
XTS9-010 1 blocks restored
XTS9-011 Restoring DDSK1
XTS9-010 199 blocks restored
XTS9-011 Restoring DDSK3
XTS9-010 66 blocks restored
XTS9-011 Restoring DDSK4
---> XTS9-219 Mount SQLDS archived on (11/25/97-06:07:40)
---> XTS9-406 Enter 0(CANCEL) or 1(CONTINUE)
---> XTS9-403 Reply is 1
XTS9-010 54 blocks restored
XTS9-011 Restoring DDSK1
XTS9-010 30 blocks restored
XTS9-011 Restoring DDSK3
XTS9-010 1 blocks restored
XTS9-011 Restoring DDSK4
XTS9-010 67 blocks restored
XTS9-307 Start the database manager with parameter "STARTUP=U"
XTS9-007 Processing successfully completed
|