Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Purging old data from Performance Advisor database

You must purge older data from the PADB to maintain an effective PADB.

For aggregated tables, the SAMP members for loading aggregated tables include the specification of PURGE_DAYS. The product automatically removes data older than the specified PURGE_DAYS value. The remove data no longer appears when the data is loaded to the tables.

Related topic

Setting-up-Performance-Advisor

For non-aggregated tables and daily real-time statistics accumulations, use a DELETE SQL statement to purge old data from the tables based on the EVNTTIME column for the following tables:

  • STMT_ERRORS
  • STMT_EXCEPTIONS
  • STMT_EXCEPTIONS_HV
  • STMT_EXCEPTIONS_OB

For other tables, use a DELETE SQL statement to purge old data based on the INTVTIME column.

The following figure shows an example of a DELETE SQL statements for purging data.

Example
SELECT DBNAME, NAME, PARTITION
    FROM BMCSFTWR.BMCINDEXSPACESTATS
    WHERE READTM IS NULL
    WHERE LASTUSED < CURRENT_TIMESTAMP - 90 DAYS;

This section contains the following topic:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*