SARDBI07 No more index file space in database

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

QUESTION :

Receiving the following message in the CA View STC  :-

*SARDBI07 No more index file space in database 

How do I add more Index space to a CA View Database ? 

 

ANSWER :

You need to use the SARDBASE utility to add more Index Space to your
CA View database.

The space is allocated in the form of a new extent to your existing CA VIEW database.  

The following JCL is an example of the SARDBASE utility that can be used
to add more space to a CA View database  :-


STEP1 EXEC PGM=SARDBASE
STEPLIB DD DSN=CA VIEW LOADLIBRARY
SYSPRINT DD SYSOUT=*
SYSIN DD *
NAME View.HLQ
ADDDS UNIT=3390 VOL=VVVVVV CYL=NNN INDEX  

where :-


STEPLIB points to your CA View Load Library.

View.HLQ points to your CA View Database HLQ.

VVVVVV points to the Volume where the new Index Extent is allocated.

NNN space allocation of new extent.