Sample REPORT control statements
Use the sample control statements as models for developing your own REPORT control statements.
Example 1: Reporting recovery information for a table space
The following control statement specifies that the REPORT utility is to provide recovery information for table space DSN8D81A.DSN8S81E.
//REORG EXEC DSNUPROC,SYSTEM=V91A,UID='REP97'
//SYSIN DD *
REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E
/*
The preceding statement produces output similar to the following output:
DSNU000I 270 13:00:51.35 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = REP97
DSNU1044I 270 13:00:51.58 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I 270 13:00:51.60 DSNUGUTC - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E
DSNU581I ) 270 13:00:51.60 DSNUPREC - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E
DSNU593I ) 270 13:00:51.61 DSNUPREC - REPORT RECOVERY ENVIRONMENT RECORD:
MINIMUM RBA: 000000000000
MAXIMUM RBA: FFFFFFFFFFFF
MIGRATING RBA: 000000000000
DSNU582I ) 270 13:00:51.61 DSNUPPCP - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E SYSCOPY ROWS
TIMESTAMP = 2006-09-27-11.40.56.074739, IC TYPE = *C*, SHR LVL = , DSNUM = 0000,
START LRSN =00003697A903
DEV TYPE = , IC BACK = , STYPE = L, FILE SEQ = 0000,
PIT LRSN = 000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0000, LOGICAL PART = 0000,
LOGGED = Y, TTYPE =
JOBNAME = , AUTHID = , COPYPAGESF = -1.0E+00
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00
DSNAME = DSN8D91A.DSN8S91E , MEMBER NAME = ,
INSTANCE = 01, RELCREATED = M
TIMESTAMP = 2006-09-27-11.41.38.341008, IC TYPE = *Z*, SHR LVL = , DSNUM = 0004,
START LRSN =000036C8EA3E
DEV TYPE = , IC BACK = , STYPE = , FILE SEQ = 0000,
PIT LRSN = 000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0001, LOGICAL PART = 0004,
LOGGED = Y, TTYPE =
JOBNAME = DSNTEJ1 , AUTHID = SYSADM , COPYPAGESF = -1.0E+00
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00
DSNAME = DSN8D91A.DSN8S91E , MEMBER NAME = ,
INSTANCE = 01, RELCREATED = M
TIMESTAMP = 2006-09-27-11.41.38.341008, IC TYPE = *Z*, SHR LVL = , DSNUM = 0001,
START LRSN =000036C8EA3E
DEV TYPE = , IC BACK = , STYPE = , FILE SEQ = 0000,
PIT LRSN = 000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0001, LOGICAL PART = 0001,
LOGGED = Y, TTYPE =
JOBNAME = DSNTEJ1 , AUTHID = SYSADM , COPYPAGESF = -1.0E+00
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00
DSNAME = DSN8D91A.DSN8S91E , MEMBER NAME = ,
INSTANCE = 01, RELCREATED = M
TIMESTAMP = 2006-09-27-11.41.38.341008, IC TYPE = *Z*, SHR LVL = , DSNUM = 0002,
START LRSN =000036C8EA3E
DEV TYPE = , IC BACK = , STYPE = , FILE SEQ = 0000,
PIT LRSN = 000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0001, LOGICAL PART = 0002,
LOGGED = Y, TTYPE =
JOBNAME = DSNTEJ1 , AUTHID = SYSADM , COPYPAGESF = -1.0E+00
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00
DSNAME = DSN8D91A.DSN8S91E , MEMBER NAME = ,
INSTANCE = 01, RELCREATED = M
TIMESTAMP = 2006-09-27-11.41.38.341008, IC TYPE = *Z*, SHR LVL = , DSNUM = 0003,
START LRSN =000036C8EA3E
DEV TYPE = , IC BACK = , STYPE = , FILE SEQ = 0000,
PIT LRSN = 000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0001, LOGICAL PART = 0003,
LOGGED = Y, TTYPE =
JOBNAME = DSNTEJ1 , AUTHID = SYSADM , COPYPAGESF = -1.0E+00
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00
DSNAME = DSN8D91A.DSN8S91E , MEMBER NAME = ,
INSTANCE = 01, RELCREATED = M
. . .
DSNU586I ) 270 13:00:51.61 DSNUPSUM - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E SUMMARY
DSNU588I ) 270 13:00:51.61 DSNUPSUM - NO DATA TO BE REPORTED
DSNU583I ) 270 13:00:51.61 DSNUPPLR - SYSLGRNX ROWS FROM REPORT RECOVERY FOR TABLESPACE DSN8D91A.DSN8S91E
UCDATE UCTIME START RBA STOP RBA START LRSN STOP LRSN PARTITION MEMBER ID
092706 11405634 00003697B82E 0000369855C3 BF7840C34BF3 BF7840C44D81 0001 0000
092706 11405670 00003697E223 0000369855C3 BF7840C3A2F9 BF7840C44E27 0002 0000
092706 11405707 000036980BC3 0000369855C3 BF7840C3FF60 BF7840C44E92 0003 0000
092706 11405732 000036983674 0000369855C3 BF7840C43C57 BF7840C44F03 0004 0000
092706 11410155 0000369E31B6 000036ADE99C BF7840C8436A BF7840D832E3 0001 0000
092706 11410156 0000369E3ABB 000036A03DB6 BF7840C84546 BF7840D83495 0002 0000
092706 11410156 0000369E3E51 000036A0E15C BF7840C84683 BF7840D8359B 0003 0000
092706 11410159 0000369E4224 000036A5F932 BF7840C84CAA BF7840D83704 0004 0000
092706 11413835 000036C98000 000036D0B672 BF7840EB5CF9 BF7840EBF7A3 0001 0000
092706 11413845 000036CA937C 000036D0B9B6 BF7840EB7562 BF7840EC0150 0002 0000
092706 11413861 000036CC1F1B 000036D0BC2A BF7840EB9B43 BF7840EC0983 0004 0000
092706 11422002 000036FC9A0B 000036FCBA50 BF7841131913 BF7841131F84 0003 0000
092706 11422074 000036FCEB37 000036FD2000 BF784113C93E BF784113E333 0003 0000
092706 11422688 00003701A7B0 000037029A20 BF784119A438 BF78411B9857 0003 0000
092706 11423828 000037091000 0000370930BF BF784124848C BF7841248A06 0005 0000
092706 11424418 0000370DC5B7 0000370E625D BF78412A23C8 BF78412A5DC6 0001 0000
092706 11424419 0000370DE4FC 0000370E63B9 BF78412A2786 BF78412A6101 0002 0000
092706 11424421 0000370E0405 0000370E6515 BF78412A2A82 BF78412A6191 0003 0000
092706 11424427 0000370E230E 0000370E6671 BF78412A39CD BF78412A6210 0004 0000
092706 11424428 0000370E4254 0000370E74C2 BF78412A3CFD BF78412A630C 0005 0000
092706 11424782 0000370F3DF8 0000371086F8 BF78412D9C67 BF78412DFDE7 0001 0000
092706 11424787 0000370F41BA 0000371089A8 BF78412DA8F9 BF78412E02FB 0002 0000
092706 11424791 0000370F44E6 000037108C1C BF78412DB256 BF78412E0B57 0003 0000
092706 11424794 0000370F4812 000037108E90 BF78412DBAC1 BF78412E106B 0004 0000
092706 11424798 0000370F4B3E 00003710919C BF78412DC398 BF78412E14AE 0005 0000
092706 11424871 000037111E5F 00003711222E BF78412E7581 BF78412E7A75 0001 0000
092706 11424880 000037112516 00003711287E BF78412E8CD5 BF78412E910F 0002 0000
092706 11424886 000037112B66 000037112ECE BF78412E9A46 BF78412E9EF3 0003 0000
092706 11424893 0000371131D0 000037113538 BF78412EAAFB BF78412EAF6F 0004 0000
092706 11424898 000037113820 000037113B88 BF78412EB8A5 BF78412EC1C4 0005 0000
DSNU584I ) 270 13:00:51.61 DSNUPPBS - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E ARCHLOG1 BSDS VOLUMES
DSNU588I ) 270 13:00:51.61 DSNUPPBS - NO DATA TO BE REPORTED
DSNU586I ) 270 13:00:51.61 DSNUPSUM - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E SUMMARY
DSNU588I ) 270 13:00:51.61 DSNUPSUM - NO DATA TO BE REPORTED
DSNU589I ) 270 13:00:51.61 DSNUPREC - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E COMPLETE
DSNU580I 270 13:00:51.61 DSNUPORT - REPORT UTILITY COMPLETE - ELAPSED TIME=00:00:00
DSNU010I 270 13:00:51.62 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
Example 2: Reporting table spaces with LOB columns
The following control statement specifies that REPORT is to provide a list of all table spaces that are related to TABLESPACE DSN8D91L.DSN8S91B, which contains a table with three LOB columns. The output includes a separate section titled LOB TABLESPACE SET REPORT showing a list of related LOB table spaces and their tables, indexes, and index spaces. The base table and column to which each LOB object is related is also shown.
REPORT TABLESPACESET TABLESPACE DSN8D91L.DSN8S91B
The preceding statement produces output similar to the following output:
DSNU000I 277 11:19:09.40 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = REP98
DSNU1044I 277 11:19:09.59 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I 277 11:19:09.59 DSNUGUTC - REPORT TABLESPACESET TABLESPACE DSN8D91L.DSN8S91B
DSNU587I ) 277 11:19:09.62 DSNUPSET - REPORT TABLESPACE SET WITH TABLESPACE DSN8D91L.DSN8S91B
TABLESPACE SET REPORT:
TABLESPACE : DSN8D91L.DSN8S91B
TABLE : DSN8910.EMP_PHOTO_RESUME
INDEXSPACE : DSN8D91L.XEMPRPHO
INDEX : DSN8910.XEMP_PHOTO_RESUME
LOB TABLESPACE SET REPORT:
TABLESPACE : DSN8D91L.DSN8S91B
BASE TABLE : DSN8910.EMP_PHOTO_RESUME
COLUMN : PSEG_PHOTO
LOB TABLESPACE : DSN8D91L.DSN8S91L
AUX TABLE : DSN8910.AUX_PSEG_PHOTO
AUX INDEXSPACE : DSN8D91L.XAUXRPSE
AUX INDEX : DSN8910.XAUX_PSEG_PHOTO
COLUMN : BMP_PHOTO
LOB TABLESPACE : DSN8D91L.DSN8S91M
AUX TABLE : DSN8910.AUX_BMP_PHOTO
AUX INDEXSPACE : DSN8D91L.XAUXRBMP
AUX INDEX : DSN8910.XAUX_BMP_PHOTO
COLUMN : RESUME
LOB TABLESPACE : DSN8D91L.DSN8S91N
AUX TABLE : DSN8910.AUX_EMP_RESUME
AUX INDEXSPACE : DSN8D91L.XAUXREMP
AUX INDEX : DSN8910.XAUX_EMP_RESUME
DSNU580I 277 11:19:09.62 DSNUPORT - REPORT UTILITY COMPLETE - ELAPSED TIME=00:00:00
DSNU010I 277 11:19:09.62 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
Example 3: Reporting recovery information for a partition of a partitioned table space
The following control statement specifies that REPORT is to provide recovery information for partition 4 of table space DSN8D91A.DSN8S91E. The partition number is indicated by the DSNUM option.
REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E DSNUM 4
The preceding statement produces output similar to the following output:
DSNU000I 271 18:15:27.26 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = REP99
DSNU1044I 271 18:15:27.55 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I 271 18:15:27.55 DSNUGUTC - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E DSNUM 4
DSNU581I ) 271 18:15:27.62 DSNUPREC - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E
DSNU593I ) 271 18:15:27.66 DSNUPREC - REPORT RECOVERY ENVIRONMENT RECORD:
MINIMUM RBA: 000000000000
MAXIMUM RBA: FFFFFFFFFFFF
MIGRATING RBA: 000000000000
DSNU582I ) 271 18:15:27.66 DSNUPPCP - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E SYSCOPY ROWS
TIMESTAMP = 2006-09-27-11.40.56.074739, IC TYPE = *C*, SHR LVL = , DSNUM = 0000,
START LRSN =00003697A903
DEV TYPE = , IC BACK = , STYPE = L, FILE SEQ = 0000,
PIT LRSN = 000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0000, LOGICAL PART = 0000,
LOGGED = Y, TTYPE =
JOBNAME = , AUTHID = , COPYPAGESF = -1.0E+00
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00
DSNAME = DSN8D91A.DSN8S91E , MEMBER NAME = ,
INSTANCE = 01, RELCREATED = M
TIMESTAMP = 2006-09-27-11.41.38.341008, IC TYPE = *Z*, SHR LVL = , DSNUM = 0004,
START LRSN =000036C8EA3E
DEV TYPE = , IC BACK = , STYPE = , FILE SEQ = 0000,
PIT LRSN = 000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0001, LOGICAL PART = 0004,
LOGGED = Y, TTYPE =
JOBNAME = DSNTEJ1 , AUTHID = SYSADM , COPYPAGESF = -1.0E+00
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00
DSNAME = DSN8D91A.DSN8S91E , MEMBER NAME = ,
INSTANCE = 01, RELCREATED = M
TIMESTAMP = 2006-09-27-11.41.51.120054, IC TYPE = *Q*, SHR LVL = , DSNUM = 0000,
START LRSN =000036E2BA9E
DEV TYPE = , IC BACK = , STYPE = W, FILE SEQ = 0000,
PIT LRSN = 000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0001, LOGICAL PART = 0000,
LOGGED = Y, TTYPE =
JOBNAME = DSNTEJ1 , AUTHID = SYSADM , COPYPAGESF = -1.0E+00
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00
DSNAME = DSN8D91A.DSN8S91E , MEMBER NAME = ,
INSTANCE = 01, RELCREATED = M
TIMESTAMP = 2006-09-27-11.41.53.524797, IC TYPE = *F*, SHR LVL = R, DSNUM = 0000,
START LRSN =000036E883E4
DEV TYPE = 3390 , IC BACK = , STYPE = , FILE SEQ = 0000,
PIT LRSN = 000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0004, OLDEST VERSION = 0000, LOGICAL PART = 0000,
LOGGED = Y, TTYPE =
JOBNAME = DSNTEJ1 , AUTHID = SYSADM , COPYPAGESF = 5.7E+01
NPAGESF = 6.7E+01 , CPAGESF = 5.7E+01
DSNAME = DB2V91A.SYSCOPY.DSN8D91A.DSN8S91E , MEMBER NAME = ,
INSTANCE = 01, RELCREATED = M
TIMESTAMP = 2006-09-27-11.41.55.631749, IC TYPE = *Q*, SHR LVL = , DSNUM = 0000,
START LRSN =000036EA809A
DEV TYPE = , IC BACK = , STYPE = W, FILE SEQ = 0000,
PIT LRSN = 000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0001, LOGICAL PART = 0000,
LOGGED = Y, TTYPE =
JOBNAME = DSNTEJ1 , AUTHID = SYSADM , COPYPAGESF = -1.0E+00
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00
DSNAME = DSN8D91A.DSN8S91E , MEMBER NAME = ,
INSTANCE = 01, RELCREATED = M
TIMESTAMP = 2006-09-27-11.42.48.167991, IC TYPE = *X*, SHR LVL = , DSNUM = 0000,
START LRSN =0000370CA39B
DEV TYPE = , IC BACK = , STYPE = A, FILE SEQ = 0000,
PIT LRSN = 000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0005, OLDEST VERSION = 0000, LOGICAL PART = 0000,
LOGGED = Y, TTYPE =
JOBNAME = DSNTEJ1 , AUTHID = SYSADM , COPYPAGESF = -1.0E+00
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00
DSNAME = DSN8D91A.DSN8S91E , MEMBER NAME = ,
INSTANCE = 01, RELCREATED = M
TIMESTAMP = 2006-09-27-11.42.49.027488, IC TYPE = F , SHR LVL = R, DSNUM = 0000,
START LRSN =000037113E08
DEV TYPE = 3390 , IC BACK = , STYPE = X, FILE SEQ = 0000,
PIT LRSN = 000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0005, OLDEST VERSION = 0000, LOGICAL PART = 0000,
LOGGED = Y, TTYPE =
JOBNAME = DSNTEJ1 , AUTHID = SYSADM , COPYPAGESF = 2.0E+01
NPAGESF = 1.6E+01 , CPAGESF = 1.6E+01
DSNAME = DB2V91A.DSN8D91A.DSN8S91E.REORGCPY , MEMBER NAME = ,
INSTANCE = 01, RELCREATED = M
DSNU586I ) 271 18:15:27.66 DSNUPSUM - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E SUMMARY
DSNU588I ) 271 18:15:27.66 DSNUPSUM - NO DATA TO BE REPORTED
DSNU583I ) 271 18:15:27.66 DSNUPPLR - SYSLGRNX ROWS FROM REPORT RECOVERY FOR TABLESPACE DSN8D91A.DSN8S91E
UCDATE UCTIME START RBA STOP RBA START LRSN STOP LRSN PARTITION MEMBER ID
092706 11405732 000036983674 0000369855C3 BF7840C43C57 BF7840C44F03 0004 0000
092706 11410159 0000369E4224 000036A5F932 BF7840C84CAA BF7840D83704 0004 0000
092706 11413861 000036CC1F1B 000036D0BC2A BF7840EB9B43 BF7840EC0983 0004 0000
092706 11424427 0000370E230E 0000370E6671 BF78412A39CD BF78412A6210 0004 0000
092706 11424794 0000370F4812 000037108E90 BF78412DBAC1 BF78412E106B 0004 0000
092706 11424893 0000371131D0 000037113538 BF78412EAAFB BF78412EAF6F 0004 0000
DSNU584I ) 271 18:15:27.66 DSNUPPBS - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E ARCHLOG1 BSDS VOLUMES
DSNU588I ) 271 18:15:27.66 DSNUPPBS - NO DATA TO BE REPORTED
DSNU586I ) 271 18:15:27.66 DSNUPSUM - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E SUMMARY
DSNU588I ) 271 18:15:27.66 DSNUPSUM - NO DATA TO BE REPORTED
DSNU589I ) 271 18:15:27.66 DSNUPREC - REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E COMPLETE
DSNU580I 271 18:15:27.66 DSNUPORT - REPORT UTILITY COMPLETE - ELAPSED TIME=00:00:00
DSNU010I 271 18:15:27.67 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
Example 4: Reporting recovery information for an index
The control statement specifies that REPORT is to provide recovery information for index DSN8810.XDEPT1.
The preceding statement produces output similar to the following output:
DSNU000I 270 13:51:08.82 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = REP101
DSNU1044I 270 13:51:09.04 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I 270 13:51:09.04 DSNUGUTC - REPORT RECOVERY INDEX DSN8910.XDEPT1
DSNU581I ) 270 13:51:09.05 DSNUPREC - REPORT RECOVERY INDEX DSN8910.XDEPT1
DSNU593I ) 270 13:51:09.05 DSNUPREC - REPORT RECOVERY ENVIRONMENT RECORD:
MINIMUM RBA: 000000000000
MAXIMUM RBA: FFFFFFFFFFFF
MIGRATING RBA: 000000000000
DSNU582I ) 270 13:51:09.05 DSNUPPCP - REPORT RECOVERY INDEX DSN8910.XDEPT1 SYSCOPY ROWS
TIMESTAMP = 2006-09-27-13.50.30.627880, IC TYPE = F , SHR LVL = R, DSNUM = 0000,
START LRSN =00003726ADE3
DEV TYPE = 3390 , IC BACK = , STYPE = , FILE SEQ = 0000,
PIT LRSN = 000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0001, OLDEST VERSION = 0000, LOGICAL PART = 0000,
LOGGED = Y, TTYPE =
JOBNAME = REP101 , AUTHID = SYSADM , COPYPAGESF = 5.0E+00
NPAGESF = 5.0E+00 , CPAGESF = 0.0E0
DSNAME = DSN8D91A.XDEPT1.D2006270.T205030 , MEMBER NAME = ,
INSTANCE = 01, RELCREATED = M
DSNU586I ) 270 13:51:09.05 DSNUPSUM - REPORT RECOVERY INDEX DSN8910.XDEPT1 SUMMARY
DSNU588I ) 270 13:51:09.05 DSNUPSUM - NO DATA TO BE REPORTED
DSNU583I ) 270 13:51:09.05 DSNUPPLR - SYSLGRNX ROWS FROM REPORT RECOVERY FOR INDEX DSN8910.XDEPT1
DSNU588I ) 270 13:51:09.05 DSNUPPLR - NO DATA TO BE REPORTED
DSNU584I ) 270 13:51:09.05 DSNUPPBS - REPORT RECOVERY INDEX DSN8910.XDEPT1 ARCHLOG1 BSDS VOLUMES
DSNU588I ) 270 13:51:09.05 DSNUPPBS - NO DATA TO BE REPORTED
DSNU586I ) 270 13:51:09.05 DSNUPSUM - REPORT RECOVERY INDEX DSN8910.XDEPT1 SUMMARY
DSNU588I ) 270 13:51:09.05 DSNUPSUM - NO DATA TO BE REPORTED
DSNU589I ) 270 13:51:09.05 DSNUPREC - REPORT RECOVERY INDEX DSN8910.XDEPT1 COMPLETE
DSNU580I 270 13:51:09.05 DSNUPORT - REPORT UTILITY COMPLETE - ELAPSED TIME=00:00:00
DSNU010I 270 13:51:09.06 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
Example 5: Reporting table space set information with XML columns
The following utility control statement specifies that REPORT is to list all objects that are related to the base table space.
REPORT TABLESPACESET TABLESPACE DBKQAN01.TPKQAN01
In this example, the base table includes two XML columns. The following output for this REPORT statement lists the objects that were implicitly created to store data for those XML columns.
TABLESPACE SET REPORT:
TABLESPACE : DBKQAN01.TPKQAN01
TABLE : ADMF001.TBKQAN01
INDEXSPACE : DBKQAN01.IPKQAN11
INDEX : ADMF001.IPKQAN111
INDEXSPACE : DBKQAN01.IRDOCIDT
INDEX : ADMF001.I_DOCIDTBKQAN01
INDEXSPACE : DBKQAN01.IXKQAN12
INDEX : ADMF001.IXKQAN122
XML TABLESPACE SET REPORT:
TABLESPACE : DBKQAN01.TPKQAN01
BASE TABLE : ADMF001.TBKQAN01
COLUMN : XML1
XML TABLESPACE : DBKQAN01.XTBK0000
XML TABLE : ADMF001.XTBKQAN01
XML NODEID INDEXSPACE: DBKQAN01.IRNODEID
XML NODEID INDEX : ADMF001.I_NODEIDXTBKQAN01
XML INDEXSPACE : DBKQAN01.XVIXLC11
XML INDEX : ADMF001.XVIXLC11
COLUMN : XML2
XML TABLESPACE : DBKQAN01.XTBK0001
XML TABLE : ADMF001.XTBKQAN01000
XML NODEID INDEXSPACE: DBKQAN01.IRNO1MH2
XML NODEID INDEX : ADMF001.I_NODEIDXTBKQAN01000
XML INDEXSPACE : DBKQAN01.XVIXLC12
XML INDEX : ADMF001.XVIXLC12
Example 6: Reporting versioning relationships for system-period temporal table spaces
The following utility control statement specifies that REPORT is to list all objects that are related to the base table space.
REPORT TABLESPACESET TABLESPACE DBSOL11.TS001L11
The following report shows the objects that are involved in versioning relationships. The report also includes related auxiliary LOB and XML table spaces on both the system-period temporal table space and the history table spaces.
TABLESPACE SET REPORT:
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
XML TABLESPACE SET REPORT:
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