The following are some examples using the DESCRIBE function.
Figure 164. SYSIN File for Data Restore DESCRIBE (DESCRIBE SYSIN)
CONTROL BASE=S35VMDB1 DESCRIBE |
Figure 165 shows a sample EXEC for the DESCRIBE function. The FILEDEF ARCHIV statement points to the file to be listed, and in this case it is an unloaded dbspace on disk.
Figure 165. EXEC File for Data Restore DESCRIBE (DESCRIBE EXEC)
/**/ 'FILEDEF ARCHIV DISK DRFSAMPL DATA A (RECFM VB BLOCK 32760' 'FILEDEF SYSIN DISK DESCRIBE SYSIN A' 'FILEDEF SYSPRINT DISK DESCRIBE SYSPRINT A' 'XTS91001' Exit rc
Figure 166 shows a SYSPRINT report from a DESCRIBE function of an unloaded dbspace. Message XTS9-174 shows that the dbspace was unloaded by Data Restore on June 10, 1996 at 16:49:26. The other information lists the tables in the dbspace and indicates that the DESCRIBE function was successfully completed.
Figure 166. SYSPRINT File of Data Restore DESCRIBE (DESCRIBE SYSPRINT)
+--------------------------------------------------------------------------------+ | XTS9-143 CONTROL BASE=S35VMDB1 | | XTS9-143 DESCRIBE | | XTS9-143 /* | | XTS9-196 Do you want to continue the DESCRIBE process ? | | XTS9-406 Enter 0(CANCEL) or 1(CONTINUE) | | XTS9-403 Reply is 1 | | XTS9-100 Data Restore feature VERSION 7.1.0 | | XTS9-174 Processing S35VMDB1 unloaded on (10/06/96-16:49:26) | | XTS9-013 Table SQLDBA .ACTIVITY may be reloaded | | XTS9-013 Table SQLDBA .DEPARTMENT may be reloaded | | XTS9-013 Table SQLDBA .DRF_ACTIVITY may be reloaded | | XTS9-013 Table SQLDBA .DRF_SQL_ACTIVITY may be reloaded | | XTS9-013 Table SQLDBA .EMP_ACT may be reloaded | | XTS9-013 Table SQLDBA .EMPLOYEE may be reloaded | | XTS9-013 Table SQLDBA .PROJ_ACT may be reloaded | | XTS9-013 Table SQLDBA .PROJECT may be reloaded | | XTS9-007 Processing successfully completed | +--------------------------------------------------------------------------------+
Figure 178 shows the exec used for this function in VM, and Figure 167 shows a VSE output sample of DESCRIBE.
Figure 167. SYSPRINT File of Data Restore DESCRIBE
+--------------------------------------------------------------------------------+ |// JOB DRFDESCR DESCRIBE ARCHIVE TAPE | |// LIBDEF *,SEARCH=(PRD2.DB2vrm,PRD2.RCVvrm) | |// TLBL ARCHIV ** input file ** | |// ASSGN SYS006,181 | |// MTC REW,SYS006 | |// EXEC XTS91001,SIZE=AUTO | |CONTROL DBNAME=SQLVSE02 | |DESCRIBE | | | |XTS9-143 CONTROL DBNAME=SQLVSE02 | |XTS9-143 DESCRIBE | |XTS9-143 /* | |XTS9-100 Data Restore feature VERSION 7.1.0 | |XTS9-192 Processing SQL/VSE archived by database manager on (05/21/96-07-47-03)| |XTS9-013 Table SQLDBA .ACTIVITY may be reloaded | |XTS9-013 Table DATARFTR.CMD may be reloaded | |XTS9-013 Table SQLDBA .CUSTOMER may be reloaded | | ... more entries in between ......... | |XTS9-013 Table SQLDBA .WAREHOUSE may be reloaded | |XTS9-007 Processing successfully completed | +--------------------------------------------------------------------------------+
Figure 168. CONTROL Statement Defining an Archive for Data Restore RESTORE
CONTROL DATE=05/21/96 TIME=07-47-03
BASE=S35VMDB1
RESTORE
|
If the input file is a FULL BACKUP file, message XTS9-226 will indicate that it is a FULL BACKUP file. For example:
XTS9-143 CONTROL BASE=SQLDBA
XTS9-143 DESCRIBE
XTS9-143 /*
XTS9-196 Do you want to continue the DESCRIBE process ?
XTS9-406 Enter 0(CANCEL) or 1(CONTINUE)
XTS9-403 Reply is 1
XTS9-100 DATA RESTORE FEATURE VERSION 7.1.0
XTS9-136 Processing SQLDBA archived on (02/10/97-09:03:11)
---> XTS9-226 This file is a FULL BACKUP
XTS9-013 Table SQLDBA .ACTIVITY may be reloaded
XTS9-013 Table SQLDBA .DEPARTMENT may be reloaded
XTS9-013 Table SQLDBA .EMP_ACT may be reloaded
XTS9-013 Table SQLDBA .EMPLOYEE may be reloaded
XTS9-013 Table SQLDBA .PROJ_ACT may be reloaded
XTS9-013 Table SQLDBA .PROJECT may be reloaded
XTS9-007 Processing successfully completed
|
If the input file is an INCREMENTAL backup file, message XTS9-226 indicates that the file is an INCREMENTAL backup and backup file. For example:
XTS9-143 CONTROL BASE=SQLDBA
XTS9-143 DESCRIBE
XTS9-143 /*
XTS9-196 Do you want to continue the DESCRIBE process ?
XTS9-406 Enter 0(CANCEL) or 1(CONTINUE)
XTS9-403 Reply is 1
XTS9-100 DATA RESTORE FEATURE VERSION 7.1.0
XTS9-136 Processing SQLDBA archived on (02/10/97-09:03:11)
---> XTS9-226 This file is an INCREMENTAL BACKUP
(01/10/97-08:50:02)
XTS9-013 Table SQLDBA .ACTIVITY may be reloaded
XTS9-013 Table SQLDBA .DEPARTMENT may be reloaded
XTS9-013 Table SQLDBA .EMP_ACT may be reloaded
XTS9-013 Table SQLDBA .EMPLOYEE may be reloaded
XTS9-013 Table SQLDBA .PROJ_ACT may be reloaded
XTS9-013 Table SQLDBA .PROJECT may be reloaded
XTS9-007 Processing successfully completed
|
The following is an example of a function report for the DESCRIBE function on a DB2 FULL archive.
XTS9-143 CONTROL BASE=SQLDBA
XTS9-143 DESCRIBE
XTS9-143 /*
XTS9-196 Do you want to continue the DESCRIBE process ?
XTS9-406 Enter 0(CANCEL) or 1(CONTINUE)
XTS9-403 Reply is 1
XTS9-100 DATA RESTORE FEATURE VERSION 7.1.0
XTS9-136 Processing SQLDBA archived on (02/10/97-09:03:11)
---> XTS9-229 The file is a DB2 FULL archive
XTS9-013 Table SQLDBA .ACTIVITY may be reloaded
XTS9-013 Table SQLDBA .DEPARTMENT may be reloaded
XTS9-007 Processing successfully completed
|
The following is an example of a function report for the DESCRIBE function on a DB2 regular archive.
XTS9-143 CONTROL BASE=SQLDBA
XTS9-143 DESCRIBE
XTS9-143 /*
XTS9-196 Do you want to continue the DESCRIBE process ?
XTS9-406 Enter 0(CANCEL) or 1(CONTINUE)
XTS9-403 Reply is 1
XTS9-100 DATA RESTORE FEATURE VERSION 7.1.0
XTS9-136 Processing SQLDBA archived on (02/10/97-09:43:25)
---> XTS9-229 The file is a DB2 regular archive
XTS9-013 Table SQLDBA .ACTIVITY may be reloaded
XTS9-013 Table SQLDBA .DEPARTMENT may be reloaded
XTS9-007 Processing successfully completed
|