How to delete data from the INSIGHT tables

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

 

The 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 ?

 

 

Environment

Release : 20.0

Resolution

These are standard tablespaces/tables so  can be manage as any other DB2 Table.

See Archiving Data

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.