CDB/Runstats makes it easy to gather all DB2 statistics gathered by DSTATS in a fraction of the time. CDB/Runstats allows users to use wildcard masks to specify a group of tablespaces and generates full statistical reports on the tablespaces user specify, without actually updating the DB2 catalog. Of course, if users do want the DB2 catalog updated when reports are generated, that option remains available.

In addition, CDB/Runstats gives users the option of solely updating DB2 catalog statistics without performing any other action. The updated values are made available to the DB2 Optimizer. CDB/Runstats follows a syntax similar to IBM’s Runstats feature of DB2, but requires even few keywords to take advantage of its effectiveness. Finally, CDB/Runstats is fully integrated with the other CDB/Auto-Utilities.

Users may specify multiple Runstats statements in a single job step, and even mix and match Runstats statements with selected IBM utilities or commands and with other CDB utility statements.