![Start of change](../../delta.gif)
REPORT output
The output from the REPORT utility depends on whether the TABLESPACESET or RECOVERY option is specified.
For the TABLESPACESET option, the output consists of the names of all table spaces in the specified table space set. For the RECOVERY option, the output includes information about the image copy data sets and archive log data set that might be required during the recovery.
REPORT TABLESPACESET output
The output from REPORT TABLESPACESET consists of the names of all table spaces in the table space set that you specify. It also identifies all tables in the table spaces and all tables that are dependent on those tables, including LOB and XML tables, history tables, and archive tables.
- Example of REPORT TABLESPACESET output
- The statement REPORT TABLESPACESET TABLESPACE DSN8DB1A.DSN8S81D generates the output that is
shown in the following figure. For the purposes of this example, an XML column was added to the
sample table
DSN8B10.DEPT.
DSNU000I 270 14:18:14.71 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = REP94 DSNU1044I 270 14:18:14.91 DSNUGTIS - PROCESSING SYSIN AS EBCDIC DSNU050I 270 14:18:14.92 DSNUGUTC - REPORT TABLESPACESET TABLESPACE DSN8DC1A.DSN8SC1D DSNU587I ) 270 14:18:14.94 DSNUPSET - REPORT TABLESPACE SET WITH TABLESPACE DSN8DC1A.DSN8SC1D TABLESPACE SET REPORT: TABLESPACE : DSN8DC1A.DSN8SC1D TABLE : DSN8C10.DEPT INDEXSPACE : DSN8DC1A.XDEPT1 INDEX : DSN8C10.XDEPT11 INDEXSPACE : DSN8DC1A.XDEPT2 INDEX : DSN8c10.XDEPT22 INDEXSPACE : DSN8DC1A.XDEPT3 INDEX : DSN8C10.XDEPT33 INDEXSPACE : DSN8DC1A.IRDOCIDD INDEX : DSN8C10.I_DOCIDDEPT DEP TABLE : DSN8C10.DEPT DSN8C10.EMP DSN8C10.PROJ TABLESPACE : DSN8DC1A.DSN8SC1E TABLE : DSN8C10.EMP INDEXSPACE : DSN8DC1A.XEMP1 INDEX : DSN8C10.XEMP11 INDEXSPACE : DSN8DC1A.XEMP2 INDEX : DSN8C10.XEMP22 DEP TABLE : DSN8C10.DEPT DSN8C10.EMPPROJACT DSN8C10.PROJ TABLESPACE : DSN8DC1A.DSN8SC1P TABLE : DSN8C10.ACT INDEXSPACE : DSN8DC1A.XACT1 INDEX : DSN8C10.XACT11 INDEXSPACE : DSN8DC1A.XACT2 INDEX : DSN8C10.XACT22 DEP TABLE : DSN8C10.PROJACT TABLE : DSN8C10.EMPPROJACT INDEXSPACE : DSN8DC1A.XEMPPROJ INDEX : DSN8C10.XEMPPROJACT1 INDEXSPACE : DSN8DC1A.XEMP1AQJ INDEX : DSN8C10.XEMPPROJACT2 TABLE : DSN8C10.PROJ INDEXSPACE : DSN8DC1A.XPROJ1 INDEX : DSN8C10.XPROJ11 INDEXSPACE : DSN8DC1A.XPROJ2 INDEX : DSN8C10.XPROJ22 DEP TABLE : DSN8C10.PROJ DSN8C10.PROJACT TABLE : DSN8C10.PROJACT INDEXSPACE : DSN8DC1A.XPROJAC1 INDEX : DSN8C10.XPROJAC11 DEP TABLE : DSN8C10.EMPPROJACT XML TABLESPACE SET REPORT: TABLESPACE : DSN8DC1A.DSN8SC1D BASE TABLE : DSN8C10.DEPT COLUMN : XML1 XML TABLESPACE : DSN8DC1A.XDEP0000 XML TABLE : DSN8C10.XDEPT XML NODEID INDEXSPACE: DSN8DC1A.IRNODEID XML NODEID INDEX : DSN8C10.I_NODEIDXDEPT DSNU580I 270 14:18:14.94 DSNUPORT - REPORT UTILITY COMPLETE - ELAPSED TIME=00:00:00 DSNU010I 270 14:18:14.97 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
- Example of REPORT TABLESPACESET output for tables spaces that are included in versioning relationships
- The
output from REPORT TABLESPACESET identifies versioning relationships in the system-period temporal
table space or history table space. The report also includes the related auxiliary LOB and XML table
spaces on both the system-period temporal table space and history table
spaces.
TABLESPACE : DBSOL11.TS001L11 TABLE : ADMF001.TBWSOL11 INDEXSPACE : DBSOL11.IRDOCIDT INDEX : ADMF001.I_DOCIDTBWSOL11 LOB TABLESPACE SET REPORT: TABLESPACE : DBSOL11.TS001L11 BASE TABLE : ADMF001.TBWSOL11 COLUMN : BLOB1 LOB TABLESPACE : DBSOL11.TLWB1L11 AUX TABLE : ADMF001.TBAWLOBB1L11 AUX INDEXSPACE : DBSOL11.IXDLB1L1 AUX INDEX : ADMF001.IXDLB1L1 TABLESPACE : DBSOL11.TS001L11 BASE TABLE : ADMF001.TBWSOL11 COLUMN : XML1 XML TABLESPACE : DBSOL11.XTBW0000 XML TABLE : ADMF001.XTBWSOL11 XML NODEID INDEXSPACE : DBSOL11.IRNODEID XML NODEID INDEX : ADMF001.I_NODEIDXTBWSOL11 XML INDEXSPACE : DBSOL11.IXW11SOL XML INDEX : ADMF001.IXW11SOL11 XML INDEXSPACE : DBSOL11.IXW12SOL XML INDEX : ADMF001.IXW12SOL11 XML INDEXSPACE : DBSOL11.IXW13SOL XML INDEX : ADMF001.IXW13SOL11 XML INDEXSPACE : DBSOL11.IXW14SOL XML INDEX : ADMF001.IXW14SOL11 HISTORY TABLESPACE SET REPORT: BASE TABLE : ADMF001.TBWSOL11 HISTORY TABLESPACE : DBSOL11.HTS001L11 HISTORY TABLE : ADMF001.HTBWSOL11 HISTORY INDEXSPACE : DBSOL11.HIRDOCIDT HISTORY INDEX : ADMF001.HI_DOCIDTBWSOL11 HISTORY LOB TABLESPACE SET REPORT: HISTORY TABLESPACE : DBSOL11.HTS001L11 BASE TABLE : ADMF001.TBWSOL11 COLUMN : BLOB1 HISTORY LOB TABLESPACE : DBSOL11.HTLWB1L11 AUX TABLE : ADMF001.HTBAWLOBB1L11 AUX INDEXSPACE : DBSOL11.HIXDLB1L1 AUX INDEX : ADMF001.HIXDLB1L1 HISTORY XML TABLESPACE SET REPORT: HISTORY TABLESPACE : DBSOL11.HTS001L11 BASE TABLE : ADMF001.TBWSOL11 COLUMN : XML1 HISTORY XML TABLESPACE : DBSOL11.HXTBW0000 XML TABLE : ADMF001.HXTBWSOL11 XML NODEID INDEXSPACE : DBSOL11.HIRNODEID XML NODEID INDEX : ADMF001.HI_NODEIDXTBWSOL11 XML INDEXSPACE : DBSOL11.HIXW11SOL XML INDEX : ADMF001.HIXW11SOL11 XML INDEXSPACE : DBSOL11.HIXW12SOL XML INDEX : ADMF001.HIXW12SOL11 XML INDEXSPACE : DBSOL11.HIXW13SOL XML INDEX : ADMF001.HIXW13SOL11 XML INDEXSPACE : DBSOL11.HHIXW14SOL XML INDEX : ADMF001.HIXW14SOL11
- Example of REPORT TABLESPACESET output for tables spaces that are included in archive relationships
- The following portion of output from REPORT TABLESPACESET shows related archive
objects.
... ARCHIVE TABLESPACE SET REPORT: TABLESPACE : DB516803.TU516806 ARCHIVE TABLE : SC516801.TB_STOCK_PBR_ARCH AR_ENABLED TABLE : SC516801.TB_STOCK_PART INDEXSPACE : DB516803.IX01RARC INDEX : SC516801.IX01_ARCH_STOCK_PBR INDEXSPACE : DB516803.IU01RARC INDEX : SC516801.IU01_ARCH_STOCK_PBR INDEXSPACE : DB516803.IX02RARC INDEX : SC516801.IX02_ARCH_STOCK_PBRT TABLESPACE : DB516807.TU516808 ARCHIVE TABLE : SC516801.TB_ORDERLINE_PBR_ARCH AR_ENABLED TABLE : SC516801.TB_ORDERLINE_PBG INDEXSPACE : DB516807.IU01RARC INDEX : SC516801.IU01_ARCH_ORDERLINE_PBR INDEXSPACE : DB516807.IRDO1JOL INDEX : SC516801.I_DOCIDTB_ORDERLINE_PBR_A INDEXSPACE : DB516807.IX01RARC INDEX : SC516801.IX01_ARCH_ORDERLINE_PBR INDEXSPACE : DB516807.IX02RARC INDEX : SC516801.IX02_ARCH_ORDERLINE_PBR
Related information: Example of REPORT TABLESPACESET output for table spaces with a key label
The following REPORT statement specifies that the utility is to provide key label information for table space DBF07307.TAF07382.
REPORT TABLESPACESET TABLESPACE DBF07303.TAF07305 SHOWDSNS SHOWKEYLABEL
The following example shows the REPORT output:
TABLESPACE : DBF07303.TPF07305 PART: 0001 DSN : DB2SMS.DSNDBC.DBF07303.TPF07305.I0001.A001 KEY LABEL : DB2KEYLABEL1 PART: 0002 DSN : DB2SMS.DSNDBC.DBF07303.TPF07305.I0001.A002 PART: 0003 DSN : DB2SMS.DSNDBC.DBF07303.TPF07305.I0001.A003 KEY LABEL : DB2KEYLABEL1 PART: 0004 DSN : DB2SMS.DSNDBC.DBF07303.TPF07305.I0001.A004 KEY LABEL : DB2KEYLABEL1 PART: 0005 DSN : DB2SMS.DSNDBC.DBF07303.TPF07305.I0001.A005 KEY LABEL : DB2KEYLABEL1 TABLE : SCF07301.TB_STOCK_PART INDEXSPACE : DBF07303.IX01RSTO PART: 0001 DSN : DB2SMS.DSNDBC.DBF07303.IX01RSTO.I0001.A001 KEY LABEL : DB2KEYLABEL1 PART: 0002 DSN : DB2SMS.DSNDBC.DBF07303.IX01RSTO.I0001.A002 PART: 0003 DSN : DB2SMS.DSNDBC.DBF07303.IX01RSTO.I0001.A003 KEY LABEL : DB2KEYLABEL1 PART: 0004 DSN : DB2SMS.DSNDBC.DBF07303.IX01RSTO.I0001.A004 KEY LABEL : DB2KEYLABEL1 PART: 0005 DSN : DB2SMS.DSNDBC.DBF07303.IX01RSTO.I0001.A005 KEY LABEL : DB2KEYLABEL1 INDEX : SCF07301.IX01_STOCK_PART INDEXSPACE : DBF07303.IU01RSTO DSN : DB2SMS.DSNDBC.DBF07303.IU01RSTO.I0001.A001 INDEX : SCF07301.IU01_STOCK_PART INDEXSPACE : DBF07303.IX02RSTO DSN : DB2SMS.DSNDBC.DBF07303.IX02RSTO.I0001.A001 INDEX : SCF07301.IX02_STOCK_PART
Related information:
REPORT RECOVERY output
REPORT RECOVERY displays all information about the image copy data sets and archive log data sets that might be required during the recovery. Specifically, REPORT RECOVERY displays the following information, each in a separate section:
- Recovery information from the SYSIBM.SYSCOPY catalog table, including the history of the
following utilities: QUIESCE, COPY, LOAD, REORG, and RECOVER with the TOCOPY, TOLOGPOINT, or TORBA
option.
For each image copy entry, the output includes the following information:
- The device type
- Whether the copy is the primary or backup copy for the local site or the recovery site.
If the SYSTEM_LEVEL_BACKUPS subsystem parameter is set to YES, your Db2 for z/OS® subsystem is configured to support object-level recoveries from system-level backups. In this case, the output also includes information about any system-level backup copies that can be used to recover an individual table space or index space. This information is included at the end of the report in a section that begins with the following message:DSNU598I - csect-name REPORT RECOVERY SYSTEM-LEVEL BACKUPS
For each system-level backup, you can use the listed location name to determine the copy pool that is associated with it.
If the DSVOLSER column of SYSIBM.SYSCOPY is blank, REPORT RECOVERY does not display volume serial numbers for image copy data sets.
- Log ranges of the table space or index space from the SYSIBM.SYSLGRNX directory.
- Information from archive log data sets ARCHLOG1, ARCHLOG2, or both, from the bootstrap data set.
If REPORT has no data to display for one or more of these sections, the corresponding sections of the report contain the following message:
DSNU588I - NO DATA TO BE REPORTED
- Information about SYSIBM.SYSCOPY rows
- Several columns in the SYSIBM.SYSCOPY catalog table contain values that can be useful in
interpreting the REPORT utility output. Specifically, the combination of ICTYPE, STYPE, and TTYPE
column values define the event that the SYSIBM.SYSCOPY row represents. For information about the
meaning of these column values, see SYSIBM.SYSCOPY
table.
Certain events can prohibit point-in-time recoveries. For information, see Point-in-time recovery.
You can use REPORT RECOVERY output to determine the recovery status of your objects. REPORT uses the following delimiters around the ICTYPE value to indicate certain entries:- * *
- REPORT uses asterisks to denote any non-image copy entries in the SYSIBM.SYSCOPY catalog table. For example, an entry that is added by the QUIESCE utility is marked with asterisks in the REPORT output.
- # #
- REPORT uses number signs to denote any entries in the SYSIBM.SYSCOPY catalog table that were created before any ALTER operations were materialized. For SYSIBM.SYSCOPY entries that were inserted during the materialization of the pending definition changes, REPORT uses asterisks to denote them as non-COPY entries.
- < >
- REPORT uses the less than symbol and greater than symbol to denote an image copy that was made before table space partitions were rebalanced.
- ( )
- REPORT uses parentheses to denote an image copy that was made before a LOG(NO) event. For image copies of indexes, the LOG(NO) event might have occurred on its underlying table space.
- Information about SYSIBM.SYSLGRNX rows and archive logs
- REPORT uses an asterisk (*) to identify SYSIBM.SYSLGRNX rows and archive log entries after the last recovery base and to indicate which logs are needed for a full recovery to the currrent time. (A recovery base includes an image copy or a LOAD REPLACE LOG YES or REORG LOG YES utility event.) In the REPORT output, the asterisk is displayed to the right of the entries. If you specify the CURRENT option, only the SYSIBM.SYSLGRNX rows and the archive log entries after the last recovery base are reported, and the asterisk is not included in the report.
![End of change](../../deltaend.gif)