Recovering the real-time statistics tables

When you recover a Db2 subsystem after a disaster, Db2 starts with the ACCESS(MAINT) option. No statistics are externalized in this state.

Procedure

Consequently, you need to perform the following actions on the real-time statistics database:

  • Recover the real-time statistics objects after you recover the Db2 catalog and directory.
  • Start the real-time statistics database explicitly, after Db2 restart.