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 TESTDB.TESTTS.
//UTIL EXEC DSNUPROC,SYSTEM=SSTR,UID='REP3',UTPROC=''
//DSNUPROC.SYSIN DD *
REPORT RECOVERY TABLESPACE TESTDB.TESTTS
/* FL 501The preceding statement produces output similar to the following output:
DDSNU000I 027 11:27:25.47 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = REP3
DSNU1044I 027 11:27:25.48 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I 027 11:27:25.48 DSNUGUTC - REPORT RECOVERY TABLESPACE TESTDB.TESTTS
DSNU3031I -DB2A 027 11:27:25.49 DSNUHUTL - UTILITY HISTORY COLLECTION IS ACTIVE.
LEVEL: UTILITY, EVENTID: 1112
DSNU581I -DB2A 027 11:27:25.49 DSNUPREC - REPORT RECOVERY TABLESPACE TESTDB.TESTTS
DSNU593I -DB2A 027 11:27:25.49 DSNUPREC - REPORT RECOVERY ENVIRONMENT RECORD:
MINIMUM RBA: 00000000000000000000
MAXIMUM RBA: FFFFFFFFFFFFFFFFFFFF
MIGRATING RBA: 00000000000069957FFF
DSNU582I -DB2A 027 11:27:25.49 DSNUPPCP - REPORT RECOVERY TABLESPACE TESTDB.TESTTS SYSCOPY ROWS
AND SYSTEM LEVEL BACKUPS
TIMESTAMP = 2022-01-27-11.26.39.513172, IC TYPE = *C*, SHR LVL = , DSNUM = 0000, STARTLRSN=000000000001F2AF3851
DEV TYPE = , IC BACK = , STYPE = L, FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE = E
JOBNAME = , AUTHID = , COPYPAGESF = -1.0E+00 , EVENT ID =
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTTS , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-01-27-11.26.42.561062, IC TYPE = *R*, SHR LVL = , DSNUM = 0000, STARTLRSN=000000000001F2B2F0BC
DEV TYPE = , IC BACK = , STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0001, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE =
JOBNAME = T1611003, AUTHID = SYSADM , COPYPAGESF = -1.0E+00 , EVENT ID = 1101
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTTS , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-01-27-11.26.45.822113, IC TYPE = F , SHR LVL = R, DSNUM = 0000, STARTLRSN=000000000001F2C1720E
DEV TYPE = 3390 , IC BACK = LB, STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0001, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE =
JOBNAME = T1611007, AUTHID = SYSADM , COPYPAGESF = 3.6E+01 , EVENT ID = 1105
NPAGESF = 9.8E+01 , CPAGESF = 3.5E+01 , MODE CREATED =
DSNAME = SYSADM.FIC.TESTDB.TESTTS.P00000.IGJJP0AH , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-01-27-11.26.45.822113, IC TYPE = F , SHR LVL = R, DSNUM = 0000, STARTLRSN=000000000001F2C1720E
DEV TYPE = 3390 , IC BACK = , STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0001, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE =
JOBNAME = T1611005, AUTHID = ADMF001 , COPYPAGESF = 3.6E+01 , EVENT ID = 1103
NPAGESF = 9.8E+01 , CPAGESF = 3.5E+01 , MODE CREATED = N
DSNAME = SYSADM.FIC.TESTDB.TESTTS.P00000.IGJJPX1D , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-01-27-11.26.51.608982, IC TYPE = *X*, SHR LVL = , DSNUM = 0000, STARTLRSN=000000000001F2CB121E
DEV TYPE = , IC BACK = , STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0001, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE =
JOBNAME = T1611009, AUTHID = SYSADM , COPYPAGESF = -1.0E+00 , EVENT ID = 1107
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTTS , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-01-27-11.26.51.697702, IC TYPE = F , SHR LVL = R, DSNUM = 0001, STARTLRSN=000000000001F2D5B78F
DEV TYPE = 3390 , IC BACK = , STYPE = X, FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0001, OLDEST VERSION = 0000, LOGICAL PART = 0001, LOGGED = Y, TTYPE =
JOBNAME = T1611009, AUTHID = SYSADM , COPYPAGESF = 7.4E+01 , EVENT ID = 1107
NPAGESF = 9.8E+01 , CPAGESF = 9.8E+01 , MODE CREATED = N
DSNAME = SYSADM.REO.TESTDB.TESTTS.P00001.IGJJP2BZ , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-01-27-11.27.21.424372, IC TYPE = *E*, SHR LVL = , DSNUM = 0001, STARTLRSN=000000000001F2DADE6B
DEV TYPE = , IC BACK = , STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = -1, LOGICAL PART = 0001, LOGGED = Y, TTYPE =
JOBNAME = T1611016, AUTHID = SYSADM , COPYPAGESF = -1.0E+00 , EVENT ID = 1109
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTTS , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-01-27-11.27.24.068080, IC TYPE = *Q*, SHR LVL = , DSNUM = 0000, STARTLRSN=000000000001F2DCEE35
DEV TYPE = , IC BACK = , STYPE = W, FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = -1, LOGICAL PART = 0000, LOGGED = Y, TTYPE =
JOBNAME = T1611018, AUTHID = SYSADM , COPYPAGESF = -1.0E+00 , EVENT ID = 1111
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTTS , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
DSNU586I -DB2A 027 11:27:25.49 DSNUPSUM - REPORT RECOVERY TABLESPACE TESTDB.TESTTS SUMMARY
DSNU588I -DB2A 027 11:27:25.49 DSNUPSUM - NO DATA TO BE REPORTED
DSNU583I -DB2A 027 11:27:25.49 DSNUPPLR - SYSLGRNX ROWS FROM REPORT RECOVERY FOR TABLESPACE TESTDB.TESTTS
UCDATE UCTIME START RBA STOP RBA START LRSN STOP LRSN PART MEMBER ID
012722 11263962 000000000001F2AF5513 000000000001F2AF72AA 00DAFA594E3524000000 00DAFA594E3602000000 0001 0000
012722 11263969 000000000001F2AFC6D9 000000000001F2B08E84 00DAFA594E4470000000 00DAFA5950F7E9000000 0001 0000
012722 11264271 000000000001F2B3E31F 000000000001F2B65788 00DAFA59512660000000 00DAFA59512DBA000000 0001 0000
012722 11264290 000000000001F2B6B889 000000000001F2BBD5C8 00DAFA595155D1000000 00DAFA595167D1000000 0001 0000
012722 11265136 000000000001F2CC540D 000000000001F2CEC8DF 00DAFA59596748000000 00DAFA59596EEB000000 0001 0000
012722 11265155 000000000001F2CEE851 000000000001F2D45563 00DAFA59599548000000 00DAFA5959A486000000 0001 0000
012722 11265169 000000000001F2D5AB65 000000000001F2D5B25A 00DAFA5959B640000000 00DAFA5959B781000000 0001 0000
012722 11272135 000000000001F2D9FAB0 000000000001F2D9FAB0 00DAFA5976006C000000 00DAFA59760180000000 0001 0000 *
012722 11272142 000000000001F2DAD6E6 000000000001F2DAD6E6 00DAFA5976109A000000 00DAFA59761100000000 0001 0000 *
DSNU584I -DB2A 027 11:27:25.49 DSNUPPBS - REPORT RECOVERY TABLESPACE TESTDB.TESTTS ARCHLOG1 BSDS VOLUMES
DSNU588I -DB2A 027 11:27:25.49 DSNUPPBS - NO DATA TO BE REPORTED
DSNU586I -DB2A 027 11:27:25.49 DSNUPSUM - REPORT RECOVERY TABLESPACE TESTDB.TESTTS SUMMARY
DSNU588I -DB2A 027 11:27:25.49 DSNUPSUM - NO DATA TO BE REPORTED
DSNU589I -DB2A 027 11:27:25.49 DSNUPREC - REPORT RECOVERY TABLESPACE TESTDB.TESTTS COMPLETE
DSNU598I -DB2A 027 11:27:25.49 DSNUPPBK - REPORT RECOVERY SYSTEM LEVEL BACKUPS
DSNU588I -DB2A 027 11:27:25.49 DSNUPPBK - NO DATA TO BE REPORTED
DSNU580I 027 11:27:25.49 DSNUPORT - REPORT UTILITY COMPLETE - ELAPSED TIME=00:00:00
DSNU010I 027 11:27:25.50 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0 If system-level backup information is available, the output also includes that information as shown in the following example:
DSNU598I -DB2A 009 14:45:44.51 DSNUPPBK - REPORT RECOVERY SYSTEM LEVEL BACKUPS
START STCK DATA COMPLETE DATA/LOG COMPLETE
DATA LOG RBLP LRSN DATE LTIME LOCATION NAME
---------------- ---------------- -------------------- -------------------- --------------------- ----------------
DAE3E1728D30A816 DAE3E1732EF845C0 000000000002114D632A 000000000002115B1CA4 2022-01-09 14.33.17 STLEC1
TOKEN = C4C2F2C1DAE3E1728D30A816000000000002114D632A INCREMENTAL = N, SUBSYSTEM ID = DB2A, MEMBER NAME =
2.04, CAPTURE CATALOG INFO = Y, LOG COPY POOL = Y
EVENT ID = 1073 
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 DSN8D13L.DSN8S13B, 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 DSN8D13L.DSN8S13BThe 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 DSN8D13L.DSN8S13B
DSNU587I ) 277 11:19:09.62 DSNUPSET - REPORT TABLESPACE SET WITH TABLESPACE DSN8D13L.DSN8S13B
TABLESPACE SET REPORT:
TABLESPACE : DSN8D13L.DSN8S13B
TABLE : DSN8D10.EMP_PHOTO_RESUME
INDEXSPACE : DSN8D13L.XEMPRPHO
INDEX : DSN8D10.XEMP_PHOTO_RESUME
LOB TABLESPACE SET REPORT:
TABLESPACE : DSN8D13L.DSN8S13B
BASE TABLE : DSN8D10.EMP_PHOTO_RESUME
COLUMN : PSEG_PHOTO
LOB TABLESPACE : DSN8D13L.DSN8S13L
AUX TABLE : DSN8D10.AUX_PSEG_PHOTO
AUX INDEXSPACE : DSN8D13L.XAUXRPSE
AUX INDEX : DSN8D10.XAUX_PSEG_PHOTO
COLUMN : BMP_PHOTO
LOB TABLESPACE : DSN8D13L.DSN8S13M
AUX TABLE : DSN8D10.AUX_BMP_PHOTO
AUX INDEXSPACE : DSN8D13L.XAUXRBMP
AUX INDEX : DSN8D10.XAUX_BMP_PHOTO
COLUMN : RESUME
LOB TABLESPACE : DSN8D13L.DSN8S13N
AUX TABLE : DSN8D10.AUX_EMP_RESUME
AUX INDEXSPACE : DSN8D13L.XAUXREMP
AUX INDEX : DSN8D10.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 TESTDB.TESTTS. The partition number is indicated by the DSNUM option.
REPORT RECOVERY TABLESPACE TESTDB.TESTTS DSNUM 4FL 501The preceding statement produces output similar to the following output:
DDSNU000I 042 08:42:15.47 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = REP3
DSNU1044I 042 08:42:15.47 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I 042 08:42:15.47 DSNUGUTC - DIAGNOSE TYPE(111)
DSNU050I 042 08:42:15.48 DSNUGUTC - REPORT RECOVERY TABLESPACE TESTDB.TESTTS DSNUM 4
DSNU3031I -DB2A 042 08:42:15.48 DSNUHUTL - UTILITY HISTORY COLLECTION IS ACTIVE.
LEVEL: UTILITY, EVENTID: 1011
DSNU581I -DB2A 042 08:42:15.48 DSNUPREC - REPORT RECOVERY TABLESPACE TESTDB.TESTTS
DSNU593I -DB2A 042 08:42:15.48 DSNUPREC - REPORT RECOVERY ENVIRONMENT RECORD:
MINIMUM RBA: 00000000000000000000
MAXIMUM RBA: FFFFFFFFFFFFFFFFFFFF
MIGRATING RBA: 00000000000069957FFF
DSNU582I -DB2A 042 08:42:15.48 DSNUPPCP - REPORT RECOVERY TABLESPACE TESTDB.TESTTS SYSCOPY ROWS
AND SYSTEM LEVEL BACKUPS
TIMESTAMP = 2022-02-11-08.37.44.098718, IC TYPE = *C*, SHR LVL = , DSNUM = 0000, STARTLRSN=000000000001F696C31A
DEV TYPE = , IC BACK = , STYPE = L, FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE = E
JOBNAME = , AUTHID = , COPYPAGESF = -1.0E+00 , EVENT ID =
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTTS , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-02-11-08.37.49.020425, IC TYPE = *R*, SHR LVL = , DSNUM = 0004, STARTLRSN=000000000001F6C04F7F
DEV TYPE = , IC BACK = , STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0001, OLDEST VERSION = 0000, LOGICAL PART = 0004, LOGGED = Y, TTYPE =
JOBNAME = T1J11003, AUTHID = SYSADM , COPYPAGESF = -1.0E+00 , EVENT ID = 1001
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTTS , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-02-11-08.37.53.621418, IC TYPE = F , SHR LVL = R, DSNUM = 0000, STARTLRSN=000000000001F6D0F4A3
DEV TYPE = 3390 , IC BACK = , STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0001, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE =
JOBNAME = T1J11005, AUTHID = ADMF001 , COPYPAGESF = 3.6E+01 , EVENT ID = 1003
NPAGESF = 9.8E+01 , CPAGESF = 3.5E+01 , MODE CREATED = N
DSNAME = SYSADM.FIC.TESTDB.TESTTS.P00000.IG7GI3ZC , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-02-11-08.37.53.621418, IC TYPE = F , SHR LVL = R, DSNUM = 0000, STARTLRSN=000000000001F6D0F4A3
DEV TYPE = 3390 , IC BACK = LB, STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0001, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE =
JOBNAME = T1J11007, AUTHID = SYSADM , COPYPAGESF = 3.6E+01 , EVENT ID = 1005
NPAGESF = 9.8E+01 , CPAGESF = 3.5E+01 , MODE CREATED =
DSNAME = SYSADM.FIC.TESTDB.TESTTS.P00000.IG7GI6IK , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-02-11-08.38.00.301523, IC TYPE = *X*, SHR LVL = , DSNUM = 0000, STARTLRSN=000000000001F6DB62E6
DEV TYPE = , IC BACK = , STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0001, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE =
JOBNAME = T1J11009, AUTHID = SYSADM , COPYPAGESF = -1.0E+00 , EVENT ID = 1007
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTTS , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-02-11-08.38.00.405923, IC TYPE = F , SHR LVL = R, DSNUM = 0004, STARTLRSN=000000000001F6E5FC7D
DEV TYPE = 3390 , IC BACK = , STYPE = X, FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0001, OLDEST VERSION = 0000, LOGICAL PART = 0004, LOGGED = Y, TTYPE =
JOBNAME = T1J11009, AUTHID = SYSADM , COPYPAGESF = 7.4E+01 , EVENT ID = 1007
NPAGESF = 9.8E+01 , CPAGESF = 9.8E+01 , MODE CREATED = N
DSNAME = SYSADM.REO.TESTDB.TESTTS.P00001.IG7GI8VF , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
DSNU586I -DB2A 042 08:42:15.49 DSNUPSUM - REPORT RECOVERY TABLESPACE TESTDB.TESTTS SUMMARY
DSNU588I -DB2A 042 08:42:15.49 DSNUPSUM - NO DATA TO BE REPORTED
DSNU583I -DB2A 042 08:42:15.49 DSNUPPLR - SYSLGRNX ROWS FROM REPORT RECOVERY FOR TABLESPACE TESTDB.TESTTS
UCDATE UCTIME START RBA STOP RBA START LRSN STOP LRSN PART MEMBER ID
021122 08374441 000000000001F696E66D 000000000001F6970210 00DB0D0F866D84000000 00DB0D0F866EE3000000 0001 0000
021122 08374450 000000000001F697A435 000000000001F6989012 00DB0D0F868272000000 00DB0D0F8AC6A4000000 0001 0000
021122 08374921 000000000001F6C14938 000000000001F6C39184 00DB0D0F8B01CD000000 00DB0D0F8B0C9E000000 0001 0000
021122 08374948 000000000001F6C3F7A5 000000000001F6C8DB5E 00DB0D0F8B43E7000000 00DB0D0F8B5821000000 0001 0000
021122 08380003 000000000001F6DCB501 000000000001F6DEFD32 00DB0D0F95522F000000 00DB0D0F9559CD000000 0001 0000
021122 08380023 000000000001F6DF1D8F 000000000001F6E48A15 00DB0D0F95840D000000 00DB0D0F9598F6000000 0001 0000
021122 08380040 000000000001F6E5F2FF 000000000001F6E5F815 00DB0D0F95AC6F000000 00DB0D0F95AD9A000000 0001 0000
DSNU584I -DB2A 042 08:42:15.49 DSNUPPBS - REPORT RECOVERY TABLESPACE TESTDB.TESTTS ARCHLOG1 BSDS VOLUMES
DSNU588I -DB2A 042 08:42:15.49 DSNUPPBS - NO DATA TO BE REPORTED
DSNU586I -DB2A 042 08:42:15.49 DSNUPSUM - REPORT RECOVERY TABLESPACE TESTDB.TESTTS SUMMARY
DSNU588I -DB2A 042 08:42:15.49 DSNUPSUM - NO DATA TO BE REPORTED
DSNU589I -DB2A 042 08:42:15.49 DSNUPREC - REPORT RECOVERY TABLESPACE TESTDB.TESTTS COMPLETE
DSNU598I -DB2A 042 08:42:15.49 DSNUPPBK - REPORT RECOVERY SYSTEM LEVEL BACKUPS
DSNU588I -DB2A 042 08:42:15.49 DSNUPPBK - NO DATA TO BE REPORTED
DSNU580I 042 08:42:15.49 DSNUPORT - REPORT UTILITY COMPLETE - ELAPSED TIME=00:00:00
DSNU050I 042 08:42:15.49 DSNUGUTC - REPORT RECOVERY INDEX TESTDB.TESTIX
DSNU3031I -DB2A 042 08:42:15.49 DSNUHUTL - UTILITY HISTORY COLLECTION IS ACTIVE.
LEVEL: UTILITY, EVENTID: 1012
DSNU581I -DB2A 042 08:42:15.49 DSNUPREC - REPORT RECOVERY INDEX TESTDB.TESTIX
DSNU593I -DB2A 042 08:42:15.49 DSNUPREC - REPORT RECOVERY ENVIRONMENT RECORD:
MINIMUM RBA: 00000000000000000000
MAXIMUM RBA: FFFFFFFFFFFFFFFFFFFF
MIGRATING RBA: 00000000000069957FFF
DSNU582I -DB2A 042 08:42:15.49 DSNUPPCP - REPORT RECOVERY INDEX TESTDB.TESTIX SYSCOPY ROWS
AND SYSTEM LEVEL BACKUPS
TIMESTAMP = 2022-02-11-08.37.44.688323, IC TYPE = *C*, SHR LVL = , DSNUM = 0000, STARTLRSN=000000000001F6980A44
DEV TYPE = , IC BACK = , STYPE = L, FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE = E
JOBNAME = , AUTHID = , COPYPAGESF = -1.0E+00 , EVENT ID =
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTIX , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-02-11-08.37.53.674917, IC TYPE = (F), SHR LVL = R, DSNUM = 0000, STARTLRSN=000000000001F6D0F4A3
DEV TYPE = 3390 , IC BACK = , STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0000, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE = S
JOBNAME = T1J11005, AUTHID = ADMF001 , COPYPAGESF = 6.0E+00 , EVENT ID = 1003
NPAGESF = 5.0E+00 , CPAGESF = 0.0E0 , MODE CREATED = N
DSNAME = SYSADM.FIC.TESTDB.TESTIX.P00000.IG7GI31O , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-02-11-08.38.00.666902, IC TYPE = *W*, SHR LVL = , DSNUM = 0000, STARTLRSN=000000000001F6DB62E6
DEV TYPE = , IC BACK = , STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE =
JOBNAME = T1J11009, AUTHID = SYSADM , COPYPAGESF = -1.0E+00 , EVENT ID = 1008
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTIX , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
DSNU586I -DB2A 042 08:42:15.49 DSNUPSUM - REPORT RECOVERY INDEX TESTDB.TESTIX SUMMARY
DSNU588I -DB2A 042 08:42:15.49 DSNUPSUM - NO DATA TO BE REPORTED
DSNU583I -DB2A 042 08:42:15.49 DSNUPPLR - SYSLGRNX ROWS FROM REPORT RECOVERY FOR INDEX TESTDB.TESTIX
UCDATE UCTIME START RBA STOP RBA START LRSN STOP LRSN PART MEMBER ID
021122 08374480 000000000001F69825F6 000000000001F6984000 00DB0D0F86CD00000000 00DB0D0F86CDBA000000 0000 0000
021122 08374492 000000000001F698892B 000000000001F6989012 00DB0D0F86EA94000000 00DB0D0F8AC734000000 0000 0000
021122 08374945 000000000001F6C3A3A4 000000000001F6C3A3A4 00DB0D0F8B3CB6000000 00DB0D0F8B3DEE000000 0000 0000
021122 08374987 000000000001F6CAD7A6 000000000001F6CAD7A6 00DB0D0F8BA186000000 00DB0D0F8BA2F0000000 0000 0000
021122 08380021 000000000001F6DF107F 000000000001F6DF107F 00DB0D0F957E83000000 00DB0D0F957FD0000000 0000 0000 *
021122 08380036 000000000001F6E5E272 000000000001F6E5E272 00DB0D0F95A3B3000000 00DB0D0F95A4D8000000 0000 0000 *
021122 08380063 000000000001F6E9123F 000000000001F6E9123F 00DB0D0F95E66E000000 00DB0D0F95E7DE000000 0000 0000 *
021122 08380067 000000000001F6E928AF 000000000001F6E928AF 00DB0D0F95EE76000000 00DB0D0F95EF7C000000 0000 0000 *
DSNU584I -DB2A 042 08:42:15.49 DSNUPPBS - REPORT RECOVERY INDEX TESTDB.TESTIX ARCHLOG1 BSDS VOLUMES
DSNU588I -DB2A 042 08:42:15.49 DSNUPPBS - NO DATA TO BE REPORTED
DSNU586I -DB2A 042 08:42:15.49 DSNUPSUM - REPORT RECOVERY INDEX TESTDB.TESTIX SUMMARY
DSNU588I -DB2A 042 08:42:15.49 DSNUPSUM - NO DATA TO BE REPORTED
DSNU589I -DB2A 042 08:42:15.49 DSNUPREC - REPORT RECOVERY INDEX TESTDB.TESTIX COMPLETE
DSNU598I -DB2A 042 08:42:15.49 DSNUPPBK - REPORT RECOVERY SYSTEM LEVEL BACKUPS
DSNU588I -DB2A 042 08:42:15.49 DSNUPPBK - NO DATA TO BE REPORTED
DSNU580I 042 08:42:15.49 DSNUPORT - REPORT UTILITY COMPLETE - ELAPSED TIME=00:00:00
DSNU860I 042 08:42:15.50 DSNUGUTC - DIAGNOSE UTILITY COMPLETE
DSNU010I 042 08:42:15.50 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 TESTDB.TESTIX.
//UTIL EXEC DSNUPROC,SYSTEM=SSTR,UID='REP3',UTPROC=''
//DSNUPROC.SYSIN DD *
REPORT RECOVERY INDEX TESTDB.TESTIX FL 501The preceding statement produces output similar to the following output:
DSNU000I 027 11:46:14.39 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = REP3
DSNU1044I 027 11:46:14.39 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I 027 11:46:14.40 DSNUGUTC - REPORT RECOVERY INDEX TESTDB.TESTIX
DSNU3031I -DB2A 027 11:46:14.41 DSNUHUTL - UTILITY HISTORY COLLECTION IS ACTIVE.
LEVEL: UTILITY, EVENTID: 1119
DSNU581I -DB2A 027 11:46:14.41 DSNUPREC - REPORT RECOVERY INDEX TESTDB.TESTIX
DSNU593I -DB2A 027 11:46:14.41 DSNUPREC - REPORT RECOVERY ENVIRONMENT RECORD:
MINIMUM RBA: 00000000000000000000
MAXIMUM RBA: FFFFFFFFFFFFFFFFFFFF
MIGRATING RBA: 00000000000069957FFF
DSNU582I -DB2A 027 11:46:14.41 DSNUPPCP - REPORT RECOVERY INDEX TESTDB.TESTIX SYSCOPY ROWS
AND SYSTEM LEVEL BACKUPS
TIMESTAMP = 2022-01-27-11.26.39.771696, IC TYPE = *C*, SHR LVL = , DSNUM = 0000, STARTLRSN=000000000001F2B005A3
DEV TYPE = , IC BACK = , STYPE = L, FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE = E
JOBNAME = , AUTHID = , COPYPAGESF = -1.0E+00 , EVENT ID =
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTIX , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-01-27-11.27.24.068080, IC TYPE = *Q*, SHR LVL = , DSNUM = 0000, STARTLRSN=000000000001F2DCEE35
DEV TYPE = , IC BACK = , STYPE = W, FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = -1, LOGICAL PART = 0000, LOGGED = Y, TTYPE =
JOBNAME = T1611018, AUTHID = SYSADM , COPYPAGESF = -1.0E+00 , EVENT ID = 1111
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTIX , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-01-27-11.42.00.615308, IC TYPE = (F), SHR LVL = R, DSNUM = 0000, STARTLRSN=000000000001F2EAE8DA
DEV TYPE = 3390 , IC BACK = , STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0000, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE = S
JOBNAME = COPY , AUTHID = ADMF001 , COPYPAGESF = 6.0E+00 , EVENT ID = 1114
NPAGESF = 5.0E+00 , CPAGESF = 0.0E0 , MODE CREATED = N
DSNAME = SYSADM.FIC.TESTDB.TESTIX.P00000.IGJKBSCV , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-01-27-11.44.07.562761, IC TYPE = *W*, SHR LVL = , DSNUM = 0000, STARTLRSN=000000000001F2EF9D23
DEV TYPE = , IC BACK = , STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE =
JOBNAME = REORG , AUTHID = SYSADM , COPYPAGESF = -1.0E+00 , EVENT ID = 1116
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTIX , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-01-27-11.45.15.089044, IC TYPE = F , SHR LVL = R, DSNUM = 0000, STARTLRSN=000000000001F30396AA
DEV TYPE = 3390 , IC BACK = , STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0001, HIGH DSNUM = 0000, OLDEST VERSION = 0000, LOGICAL PART = 0000, LOGGED = Y, TTYPE = S
JOBNAME = COPY , AUTHID = ADMF001 , COPYPAGESF = 6.0E+00 , EVENT ID = 1117
NPAGESF = 5.0E+00 , CPAGESF = 0.0E0 , MODE CREATED = N
DSNAME = SYSADM.FIC.TESTDB.TESTIX.P00000.IGJKF7DH , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
TIMESTAMP = 2022-01-27-11.45.23.818663, IC TYPE = *E*, SHR LVL = , DSNUM = 0000, STARTLRSN=000000000001F306F01C
DEV TYPE = , IC BACK = , STYPE = , FILE SEQ = 0000, PIT LRSN= 00000000000000000000
LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = -1, LOGICAL PART = 0000, LOGGED = Y, TTYPE =
JOBNAME = RECOVER , AUTHID = SYSADM , COPYPAGESF = -1.0E+00 , EVENT ID = 1118
NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00 , MODE CREATED = N
DSNAME = TESTDB.TESTIX , MEMBER NAME = , INSTANCE = 01, RELCREATED = R
DSNU586I -DB2A 027 11:46:14.41 DSNUPSUM - REPORT RECOVERY INDEX TESTDB.TESTIX SUMMARY
DSNU588I -DB2A 027 11:46:14.41 DSNUPSUM - NO DATA TO BE REPORTED
DSNU583I -DB2A 027 11:46:14.41 DSNUPPLR - SYSLGRNX ROWS FROM REPORT RECOVERY FOR INDEX TESTDB.TESTIX
UCDATE UCTIME START RBA STOP RBA START LRSN STOP LRSN PART MEMBER ID
012722 11263986 000000000001F2B02A3E 000000000001F2B048B0 00DAFA594E6F18000000 00DAFA594E6FF6000000 0000 0000
012722 11263994 000000000001F2B086EA 000000000001F2B08E84 00DAFA594E8136000000 00DAFA5950F85D000000 0000 0000
012722 11264288 000000000001F2B66739 000000000001F2B66739 00DAFA59514F09000000 00DAFA5951502F000000 0000 0000
012722 11264304 000000000001F2BC6B7D 000000000001F2BC6B7D 00DAFA59517749000000 00DAFA595178A6000000 0000 0000
012722 11265153 000000000001F2CED990 000000000001F2CED990 00DAFA595990AD000000 00DAFA595991D9000000 0000 0000
012722 11265165 000000000001F2D59BAD 000000000001F2D59BAD 00DAFA5959AE27000000 00DAFA5959AF29000000 0000 0000
012722 11440691 000000000001F2F36B4F 000000000001F2F36B4F 00DAFA5D34F949000000 00DAFA5D34FB83000000 0000 0000
012722 11440712 000000000001F2FA2CC9 000000000001F2FA2CC9 00DAFA5D352C99000000 00DAFA5D352EA2000000 0000 0000
012722 11440752 000000000001F2FD827B 000000000001F2FD827B 00DAFA5D358EB4000000 00DAFA5D3590F1000000 0000 0000
012722 11440756 000000000001F2FD9B97 000000000001F2FD9B97 00DAFA5D3599D1000000 00DAFA5D359B5F000000 0000 0000
012722 11452374 000000000001F305E9D6 000000000001F305E9D6 00DAFA5D7E40A2000000 00DAFA5D7E43AA000000 0000 0000 *
012722 11452381 000000000001F306E84C 000000000001F306E84C 00DAFA5D7E50ED000000 00DAFA5D7E5138000000 0000 0000 *
DSNU584I -DB2A 027 11:46:14.41 DSNUPPBS - REPORT RECOVERY INDEX TESTDB.TESTIX ARCHLOG1 BSDS VOLUMES
DSNU588I -DB2A 027 11:46:14.41 DSNUPPBS - NO DATA TO BE REPORTED
DSNU586I -DB2A 027 11:46:14.41 DSNUPSUM - REPORT RECOVERY INDEX TESTDB.TESTIX SUMMARY
DSNU588I -DB2A 027 11:46:14.41 DSNUPSUM - NO DATA TO BE REPORTED
DSNU589I -DB2A 027 11:46:14.41 DSNUPREC - REPORT RECOVERY INDEX TESTDB.TESTIX COMPLETE
DSNU598I -DB2A 027 11:46:14.41 DSNUPPBK - REPORT RECOVERY SYSTEM LEVEL BACKUPS
DSNU588I -DB2A 027 11:46:14.41 DSNUPPBK - NO DATA TO BE REPORTED
DSNU580I 027 11:46:14.41 DSNUPORT - REPORT UTILITY COMPLETE - ELAPSED TIME=00:00:00
DSNU010I 027 11:46:14.42 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0Example 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.TPKQAN01In 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.TS001L11The 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.HIXW14SOL11Example 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_ 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
SHOWKEYLABELThe 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