LOBs with DB2 for z/OS: Stronger and Faster

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.