How to delete records from the IIR databases?

Document ID : KB000018768
Last Modified Date : 14/02/2018
Show Technical Document Details


If the IIR tables become full or too large how do we delete records from these tables?


The easiest way to maintain a table in the IIR database is to use one of the SQL batch tools, DBSQLPR or DQBATCH, to execute an SQL DELETE rows command. The SQL syntax lets you remove all or some of the rows in a specific table.

Please refer to the section 'Remove Data from an IIR Table' in the IMS Information Repository Guide for full details.

Additionally, we provide sample job, IIRCLNUP, in the hlq.CIMTSAMP, which deletes all reports older than 90 days for example.