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 ?
Release : 20.0
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 xxdays 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.