How do I add space to my database?

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

You can add space to the database by using the SARDBASE ADDDS utility.

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.

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.

JCL as follows:


     //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
     /*
     //