We are trying to reallocate database files on a system that doesn’t have SMS storage.
We would like to add additional multiple disk pack volumes to database file areas to be used when they extend.
Release : 15.1
Component : CA DATACOM/DB
For non-SMS datasets, to make more volumes available for dynamic extends there is no need to reallocate the files.
More volumes can be added by uncataloging the data set and recataloging it with additional volumes which will then be available for use by dynamic extends.
Perform the following procedure:
Here is a sample job to uncatalog and rectalog using IEFBR14. Assume the file currently resides in volser1 and adding 2 volumes.
//* UNCATALOG DATASET
//UNCAT EXEC PGM=IEFBR14
//SYSUT2 DD DSN=database.file,DISP=(OLD,UNCATLG)
//* RECATALOG WITH ADDITONAL VOLUMES
//RECAT EXEC PGM=IEFBR14
//SYSUT2 DD DSN=database.file,VOL=SER=(volser1,volser2,volser3),
A dynamic extend will then use the additional volumes.
After adding the volumes, if a DBUTLTY INIT is run it will default to allocating extents across all volumes.
To INIT the file and only use the first volume add the VOLUMES parameter to the INIT, e.g.: