
Deleting old versions of programs
You can delete CICS® IA data from different dependency tables. The tables might contain many records that relate to old versions of a program. By deleting the unwanted records, you reduce the size of your tables and can improve the efficiency of your system.
You can use the CIUSPDPG DB2® stored procedure to delete these redundant records by specifying the COLLECTION_ID, APPLID, and PROGRAM NAME.
- collection_id
- applid
- program_name
- table_name
This sample job contains a LIST option for the stored procedure and the job populates the CIU_PROGRAM_TEMP1 and CIU_PROGRAM_TEMP2 tables.
The CIU_PROGRAM_TEMP1 table contains the latest versions of the specified programs. These rows are to be kept and are not deleted.
The CIU_PROGRAM_TEMP2 table contains the rows from the specified table, which can be deleted.
The CIU_PROGRAM_TEMP1 and CIU_PROGRAM_TEMP2 tables contain the information only from records, which are kept or deleted.
Some of the records might contain the same information, so, the count of the number of kept or deleted records can differ from the number of records in the CIU_PROGRAM_TEMP1 and CIU_PROGRAM_TEMP2 tables.
After the job is finished, you can review the CIU_PROGRAM_TEMP1 and CIU_PROGRAM_TEMP2 tables. Ensure that the content in the CIU_PROGRAM_TEMP2 table is no longer required.
You can then run the SCIUSAMP.CICS(CIUDPGSP) sample job, which contains a DELETE option. The CIUSPDPG DB2 stored procedure deletes all of the rows that are listed in the CIU_PROGRAM_TEMP2 from the specified table.
