CA View - High percentage of View Index Usage

book

Article ID: 208037

calendar_today

Updated On:

Products

CA View

Issue/Introduction

We have a high percentage of use of the Index in the CA View database.

We would like to know if we have to increase the size of the index or just reorganize.

For both situations, please send us examples of jobs to use.

Environment

Release : 14.0

Component : CA View

Resolution

This is SARDBASE JCL, to add space to the View index:

//XXXXXXXX JOB ...                                                
//SARDBASE EXEC PGM=SARDBASE,PARM='VIEW_HLQ'  <=== MODIFY DB NAME 
//STEPLIB  DD  DISP=SHR,DSN=VIEW.CVDELOAD     <=== MODIFY, IF USED
//SYSPRINT DD  SYSOUT=*                                           
//SYSIN    DD   *                                                 
ADDDS INDEX CYLINDER=nnnn BLKSIZE=8906 VOL=xxxxxx UNIT=3390        
/*                                                                
//   

This is SARDBASE JCL, to run a REORG ASYNCH:

//XXXXXXXX JOB ...                                                
//SARDBASE EXEC PGM=SARDBASE,PARM='VIEW_HLQ'  <=== MODIFY DB NAME 
//STEPLIB  DD  DISP=SHR,DSN=VIEW.CVDELOAD     <=== MODIFY, IF USED
//SYSPRINT DD  SYSOUT=*                                           
//SYSPRINT DD  SYSOUT=*                                           
//SYSIN    DD  *                                                  
REORG ASYNCH                                                      
/*                                                                
//                                                                

Please note that both the ADDDS and REORG ASYNCH functions can run while the SARSTC task is active.