Previous Topic: How to Establish RPROF AccessNext Topic: How to Add Date and Time Columns

The Runtime Profile (RPROF) Table for DB2 › Unused Rows

Unused Rows

Over time, an RPROF table accumulates unused rows. To detect unused rows, query the RPROF_DATE and RPROF_TIME columns in the RPROF table. You can delete unused rows but the RPROF table is more concurrent with more entries. Retain permanent rows that are used to prepopulate the RPROF, unless the table uses type 2 indexes.