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

Document ID : KB000021474
Last Modified Date : 14/02/2018
Show Technical Document Details

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.