Chapter 6. Utilities with LOBs 185
Example 6-38 REPORT TABLESPACESET on automatic created objects
REPORT TABLESPACESET TABLESPACE DSN00030.NORMEN01
The resulting report is shown in Example 6-39.
Example 6-39 REPORT TABLESPACESET report
DSNU000I 209 15:06:45.13 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = REPORT.NORMEN00
DSNU1044I 209 15:06:45.19 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I 209 15:06:45.19 DSNUGUTC - REPORT TABLESPACESET TABLESPACE DSN00030.NORMEN01
DSNU587I -DB9B 209 15:06:45.20 DSNUPSET - REPORT TABLESPACE SET WITH TABLESPACE DSN00030.NORMEN01
TABLESPACE SET REPORT:
TABLESPACE : DSN00030.NORMEN01
TABLE : ##T.NORMEN01
LOB TABLESPACE SET REPORT:
TABLESPACE : DSN00030.NORMEN01
BASE TABLE : ##T.NORMEN01
PART: 0001 COLUMN : IMAGE
LOB TABLESPACE : DSN00030.L96UX60E
AUX TABLE : ##T.NORMEIMAGE96UXYNM9
AUX INDEXSPACE : DSN00030.INORMEIM
AUX INDEX : ##T.INORMEIMAGE96UXYYX
DSNU580I 209 15:06:45.20 DSNUPORT - REPORT UTILITY COMPLETE - ELAPSED TIME=00:00:00
DSNU010I 209 15:06:45.20 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
A report on the recovery information about all automatically created objects related to table
##T.NORMEN01 can be obtained as shown in Example 6-40.
Example 6-40 REPORT RECOVERY
LISTDEF MYLIST INCLUDE TABLESPACES TABLE ##T.NORMEN01 ALL
REPORT RECOVERY TABLESPACE LIST MYLIST INDEX ALL
6.8 RUNSTATS
When dealing with LOBs, you can run the RUNSTATS utility against the base table space, the
LOB table space, or the index on the auxiliary table. We do not discuss the HISTORY catalog
tables in this paragraph, but they contain similar statistics when RUNSTATS is run to collect
historical data. You can run RUNSTATS on the auxiliary objects, but the statistics do not have
any effect on access paths and there are no column statistics. The statistics can be used to
monitor space usage (such as number of extents) and ORGRATIO to schedule a REORG of
the LOB table space. ORGRATIO is used for LOBs to indicate the percentage of LOBs that
are properly chunked (that is, allocated in contiguous sets of 16 pages). This is explained in
more detail at “Monitoring ORGRATIO” on page 193.
RUNSTATS on the base table space
In SYSIBM.SYSCOLUMNS, the cardinality of a LOB column, COLCARDF, is determined by
counting only non-null and non-zero length columns. HIGH2KEY and LOW2KEY are
not
applicable for the LOB column and contain blanks.

Get LOBs with DB2 for z/OS: Stronger and Faster now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.