How can I find the IIR Repository tables and fields being needed for my specific SQL query?

book

Article ID: 18984

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:

When an SQL query has been created to deliver specific information from the Datacom IIR Repository, the fields being needed for this query (and the tables in which these fields can be found) need to be identified.

Solution:

These steps can be used to identify the IIR field names and table IDs being needed for a specific SQL query:

  1. look into the reports of an IMS tools execution (e.g. DBA or DBO) to intentify the report fields being needed for your query

  2. look to the IMS tools' report headers which belong to the selected report fields which have been identified in Step 1

  3. go to the IIR User Guide, Appendix A "Table Information", and search all table descriptions for the report header you found in Step 2 (to identify the table containing the fields being needed for the SQL query)

  4. use the tables's "Description" column to identify the table field names of the fields being needed for your query

Environment

Release:
Component: DBO