How to delete records from the IIR databases?

book

Article ID: 18768

calendar_today

Updated On:

Products

CA Distributed Database Management CA Database Analyzer for DB2 for Oracle CA Database Analyzer (IMS Tools) CA Mainframe Configuration Manager for IMS for z/OS IMS TOOLS - MISC CA Compress Data Compression (IMS Tools) CA Database Analyzer for IMS for z/OS CA Database Copier for IMS for z/OS CA Database Organizer for IMS for z/OS CA Mainframe Extended Terminal Manager (IMS Tools) CA High Performance Recovery for IMS for z/OS CA Database Organizer (IMS Tools) CA Mainframe Program Restart Manager for IMS for z/OS CA Secondary Index Builder for IMS for z/OS CA Secondary Index for IMS for z/OS

Issue/Introduction

Description:

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

Solution:

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.

Environment

Release:
Component: DBO