search cancel

CA View - Receiving SARSTC24 Message Regularly

book

Article ID: 214464

calendar_today

Updated On:

Products

View

Issue/Introduction

The past few days we have been receiving the following WTOR repeatedly:

 WTOR 4461 SARSTC24 NO MORE SPACE IN DATABASE SYS3.CE.CAVIEW - REPLY R (RETRY), B (BACKUP), N (NEW), C (CLEAN), OR T (TERMINATE)
 
We have run SARDBASE ADDDS (INDEX and DATA), per the below, to add more space:
 
//STEP1    EXEC PGM=SARDBASE                               
//SYSPRINT DD SYSOUT=*                                     
//SYSIN    DD *                                            
NAME SYS3.CE.CAVIEW                                        
ADDDS UNIT=3390 BLKSIZE=8906  CYL=2000 VOLSER=GHTU05 INDEX 
ADDDS UNIT=3390 BLKSIZE=10796 CYL=2000 VOLSER=GHTU05 DATA  
/*                                                         
 
It helped for some time, but now we are receiving more alerts.

Environment

Release : 12.2

Component : CA View

Resolution

As there were no runaway reports found in the client's database, then the reason for there needing to be the addition of database data space is because there is a recent higher demand for space due to an increase in report production. 

It was recommended that, periodically, the client run a SARDBASE STATUS FULL job, to monitor the usages of all of their databases, and to add space where necessary.