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 DSNU1044I 209 DSNU050I 209 DSNU587I -DB9B 15:06:45.13 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = REPORT.NORMEN00 15:06:45.19 DSNUGTIS - PROCESSING SYSIN AS EBCDIC 15:06:45.19 DSNUGUTC - REPORT TABLESPACESET TABLESPACE DSN00030.NORMEN01 209 15:06:45.20 DSNUPSET - REPORT TABLESPACE SET WITH TABLESPACE DSN00030.NORMEN01 TABLESPACE SET REPORT: TABLESPACE TABLE : DSN00030.NORMEN01 : ##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 DSNU010I 209 15:06:45.20 DSNUPORT - REPORT UTILITY COMPLETE - ELAPSED TIME=00:00:00 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. Chapter 6. Utilities with LOBs 185