How to configure CA Rapid Reorg to update the DB2 Real Time Statistics (RTS) tables?

Document ID : KB000024854
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

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

 

Answer:

Real Time Statistics or (RTS) was created to help automate DB2 database administration. In the past, using DB2 RUNSTATS or CA 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 CA 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. Please consult IBM's DB2 Administration Guide for more details.

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)                */