How to increase the space of a View Database?

Products

• Output Management Document Viewer
• Deliver
• View
• Output Management Web Viewer

Issue/Introduction

How to increase or add additional space to an existing database ?

Environment

Release: All
Component: Deliver and View

Resolution

The SARDBASE ADDDS utility allows to add space to the database.

The ADDDS control statement is used to create a new database, to add additional space to an existing database, or to add a new index file data set.
Space is added by creating a new data set and formatting it with fixed-length blocks.

Sample JCL:

     //SARDBASE  EXEC PGM=SARDBASE
     //STEPLIB      DD DSN=xxxxxx.xxxxx.CVDELOAD,DISP=SHR
     //SYSPRINT   DD SYSOUT=*
     //*  CUSTOMIZE THE FOLLOWING CONTROL STATEMENTS FOR YOUR ENVIRONMENT
     //SYSIN         DD   *
     NAME ?high-level qualifier?
     ADDDS UNIT=3390 STORCLAS=TSO CYL=10 BLKSIZE=8906 INDEX          --------- if index space is needed
     ADDDS UNIT=3390 STORCLAS=TSO CYL=10 BLKSIZE=3768 DATA          ---------- if data space is needed
     STATUS
     /*
     //

Additional Information

Note:
The View STC does NOT need to be down, ADDDS will dynamically add the space while the STC is up and running.

Database Extent Considerations

• For data sets that are 4,369 or fewer cylinders, the data sets are to be allocated as an IBM direct access data set.
  
  
• For data sets that are more than 4,369 cylinders, the data sets are to be allocated as physical sequential data sets due to IBM restrictions.

Note:
The physical sequential data sets are accessible via standard utilities and ISPF. It is recommended that you use the CA View Systems Extension Data Set Security Feature to limit access to these data sets or implement encryption to secure the data.