ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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 Database Analyzer (IMS Tools) Mainframe Configuration Manager for IMS for z/OS IMS TOOLS - MISC Compress Data Compression (IMS Tools) Database Analyzer for IMS for z/OS Database Copier for IMS for z/OS Database Organizer for IMS for z/OS Mainframe Extended Terminal Manager (IMS Tools) High Performance Recovery for IMS for z/OS Database Organizer (IMS Tools) Mainframe Program Restart Manager for IMS for z/OS Secondary Index Builder for IMS for z/OS 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