View - Message shows database to be over 80 percent full

Products

• View

Issue/Introduction

We received a message saying that the View database was over 80 percent full.

How do you reduce the percentage?

Environment

Release : 14.0

Resolution

Review the database usage percentage message, to see if it is referring to the Index or the Data portion of the database:

 . If it is the index usage, then it is recommended that you add index space using the following:

//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 UNIT=3390 VOLSER=xxxxxx      
/*                                                                
//                                                                

 . If it is the data usage, it is suggested that you do the following:

 . . Issue command "/F sarstc,DUMP", to run a View backup. 

 . . If the data usage percentage does not drop as expected, please then add data space:

//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 DATA  CYLINDER=300 BLKSIZE=13682 UNIT=3390 VOLSER=xxxxxx     
/*                                                                
//