How to configure Rapid Reorg to update the Db2 Real Time Statistics (RTS) tables

Products

• Rapid Reorg for DB2 for z/OS

Issue/Introduction

How to enable Rapid Reorg for Db2 for z/OS (PRR) to update the Db2 Real Time Statistics (RTS) tables.

Resolution

Real Time Statistics or (RTS) was created to help automate Db2 database administration. In the past, using Db2 RUNSTATS or PDASTATS was the only way to create statistics
about Db2 database objects. When using RTS, it runs in the background and automatically updates statistics in Db2 tables as the data in Db2 databases is modified.
Please note: RTS does not replace the catalog tables so Db2 RUNSTATS and PDASTATS are still valid.

Running with current statistics on production based objects is essential to create a efficient environment. Using these statistics can help identify future problems and correct them
before they happen. They can also spot changes in how data is flowing through the system. Furthermore, you can also help identify key areas to improve performance.

To update RTS with PRR edit hlq.CDBAPARM member UTIL.

Please edit or enter the following line:
UPDTE-RTS-TABLES (YES)  /* UPDATE RTS TABLES (NO/YES)                */