报表控制语句示例
使用示例控制语句作为模板，开发您自己的报告控制语句。
示例1：报告表空间恢复信息
以下控制语句指定 REPORT 实用程序为表空间 DSN8D81A.DSN8S81E 提供恢复信息。
//REPORT EXEC DSNUPROC,SYSTEM=V91A,UID='REP97'
//SYSIN DD *
REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E
/* 前面的语句会产生类似于以下输出的结果：
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
示例2：使用LOB列报告表空间的信息
以下控制语句指定 REPORT 应提供与 TABLESPACE DSN8D91L.DSN8S91B 相关的所有表空间列表，其中包含一个包含三个 LOB 列的表。 输出结果中包含一个单独的部分，名为LOB TABLESPACE SET REPORT，显示相关LOB表空间及其表、索引和索引空间的列表。 此外，还显示了每个LOB对象所关联的基表和基列。
REPORT TABLESPACESET TABLESPACE DSN8D91L.DSN8S91B前面的语句会产生类似于以下输出的结果：
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
示例3：报告分区表空间分区的恢复信息
以下控制语句指定REPORT为表空间 DSN8D91A.DSN8S91E 的第4分区提供恢复信息。 分区号由DSNUM选项指定。
REPORT RECOVERY TABLESPACE DSN8D91A.DSN8S91E DSNUM 4前面的语句会产生类似于以下输出的结果：
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 示例4：报告索引的恢复信息
以下 REPORT 语句指定该实用程序为索引 DSN8810.XDEPT1 提供恢复信息。
//REP101 EXEC DSNUPROC,SYSTEM=V91A,UID='REP101'
//SYSIN DD *
REPORT RECOVERY INDEX DSN8910.XDEPT1
/* 前面的语句会产生类似于以下输出的结果：
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示例5：使用XML列报告表格空间设置信息
以下实用程序控制语句指定 REPORT 列出与基础表空间相关的所有对象。
REPORT TABLESPACESET TABLESPACE DBKQAN01.TPKQAN01在这个示例中，基础表包含两个XML列。 以下输出为 REPORT 语句，列出了为存储这些 XML 列的数据而隐式创建的对象。
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 示例 6：报告系统周期时间表空间的版本关系
以下实用程序控制语句指定 REPORT 列出与基础表空间相关的所有对象。
REPORT TABLESPACESET TABLESPACE DBSOL11.TS001L11以下报告显示了版本关系中涉及的物件。 该报告还包含系统周期临时表空间和历史表空间上的相关辅助 LOB 和 XML 表空间。
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示例7：报告相关档案表
本例使用以下表格：
- TB_仓库_分区
- 申请期间的时间表。
- TB_DISTRICT_SEG
- 一个常规表，其参照约束取决于表TB_WAREHOUSE_SEG。
- TB_库存零件
- 一个启用存档功能的表，其参照约束取决于表TB_WAREHOUSE_SEG。
- TB_订单_PBR
- 系统周期临时表，其参照约束取决于表TB_DISTRICT_SEG。
- TB_订单行_预留字段
- 一个启用存档的表，其参照约束取决于TB_STOCK_PART和TB_ORDER_PBR表。
这些表格是通过以下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;以下实用程序控制语句指定 REPORT 列出与表空间 TS516801 相关的所有对象，该表空间包含 TB_DISTRICT_SEG 和 TB_WAREHOUSE_SEG 两个表。
REPORT TABLESPACESET TABLESPACE DB516801.TS516801
生成的输出列表包含相关对象、相关LOB和XML表以及相关历史和存档表：
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 示例8：报告表空间的关键标签信息
以下报告语句指定了该实用程序为表空间 DBF07307.TAF07382 提供关键标签信息。
REPORT TABLESPACESET TABLESPACE DBF07303.TAF07305 SHOWDSNS
SHOWKEYLABEL以下示例显示了报告输出：
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