How to delete data from the Sysview for Db2 archive tables

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

The Sysview Performance Management for Db2 for z/OS (IDB2) APPLICATION_DETAIL_P and APPL_PGM_DETAIL_P tables have
become large with 22 million rows. What is the process to delete data from these tables? Can the tablespaces be online reorged with
discard to delete data?

Resolution

These are standard tablespaces/tables which can be managed as any other Db2 table.

Archival Process

It is suggested that Periodically delete data that is over xx days old and run a REORG to reclaim deleted space.
To perform the delete, the sample SQL member ARCSQLD in the Sysview for Db2 SOURCE library is provided.