How to check the pointer of all related primary data bases (from different data set groups and/or logical related data bases), without also checking the content of related index data bases (primary and secondary indexes)?

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

Question:

If the Dataspace is getting short because of checking too many data sets in a single DBA execution and if using option MULTISPACE=Y did not solve the storage problem, how can we check the pointer of all related primary data bases (from different data set groups and/or logical related data bases), without also checking the content of related index data bases (primary and secondary indexes)?

 

Answer:

To check the pointer of several related primary data bases without also checking the index data bases, these DBA options can be used :

FUNCTION=ANALYZE,POINTERCHECK=CROSSDBD,DBDNAME=dbdname1   
FUNCTION=ANALYZE,POINTERCHECK=CROSSDBD,DBDNAME=dbdname2 
etc. (one FUNCTION statement for each primary DBD)

Using POINTERCHECK=CROSSDBD will check all pointer within this data set as well as those pointer pointing into another primary data base data set (belonging to a different Dataset Group as well as to another logical related data base).

If the index data bases also need to be checked, these additional FUNCTION statements can be used :

FUNCTION=ANALYZE,POINTERCHECK=CROSSDBD,DBDNAME=indexdbdname1   
FUNCTION=ANALYZE,POINTERCHECK=CROSSDBD,DBDNAME=indexdbdname2 
etc.

Environment

Release:
Component: DBA