View - Receiving SARSTC24 Message Regularly

Products

• View

Issue/Introduction

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

 WTOR 4461 SARSTC24 NO MORE SPACE IN DATABASE <dbname> - 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 <dbname>                                       
ADDDS UNIT=3390 BLKSIZE=8906  CYL=2000 VOLSER=XXXXXX INDEX 
ADDDS UNIT=3390 BLKSIZE=10796 CYL=2000 VOLSER=XXXXXX DATA  
/*                                                         

 

It helped for some time, but now we are receiving more alerts.

Environment

Release : View 12.2

Cause

Removed the dbname, vol ser

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.