Managing the collected data

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.
  • Start of changeSample job SCIUSAMP.CICS(CIUPURSP). This sample job calls the DB2 stored procedure to delete data that is based on the prefix of the object name from CIU_CICS_DATA table. End of change
  • Start of changeSample jobs SCIUSAMP.CICS(CIULPGSP) and SCIUSAMP.CICS(CIUDPGSP). These sample jobs call the DB2 stored procedure to list (CIULPGSP) and delete (CIUDPGSP) data that is based on the collecton_id, applid, and program_name values taken from the specified table. End of change
  • If you use the CICS IA plug-in for CICS Explorer® you can delete data by TS application and by collection ID.