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.
//REPORT 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 information for 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 following REPORT statement specifies that the utility is to provide recovery information for index DSN8810.XDEPT1.
//REP101 EXEC DSNUPROC,SYSTEM=V91A,UID='REP101'
//SYSIN DD *
REPORT RECOVERY INDEX DSN8910.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
Example 7: Reporting related archive tables
This example uses the following tables:
- TB_WAREHOUSE_SEG
- An application-period temporal table.
- TB_DISTRICT_SEG
- A regular table that has a referential constraint that is dependent on table TB_WAREHOUSE_SEG.
- TB_STOCK_PART
- An archive-enabled table that has a referential constraint that is dependent on table TB_WAREHOUSE_SEG.
- TB_ORDER_PBR
- A system-period temporal table that has a referential constraint that is dependent on table TB_DISTRICT_SEG.
- TB_ORDERLINE_PBG
- An archive-enabled table that has referential constraints that are dependent on tables TB_STOCK_PART and TB_ORDER_PBR.
These tables were created by the following SQL:
* ---------------------------------------------------
* Table: SC516801.TB_WAREHOUSE_SEG
* Unique Index: SC516801.IU01_WAREHOUSE_SEG
* Index: SC516801.IX01_WAREHOUSE_SEG
* SC516801.IX02_WAREHOUSE_SEG
* SC516801.IX03_WAREHOUSE_SEG
* Index on Exp: SC516801.IX04_WAREHOUSE_SEG
* View: SC516801.VW_WAREHOUSE_SEG
* ---------------------------------------------------
CREATE TABLE SC516801.TB_WAREHOUSE_SEG
(WAREHOUSE_CREATE_XML1 XML,
WAREHOUSE_ID CHAR(10) NOT NULL WITH DEFAULT
CONSTRAINT CNST_WAREHOUSEID
CHECK (WAREHOUSE_ID IN('0000000001','0000000002','0000000003',
'0000000004','0000000005','0000000006',
'0000000007','0000000008','0000000009',
'0000000010')),
WAREHOUSE_NAME CHAR(10) NOT NULL WITH DEFAULT,
WAREHOUSE_STREET_1 VARCHAR(40) NOT NULL WITH DEFAULT,
WAREHOUSE_STREET_2 VARCHAR(40) FIELDPROC FPCVD4,
WAREHOUSE_CITY VARCHAR(20) NOT NULL WITH DEFAULT,
WAREHOUSE_STATE CHAR(2) NOT NULL WITH DEFAULT,
WAREHOUSE_ZIP CHAR(9) NOT NULL
DEFAULT '000000000',
WAREHOUSE_TAX DECIMAL(5,4) NOT NULL WITH DEFAULT,
WAREHOUSE_YTD SC516801.US_DOLLAR NOT NULL WITH DEFAULT,
WAREHOUSE_CREATE_BIGINT1 BIGINT NOT NULL WITH DEFAULT,
WAREHOUSE_CREATE_BINARY1 BINARY(101) NOT NULL WITH DEFAULT,
WAREHOUSE_CREATE_VARBINARY1 VARBINARY(500) NOT NULL WITH DEFAULT,
WAREHOUSE_CREATE_DECFLOAT1 DECFLOAT(34) NOT NULL WITH DEFAULT,
BUS_START DATE NOT NULL ,
BUS_END DATE NOT NULL ,
PERIOD BUSINESS_TIME(BUS_START,BUS_END) ,
PRIMARY KEY(WAREHOUSE_ID)
)
IN DB516801.TS516801;
COMMIT;
...
* ---------------------------------------------------
* Table: SC516801.TB_DISTRICT_SEG
* Unique Index: SC516801.IU01_DISTRICT_SEG
* Index: SC516801.IX01_DISTRICT_SEG
* Index on Exp: SC516801.IX02_DISTRICT_SEG
* View: SC516801.VW_DISTRICT_SEG
* LOB table space: TA516801
* Auxiliary Table: SC516801.TX01_CLOB1_DISTRICT_SEG
* Auxiliary Index: SC516801.IA_CLOB1_DISTRICT_SEG
* ---------------------------------------------------
CREATE TABLE SC516801.TB_DISTRICT_SEG
(DISTRICT_ID CHAR(2) NOT NULL WITH DEFAULT
CONSTRAINT CNST_DISTRICTID
CHECK (DISTRICT_ID IN('01','02','03','04','05',
'06','07','08','09','10')),
DISTRICT_WAREHOUSE_ID CHAR(10) NOT NULL WITH DEFAULT,
DISTRICT_NAME CHAR(20) NOT NULL WITH DEFAULT,
DISTRICT_TAX DECIMAL(5,4) NOT NULL WITH DEFAULT,
DISTRICT_YTD SC516801.US_DOLLAR NOT NULL WITH DEFAULT,
DISTRICT_NEXT_ORDER_ID INTEGER NOT NULL WITH DEFAULT,
DISTRICT_STATE CHAR(2) NOT NULL WITH DEFAULT,
DISTRICT_ZIP CHAR(9) NOT NULL WITH DEFAULT,
DISTRICT_STREET_1 VARCHAR(40) NOT NULL WITH DEFAULT,
DISTRICT_STREET_2 VARCHAR(40) ,
DISTRICT_CITY VARCHAR(20) NOT NULL WITH DEFAULT,
DISTRICT_CREATE_BIGINT1 BIGINT NOT NULL WITH DEFAULT,
DISTRICT_CREATE_BINARY1 BINARY(25) NOT NULL WITH DEFAULT,
DISTRICT_CREATE_DECFLOAT1 DECFLOAT(16) NOT NULL WITH DEFAULT,
DISTRICT_CREATE_CLOB1 CLOB(2K) NOT NULL WITH DEFAULT,
PRIMARY KEY (DISTRICT_WAREHOUSE_ID, DISTRICT_ID),
FOREIGN KEY (DISTRICT_WAREHOUSE_ID)
REFERENCES SC516801.TB_WAREHOUSE_SEG(WAREHOUSE_ID)
ON DELETE CASCADE)
IN DB516801.TS516801;
COMMIT;
...
* ---------------------------------------------------
* Table: SC516801.TB_STOCK_PART
* Unique Index: SC516801.IU01_STOCK_PART
* Index: SC516801.IX01_STOCK_PART
* Index on Exp: SC516801.IX02_STOCK_PART
* View: SC516801.VW_STOCK_PART
* ---------------------------------------------------
CREATE TABLE SC516801.TB_STOCK_PART
(STOCK_ITEM_ID CHAR(6) NOT NULL WITH DEFAULT,
STOCK_WAREHOUSE_ID CHAR(10) NOT NULL WITH DEFAULT,
STOCK_QUANTITY INTEGER NOT NULL WITH DEFAULT,
STOCK_YTD INTEGER NOT NULL WITH DEFAULT,
STOCK_ORDER_CNT SMALLINT NOT NULL WITH DEFAULT,
STOCK_REMOTE_CNT SMALLINT NOT NULL WITH DEFAULT,
STOCK_DISTRICT_01 CHAR(24) NOT NULL WITH DEFAULT,
STOCK_DISTRICT_02 CHAR(24) NOT NULL WITH DEFAULT,
STOCK_DISTRICT_03 CHAR(24) NOT NULL WITH DEFAULT,
STOCK_DISTRICT_04 CHAR(24) NOT NULL WITH DEFAULT,
STOCK_DISTRICT_05 CHAR(24) NOT NULL WITH DEFAULT,
STOCK_DISTRICT_06 CHAR(24) NOT NULL WITH DEFAULT,
STOCK_DISTRICT_07 CHAR(24) NOT NULL WITH DEFAULT,
STOCK_DISTRICT_08 CHAR(24) NOT NULL WITH DEFAULT,
STOCK_DISTRICT_09 CHAR(24) NOT NULL WITH DEFAULT,
STOCK_DISTRICT_10 CHAR(24) NOT NULL WITH DEFAULT,
STOCK_DATA CHAR(50) ,
STOCK_CREATE_BIGINT1 BIGINT NOT NULL WITH DEFAULT,
STOCK_CREATE_BINARY1 BINARY(50) NOT NULL WITH DEFAULT,
STOCK_CREATE_VARBINARY1 VARBINARY(1000) NOT NULL WITH DEFAULT,
STOCK_CREATE_DECFLOAT1 DECFLOAT(34) NOT NULL WITH DEFAULT,
STOCK_CREATE_RCT1 TIMESTAMP NOT NULL
GENERATED BY DEFAULT FOR EACH ROW ON UPDATE
AS ROW CHANGE TIMESTAMP IMPLICITLY HIDDEN,
SYS_START TIMESTAMP(12) NOT NULL WITH DEFAULT ,
SYS_END TIMESTAMP(12) NOT NULL WITH DEFAULT ,
TRANS_ID TIMESTAMP(12) NOT NULL WITH DEFAULT ,
PRIMARY KEY (STOCK_WAREHOUSE_ID, STOCK_ITEM_ID),
FOREIGN KEY (STOCK_WAREHOUSE_ID)
REFERENCES SC516801.TB_WAREHOUSE_SEG(WAREHOUSE_ID)
ON DELETE CASCADE
)
PARTITION BY (STOCK_WAREHOUSE_ID,STOCK_ITEM_ID)
(PARTITION 1 ENDING ('0000000002','999999') ,
PARTITION 2 ENDING ('0000000004','999999') ,
PARTITION 3 ENDING ('0000000006','999999') ,
PARTITION 4 ENDING ('0000000008','999999') ,
PARTITION 5 ENDING ('0000000011','999999'))
IN DB516803.TP516805;
COMMIT;
...
ALTER TABLE TB_STOCK_PART
ENABLE ARCHIVE USE TB_STOCK_PBR_ARCH;
...
* ---------------------------------------------------
* Table: SC516801.TB_ORDER_PBR
* UNIQUE INDEX: SC516801.IU01_ORDER_PBR
* SC516801.IU02_ORDER_PBR
* SC516801.IU03_ORDER_PBR
* SC516801.IU04_ORDER_PBR
* Index on Exp: SC516801.IU05_ORDER_PBR
* Index: SC516801.IX01_ORDER_PBR
* SC516801.IX02_ORDER_PBR
* View: SC516801.VW_ORDER_PBR
* ---------------------------------------------------
CREATE TABLE SC516801.TB_ORDER_PBR
(ORDER_ID INTEGER NOT NULL WITH DEFAULT,
ORDER_DISTRICT_ID CHAR(2) NOT NULL WITH DEFAULT,
ORDER_WAREHOUSE_ID CHAR(10) NOT NULL WITH DEFAULT,
ORDER_CUSTOMER_ID INTEGER GENERATED BY DEFAULT
AS IDENTITY (START WITH 1,INCREMENT BY 1) UNIQUE,
ORDER_CARRIER_ID CHAR(2),
ORDER_ORDERLINE_COUNT SMALLINT NOT NULL WITH DEFAULT,
ORDER_ALL_LOCAL SMALLINT NOT NULL WITH DEFAULT,
ORDER_ENTRY_DATE TIMESTAMP NOT NULL WITH DEFAULT
'2008-02-01-01.59.59.000000',
ORDER_ESTIMATE_DATE DATE DEFAULT '2008-01-01',
ORDER_ESTIMATE_TIME TIME DEFAULT '01.59.59',
ORDER_SHIP_DATE DATE NOT NULL DEFAULT '2008-01-01',
ORDER_SHIP_TIME TIME NOT NULL DEFAULT '01.59.59',
ORDER_CREATE_VARBINARY1 VARBINARY(500) NOT NULL WITH DEFAULT,
ORDER_CREATE_BIGINT1 BIGINT NOT NULL WITH DEFAULT,
ORDER_CREATE_BINARY1 BINARY(80) NOT NULL WITH DEFAULT,
ORDER_CREATE_DECFLOAT1 DECFLOAT(34) NOT NULL WITH DEFAULT
IMPLICITLY HIDDEN,
ORDER_CREATE_CLOB1 CLOB(2K) NOT NULL WITH DEFAULT,
ORDER_CREATE_BLOB1 BLOB(2K) NOT NULL WITH DEFAULT,
ORDER_CREATE_XML XML ,
ORDER_CREATE_RCT1 TIMESTAMP NOT NULL
GENERATED ALWAYS FOR EACH ROW ON UPDATE
AS ROW CHANGE TIMESTAMP
IMPLICITLY HIDDEN,
SYS_START TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS ROW BEGIN ,
SYS_END TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS ROW END ,
TRANS_ID TIMESTAMP(12) GENERATED ALWAYS AS TRANSACTION START ID,
PERIOD SYSTEM_TIME(SYS_START, SYS_END) ,
PRIMARY KEY (ORDER_WAREHOUSE_ID,
ORDER_DISTRICT_ID,
ORDER_ID),
FOREIGN KEY (ORDER_WAREHOUSE_ID,
ORDER_DISTRICT_ID)
REFERENCES SC516801.TB_DISTRICT_SEG(DISTRICT_WAREHOUSE_ID,
DISTRICT_ID)
ON DELETE CASCADE)
PARTITION BY (ORDER_ID ASC)
(PARTITION 1 ENDING AT (03000) INCLUSIVE,
PARTITION 2 ENDING (06000) INCLUSIVE,
PARTITION 3 ENDING (2147483647) INCLUSIVE)
IN DB516803.TU516803;
...
ALTER TABLE SC516801.TB_ORDER_PBR
ADD VERSIONING USE HISTORY TABLE SC516801.TB_ORDER_SEG_HIST;
...
* ---------------------------------------------------
* Table: SC516801.TB_ORDERLINE_PBG bi-temporal table
* Unique Index: SC516801.IU01_ORDERLINE_PBG
* Index: SC516801.IX01_ORDERLINE_PBG
* Index on Exp: SC516801.IX02_ORDERLINE_PBG
* View: SC516801.VW_ORDERLINE_PBG
*---------------------------------------------------------------------
CREATE TABLE SC516801.TB_ORDERLINE_PBG
(ORDERLINE_CREATE_XML1 XML,
ORDERLINE_CREATE_LOB CLOB(2K) ,
ORDERLINE_ORDER_ID INTEGER NOT NULL WITH DEFAULT,
ORDERLINE_DISTRICT_ID CHAR(2) NOT NULL WITH DEFAULT,
ORDERLINE_WAREHOUSE_ID CHAR(10) NOT NULL WITH DEFAULT,
ORDERLINE_CATEGORY SMALLINT NOT NULL WITH DEFAULT,
ORDERLINE_BARCODE1 DOUBLE,
ORDERLINE_BARCODE2 REAL,
ORDERLINE_BARCODE3 DOUBLE NOT NULL WITH DEFAULT,
ORDERLINE_BARCODE4 REAL NOT NULL WITH DEFAULT,
ORDERLINE_HASH_ENTRY1 CHAR(50) FOR BIT DATA NOT NULL
WITH DEFAULT X'C1',
ORDERLINE_HASH_ENTRY2 CHAR(50) FOR BIT DATA,
ORDERLINE_UPC01 VARCHAR(100) FOR BIT DATA,
ORDERLINE_UPC02 VARCHAR(100) FOR BIT DATA NOT NULL
DEFAULT '<>' ,
ORDERLINE_REMARKS VARCHAR(255) DEFAULT NULL,
ORDERLINE_ITEM_ID CHAR(6) NOT NULL WITH DEFAULT,
ORDERLINE_SUPPLY_WAREHOUSE_ID CHAR(10) NOT NULL WITH DEFAULT,
ORDERLINE_DELIVERY_DATE TIMESTAMP,
ORDERLINE_QUANTITY INTEGER NOT NULL WITH DEFAULT,
ORDERLINE_AMOUNT US_DOLLAR NOT NULL WITH DEFAULT,
ORDERLINE_DISTRICT_INFO CHAR(24) NOT NULL WITH DEFAULT,
ORDERLINE_CREATE_DECFLOAT1 DECFLOAT(16) NOT NULL WITH DEFAULT,
ORDERLINE_CREATE_VARBINARY1 VARBINARY(500) NOT NULL WITH DEFAULT,
ORDERLINE_CREATE_BIGINT1 BIGINT NOT NULL WITH DEFAULT,
ORDERLINE_CREATE_BINARY1 BINARY(30) NOT NULL WITH DEFAULT,
SYS_START TIMESTAMP(12) NOT NULL WITH DEFAULT ,
SYS_END TIMESTAMP(12) NOT NULL WITH DEFAULT ,
TRANS_ID TIMESTAMP(12) ,
BUS_START TIMESTAMP(6) NOT NULL ,
BUS_END TIMESTAMP(6) NOT NULL ,
CONSTRAINT PK#TB_ORDERLINE_DISTRICT_ID#ORDER_ID#CATEGORY
PRIMARY KEY (ORDERLINE_WAREHOUSE_ID,
ORDERLINE_DISTRICT_ID,
ORDERLINE_ORDER_ID,
ORDERLINE_CATEGORY),
CONSTRAINT FK#TB_ORDER#WAREHOUSE_ID#DISTRICT_ID#ORDER_ID#CASCADE
FOREIGN KEY (ORDERLINE_WAREHOUSE_ID,
ORDERLINE_DISTRICT_ID,
ORDERLINE_ORDER_ID)
REFERENCES SC516801.TB_ORDER_PBR
(ORDER_WAREHOUSE_ID,
ORDER_DISTRICT_ID,
ORDER_ID)
ON DELETE CASCADE,
CONSTRAINT FK#TB_STOCK_WAREHOUSE_ID#STOCK_ITEM_ID#CASCADE
FOREIGN KEY (ORDERLINE_SUPPLY_WAREHOUSE_ID,
ORDERLINE_ITEM_ID)
REFERENCES SC516801.TB_STOCK_PART
(STOCK_WAREHOUSE_ID,
STOCK_ITEM_ID)
ON DELETE CASCADE)
IN DB516807.TG516807
APPEND YES;
...
ALTER TABLE SC516801.TB_ORDERLINE_PBG
ENABLE ARCHIVE USE SC516801.TB_ORDERLINE_PBR_ARCH;
The following utility control statement specifies that REPORT is to list all objects that are related to table space TS516801, which contains tables TB_DISTRICT_SEG and TB_WAREHOUSE_SEG.
REPORT TABLESPACESET TABLESPACE DB516801.TS516801
The resulting output lists referentially related objects, related LOB and XML tables, and related history and archive tables:
TABLESPACE SET REPORT:
TABLESPACE : DB516801.TS516801
TABLE : SC516801.TB_DISTRICT_SEG
INDEXSPACE : DB516801.IU01RDIS
INDEX : SC516801.IU01_DISTRICT_SEG
INDEXSPACE : DB516801.IX01RDIS
INDEX : SC516801.IX01_DISTRICT_SEG
INDEXSPACE : DB516801.IX02RDIS
INDEX : SC516801.IX02_DISTRICT_SEG
DEP TABLE : SC516801.TB_ORDER_PBR
TABLE : SC516801.TB_WAREHOUSE_SEG
INDEXSPACE : DB516801.IU01RWAR
INDEX : SC516801.IU01_WAREHOUSE_SEG
INDEXSPACE : DB516801.IRDOCIDT
INDEX : SC516801.I_DOCIDTB_WAREHOUSE_SEG
INDEXSPACE : DB516801.IX01RWAR
INDEX : SC516801.IX01_WAREHOUSE_SEG
INDEXSPACE : DB516801.IX02RWAR
INDEX : SC516801.IX02_WAREHOUSE_SEG
INDEXSPACE : DB516801.IX03RWAR
INDEX : SC516801.IX03_WAREHOUSE_SEG
INDEXSPACE : DB516801.IX04RWAR
INDEX : SC516801.IX04_WAREHOUSE_SEG
DEP TABLE : SC516801.TB_DISTRICT_SEG
SC516801.TB_STOCK_PART
TABLESPACE : DB516803.TP516805
TABLE : SC516801.TB_STOCK_PART
INDEXSPACE : DB516803.IX01RSTO
INDEX : SC516801.IX01_STOCK_PART
INDEXSPACE : DB516803.IU01RSTO
INDEX : SC516801.IU01_STOCK_PART
INDEXSPACE : DB516803.IX02RSTO
INDEX : SC516801.IX02_STOCK_PART
DEP TABLE : SC516801.TB_ORDERLINE_PBG
TABLESPACE : DB516803.TU516803
TABLE : SC516801.TB_ORDER_PBR
INDEXSPACE : DB516803.IU01RORD
INDEX : SC516801.IU01_ORDER_PBR
INDEXSPACE : DB516803.IRDOCIDT
INDEX : SC516801.I_DOCIDTB_ORDER_PBR
INDEXSPACE : DB516803.IU02RORD
INDEX : SC516801.IU02_ORDER_PBR
INDEXSPACE : DB516803.IU03RORD
INDEX : SC516801.IU03_ORDER_PBR
INDEXSPACE : DB516803.IU04RORD
INDEX : SC516801.IU04_ORDER_PBR
INDEXSPACE : DB516803.IX01RORD
INDEX : SC516801.IX01_ORDER_PBR
INDEXSPACE : DB516803.IX02RORD
INDEX : SC516801.IX02_ORDER_PBR
INDEXSPACE : DB516803.IU05RORD
INDEX : SC516801.IU05_ORDER_PBR
DEP TABLE : SC516801.TB_ORDERLINE_PBG
TABLESPACE : DB516807.TG516807
TABLE : SC516801.TB_ORDERLINE_PBG
INDEXSPACE : DB516807.IU01RORD
INDEX : SC516801.IU01_ORDERLINE_PBG
INDEXSPACE : DB516807.IRDOCIDT
INDEX : SC516801.I_DOCIDTB_ORDERLINE_PBG
INDEXSPACE : DB516807.IX01RORD
INDEX : SC516801.IX01_ORDERLINE_PBG
INDEXSPACE : DB516807.IX02RORD
INDEX : SC516801.IX02_ORDERLINE_PBG
LOB TABLESPACE SET REPORT:
TABLESPACE : DB516801.TS516801
BASE TABLE : SC516801.TB_DISTRICT_SEG
COLUMN : DISTRICT_CREATE_CLOB1
LOB TABLESPACE : DB516801.TA516801
AUX TABLE : SC516801.TX01_CLOB1_DISTRICT_SEG
AUX INDEXSPACE : DB516801.IARCLOB1
AUX INDEX : SC516801.IA_CLOB1_DISTRICT_SEG
TABLESPACE : DB516803.TU516803
BASE TABLE : SC516801.TB_ORDER_PBR
PART: 0001 COLUMN : ORDER_CREATE_CLOB1
LOB TABLESPACE : DB516803.TA516831
AUX TABLE : SC516801.TX31_CLOB_ORDER_PBR
AUX INDEXSPACE : DB516803.IA31RCLO
AUX INDEX : SC516801.IA31_CLOB_ORDER_PBR
PART: 0002 COLUMN : ORDER_CREATE_CLOB1
LOB TABLESPACE : DB516803.TA516832
AUX TABLE : SC516801.TX32_CLOB_ORDER_PBR
AUX INDEXSPACE : DB516803.IA32RCLO
AUX INDEX : SC516801.IA32_CLOB_ORDER_PBR
PART: 0003 COLUMN : ORDER_CREATE_CLOB1
LOB TABLESPACE : DB516803.TA516833
AUX TABLE : SC516801.TX33_CLOB_ORDER_PBR
AUX INDEXSPACE : DB516803.IA33RCLO
AUX INDEX : SC516801.IA33_CLOB_ORDER_PBR
PART: 0001 COLUMN : ORDER_CREATE_BLOB1
LOB TABLESPACE : DB516803.TA516834
AUX TABLE : SC516801.TX31_BLOB_ORDER_PBR
AUX INDEXSPACE : DB516803.IA31RBLO
AUX INDEX : SC516801.IA31_BLOB_ORDER_PBR
PART: 0002 COLUMN : ORDER_CREATE_BLOB1
LOB TABLESPACE : DB516803.TA516835
AUX TABLE : SC516801.TX32_BLOB_ORDER_PBR
AUX INDEXSPACE : DB516803.IA32RBLO
AUX INDEX : SC516801.IA32_BLOB_ORDER_PBR
PART: 0003 COLUMN : ORDER_CREATE_BLOB1
LOB TABLESPACE : DB516803.TA516836
AUX TABLE : SC516801.TX33_BLOB_ORDER_PBR
AUX INDEXSPACE : DB516803.IA33RBLO
AUX INDEX : SC516801.IA33_BLOB_ORDER_PBR
TABLESPACE : DB516807.TG516807
BASE TABLE : SC516801.TB_ORDERLINE_PBG
PART: 0001 COLUMN : ORDERLINE_CREATE_LOB
LOB TABLESPACE : DB516807.TA516871
AUX TABLE : SC516801.TX71_CLOB1_ORDERLINE_PBG
AUX INDEXSPACE : DB516807.IA71RCLO
AUX INDEX : SC516801.IA71_CLOB1_ORDERLINE_PBG
XML TABLESPACE SET REPORT:
TABLESPACE : DB516801.TS516801
BASE TABLE : SC516801.TB_WAREHOUSE_SEG
COLUMN : WAREHOUSE_CREATE_XML1
XML TABLESPACE : DB516801.XTBR0000
XML TABLE : SC516801.XTB_WAREHOUSE_SEG
XML NODEID INDEXSPACE: DB516801.IRNODEID
XML NODEID INDEX : SC516801.I_NODEIDXTB_WAREHOUSE_SEG
TABLESPACE : DB516803.TU516803
BASE TABLE : SC516801.TB_ORDER_PBR
COLUMN : ORDER_CREATE_XML
XML TABLESPACE : DB516803.XTBR0000
XML TABLE : SC516801.XTB_ORDER_PBR
XML NODEID INDEXSPACE: DB516803.IRNODEID
XML NODEID INDEX : SC516801.I_NODEIDXTB_ORDER_PBR
TABLESPACE : DB516807.TG516807
BASE TABLE : SC516801.TB_ORDERLINE_PBG
COLUMN : ORDERLINE_CREATE_XML1
XML TABLESPACE : DB516807.XTBR0000
XML TABLE : SC516801.XTB_ORDERLINE_PBG
XML NODEID INDEXSPACE: DB516807.IRNODEID
XML NODEID INDEX : SC516801.I_NODEIDXTB_ORDERLINE_PBG
HISTORY TABLESPACE SET REPORT:
TABLESPACE : DB516804.TS516804
HISTORY TABLE : SC516801.TB_ORDER_SEG_HIST
TEMPORAL TABLE : SC516801.TB_ORDER_PBR
INDEXSPACE : DB516804.IU01RORD
INDEX : SC516801.IU01_ORDER_SEG_HIST
INDEXSPACE : DB516804.IRDOCIDT
INDEX : SC516801.I_DOCIDTB_ORDER_SEG_HIST
INDEXSPACE : DB516804.IU02RORD
INDEX : SC516801.IU02_ORDER_SEG_HIST
INDEXSPACE : DB516804.IU03RORD
INDEX : SC516801.IU03_ORDER_SEG_HIST
INDEXSPACE : DB516804.IU04RORD
INDEX : SC516801.IU04_ORDER_SEG_HIST
INDEXSPACE : DB516804.IX01RORD
INDEX : SC516801.IX01_ORDER_SEG_HIST
INDEXSPACE : DB516804.IX02RORD
INDEX : SC516801.IX02_ORDER_SEG_HIST
INDEXSPACE : DB516804.IU05RORD
INDEX : SC516801.IU05_ORDER_SEG_HIST
HISTORY LOB TABLESPACE SET REPORT:
TABLESPACE : DB516804.TS516804
BASE TABLE : SC516801.TB_ORDER_SEG_HIST
COLUMN : ORDER_CREATE_CLOB1
LOB TABLESPACE : DB516804.TA516841
AUX TABLE : SC516801.TX41_CLOB_ORDER_SEG_HIST
AUX INDEXSPACE : DB516804.IA41RCLO
AUX INDEX : SC516801.IA41_CLOB_ORDER_SEG_HIST
COLUMN : ORDER_CREATE_BLOB1
LOB TABLESPACE : DB516804.TA516842
AUX TABLE : SC516801.TX42_BLOB_ORDER_SEG_HIST
AUX INDEXSPACE : DB516804.IA42RBLO
AUX INDEX : SC516801.IA42_BLOB_ORDER_SEG_HIST
HISTORY XML TABLESPACE SET REPORT:
TABLESPACE : DB516804.TS516804
BASE TABLE : SC516801.TB_ORDER_SEG_HIST
COLUMN : ORDER_CREATE_XML
XML TABLESPACE : DB516804.XTBR0000
XML TABLE : SC516801.XTB_ORDER_SEG_HIST
XML NODEID INDEXSPACE: DB516804.IRNODEID
XML NODEID INDEX : SC516801.I_NODEIDXTB_ORDER_SEG_HIST
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
ARCHIVE LOB TABLESPACE SET REPORT:
TABLESPACE : DB516807.TU516808
BASE TABLE : SC516801.TB_ORDERLINE_PBR_ARCH
PART: 0001 COLUMN : ORDERLINE_CREATE_LOB
LOB TABLESPACE : DB516807.TA516881
AUX TABLE : SC516801.TX81_CLOB1_ORDERLINE_PBR_ARCH
AUX INDEXSPACE : DB516807.IA81RCLO
AUX INDEX : SC516801.IA81_CLOB1_ORDERLINE_PBR_ARCH
PART: 0002 COLUMN : ORDERLINE_CREATE_LOB
LOB TABLESPACE : DB516807.TA516882
AUX TABLE : SC516801.TX82_CLOB1_ORDERLINE_PBR_ARCH
AUX INDEXSPACE : DB516807.IA82RCLO
AUX INDEX : SC516801.IA82_CLOB1_ORDERLINE_PBR_ARCH
PART: 0003 COLUMN : ORDERLINE_CREATE_LOB
LOB TABLESPACE : DB516807.TA516883
AUX TABLE : SC516801.TX83_CLOB1_ORDERLINE_PBR_ARCH
AUX INDEXSPACE : DB516807.IA83RCLO
AUX INDEX : SC516801.IA83_CLOB1_ORDERLINE_PBR_ARCH
ARCHIVE XML TABLESPACE SET REPORT:
TABLESPACE : DB516807.TU516808
BASE TABLE : SC516801.TB_ORDERLINE_PBR_ARCH
COLUMN : ORDERLINE_CREATE_XML1
XML TABLESPACE : DB516807.XTBR0001
XML TABLE : SC516801.XTB_ORDERLINE_PBR_A
XML NODEID INDEXSPACE: DB516807.IRNO1LJL
XML NODEID INDEX : SC516801.I_NODEIDXTB_ORDERLINE_PBR_
FL 502 Example 8: Reporting key label information for a table space
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 SET REPORT:
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