To manage the data that you have collected, you can delete
your unwanted data and keep your data sources in sync.
Utilities that are provided by
CICS® IA to
delete data from the DB2® database.
These utilities include the following jobs:
- Sample job SCIUSAMP.DB2(CIUCLR). This job provides the skeleton
JCL and SQL to delete data that is based on specified conditions from
the CICS IA tables.
- Sample job SCIUSAMP.CICS(CIUPRUNE). This job provides JCL and
SQL to delete data that is based on the last used date from the tables.
- Sample job SCIUSAMP.CICS(CIUDELSP). This sample job calls the DB2 stored procedure to delete data
that is based on the collection ID from all of the tables.
- If you use the CICS IA plug-in
for CICS Explorer® you
can delete data by TS application and by collection ID.