search cancel

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)?

book

Article ID: 21474

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

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