Start of change

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.

To identify the redundant data, you can call the stored procedure CIUSPDPG from the sample job SCIUSAMP.CICS(CIULPGSP) and enter the values for the following parameters:
  • 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.

Attention: You must run the CIUSPDPG stored procedure with the LIST option before you can delete the data. Otherwise, the deletion job does not work. For more information, see CIUSPDPG Stored Procedure.
End of change