How to delete records from the IIR databases?

Products

• Database Organizer for IMS for z/OS
• Database Organizer (IMS Tools)
• DATABASE MANAGEMENT SOLUTIONS FOR IMS FOR Z/OS

Issue/Introduction

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

Resolution

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.