Error description:

Currently the DB2 subsystem ‘TDB2’ has 2 volumes DB2003 & DB2004 allocated to its Storage Group ‘TDB2STGP’. Due to insufficient space on the volumes the following error message is displayed in the LOG.

Error message in LOG:

IGD17288I DATA SET DSNCAT2.DSNDBC.DSNDB07.DSN4K00.I0001.A003 420

COULD NOT BE ALLOCATED NORMALLY AND IS NOT ELIGIBLE

FOR SPACE CONSTRAINT RELIEF (MULTI VOLUME) BECAUSE IT IS

A SINGLE VOLUME DATA SET.

SPACE CONSTRAINT RELIEF (SPACE REDUCTION AND/OR 5 EXTENT

LIMIT RELIEF) WILL BE ATTEMPTED

IGD17272I VOLUME SELECTION HAS FAILED FOR INSUFFICIENT SPACE FOR 421

DATA SET DSNCAT2.DSNDBC.DSNDB07.DSN4K00.I0001.A003

JOBNAME (DFSMSHSM) STEPNAME (DFSMSHSM)

PROGNAME (ARCCTL ) DDNAME (N/A)

REQUESTED SPACE QUANTITY = 2417903 KB

STORCLAS (TDB2STCL) MGMTCLAS ( ) DATACLAS (TDB2DTCL)

STORGRPS (TDB2STGP )

DSNT500I @ DSNB1OPP RESOURCE UNAVAILABLE 422

REASON 00C200F9

TYPE 00000220

NAME DSNCAT2.DSNDBC.DSNDB07.DSN4K00.I0001.A003

CORRELATION-ID=tbpm01

CONNECTION-ID=SERVER

LUW-ID=L152C7D9.OB4B.D129A8D60DE9=952576

REASON 00C200F9

TYPE 00000220

NAME DSNCAT2.DSNDBC.DSNDB07.DSN4K00.I0001.A003

Solution

Initialize a new SMS volume ‘DB2005’ and define and add the volume through ISMF to the Storage Group as given in the following steps.

1. Initialize new SMS Volume DB2005

//STEP1 EXEC PGM=ICKDSF,REGION=4096K

//SYSPRINT DD SYSOUT=*

//SYSIN DD *

INIT UNIT(26A) NOVALIDATE NVFY VOLID(DB2005) PURGE -

VTOC(0,1,75) INDEX(6,0,15) STORAGEGROUP

/*

2. Logon to ISMF as Storage Administrator.

3. Select “6 Storage Group - Specify Volume Names and Free Space Thresholds”

4. Select “5. Volume - Display, Define, Alter or Delete Volume Information”

CDS Name - 'SYS1.DFSMS.SCDS'

Storage group - TDB2STGP

5. Select “2. Define - Add Volumes to Volume Serial Number List”

Give Volume Prefix as ‘DB2005’

SMS Volume Status as ‘ENABLE’

6. Perform Verification, then Activate.