Maintenance means the recommended practice of clearing out the DBQL dictionary tables after copying relevant data into the user DBQL temporary and DBQL history tables.
Note: DBQL temporary and DBQL history tables are user tables that the Database Administrator (DBA) generates. They are not DBQL tables. Rather they are tables that mirror the DBQL tables and serve to simplify the analysis process and the clear the raw data from the DBQL dictionary tables. DBQL dictionary tables are internal to the DBC.
There are 2 steps to the daily maintenance process. Each step is restartable.
Note: Step 1 must finish before Step 2 can start.
This macro loads the DBQL temporary tables from the DBC DBQL tables and deletes data from the DBC DBQL tables
This macro loads DBQLOGTBL_HST, DBQLSQLTBL_HST, DBQLOBJTBL_HST, DBQLOBJTBL_SUM and DBQLSummaryTBL_HST and deletes data from the DBQL temporary tables.