We don't have DB2, but most of our production DATACLAS entries include "Data Space Constraint Release" of "Yes" and a value in "Reduce Space Up To". I don't know if these values are compatible with DB2 allocations or not.
On Thu, Feb 21, 2013 at 7:43 AM, Lizette Koehler <[email protected]>wrote: > Jim > > > > Does you SMS definitions have Extended Format Extended Address for the VSAM > allocations? I think that is in the DATACLAS definition for this file? > > Since I do not see a DATACLAS defined, I am guessing it does not. For most > of your DB2 files you should have a DATACLAS with Extended Format YES > Extended Address YES > > > > STORCLAS (SCSMS) MGMTCLAS ( ) DATACLAS ( ) > STORGRPS (SGDB2E ) > > > > > > > > > > Lizette > > > > > > From: Jim McAlpine [mailto:[email protected]] > Sent: Thursday, February 21, 2013 6:37 AM > To: [email protected]; IBM Mainframe Discussion List > Subject: [DB2-L] - DB2 V10 upgrade - SMS allocation failure > > > > cross posted to DB2-L and IBM-MAIN. > > > > I'm trying to run DSNTIJEN to upgrade to DB2 V10 new function but the job > is > failing on the reorg of SPT01. Following are the SMS messages. > > > > IGD17272I VOLUME SELECTION HAS FAILED FOR INSUFFICIENT SPACE FOR 808 > DATA SET DB2E.IMAGCOPY.SPT01.D2013052.T125957 > JOBNAME (DB2DBAA ) STEPNAME (ENFM0027) > PROGNAME (DSNUTILB) DDNAME (SYS00001) > REQUESTED SPACE QUANTITY = 4349339 KB > STORCLAS (SCSMS) MGMTCLAS ( ) DATACLAS ( ) > STORGRPS (SGDB2E ) > IGD17272I VOLUME SELECTION HAS FAILED FOR INSUFFICIENT SPACE FOR 809 > DATA SET DB2E.IMAGCOPY.SPT01.D2013052.T125957 > JOBNAME (DB2DBAA ) STEPNAME (ENFM0027) > PROGNAME (DSNUTILB) DDNAME (SYS00002) > REQUESTED SPACE QUANTITY = 3038417 KB > STORCLAS (SCSMS) MGMTCLAS ( ) DATACLAS ( ) > > STORGRPS (SGDB2E ) > > > > and here are the DB2 messages. > > > > DSNU1035I 052 13:59:57.54 DSNUJTDR - TEMPLATE STATEMENT PROCESSED > SUCCESSFULLY > DSNU050I 052 13:59:57.54 DSNUGUTC - REORG TABLESPACE DSNDB01.SPT01 > SHRLEVEL REFERENCE LOG NO COPYDDN(SYSCOPY) > CONVERTV10 RETRY 255 TIMEOUT TERM RETRY_DELAY 1 DRAIN_WAIT 1 SORTDATA > SORTDEVT SYSDA SORTNUM 99 > DSNU3343I ! 052 13:59:57.54 DSNURFIT - REAL-TIME STATISTICS INFORMATION > MISSING FOR TABLESPACE DSNDB01.SPT01 > > DSNU3343I ! 052 13:59:57.54 DSNURFIT - REAL-TIME STATISTICS INFORMATION > MISSING FOR INDEX SYSIBM.DSNSPT01 > > DSNU3343I ! 052 13:59:57.54 DSNURFIT - REAL-TIME STATISTICS INFORMATION > MISSING FOR INDEX SYSIBM.DSNSPT02 > > DSNU1015I 052 14:00:40.18 DSNUGDYN - ERROR ALLOCATING DATA SET > DSN=DB2E.IMAGCOPY.SPT01.D2013052.T125957 > CODE=X'970C0000' > DSNU1042I 052 14:00:40.18 DSNUGDYN - START OF IDCAMS MESSAGES > IKJ56893I DATA SET DB2E.IMAGCOPY.SPT01.D2013052.T125957 NOT ALLOCATED+ > IGD17273I ALLOCATION HAS FAILED FOR ALL VOLUMES SELECTED FOR DATA SET > DB2E.IMAGCOPY.SPT01.D2013052.T125957 > IGD17277I THERE ARE (12) CANDIDATE VOLUMES OF WHICH (12) ARE ENABLED OR > QUIESCED > IGD17290I THERE WERE 1 CANDIDATE STORAGE GROUPS OF WHICH THE FIRST 1 > WERE ELIGIBLE FOR VOLUME SELECTION. > THE CANDIDATE STORAGE GROUPS WERE:SGDB2E > IGD17279I 12 VOLUMES WERE REJECTED BECAUSE OF INSUFF TOTAL SPACE > DSNU1043I 052 14:00:40.19 DSNUGDYN - END OF IDCAMS MESSAGES > DSNU012I 052 14:00:52.45 DSNUGBAC - UTILITY EXECUTION TERMINATED, > HIGHEST > RETURN CODE=8 > > Following is the available space. > > > > Volser Unit Devtyp FTrk LTrk FCyl LCyl DSCB %Use Mnt VTOC SGRP > DB2E12 0D33 3390-9 49926 49926 3328 3328 7447 0 Prv Actv SGDB2E > DB2E11 0D34 3390-9 49926 49926 3328 3328 7447 0 Prv Actv SGDB2E > DB2E10 0D96 3390-9 49926 49926 3328 3328 7447 0 Prv Actv SGDB2E > DB2E01 0DA4 3390-9 5969 1800 391 120 5360 88 Prv Actv SGDB2E > DB2E02 0DA5 3390-9 7080 1650 451 110 2588 85 Prv Actv SGDB2E > DB2E03 0DA6 3390-9 2848 2835 189 189 2219 94 Prv Actv SGDB2E > DB2E04 0DA7 3390-9 7853 6540 521 436 8194 84 Prv Actv SGDB2E > DB2E05 0DA8 3390-9 11827 10800 787 720 5979 76 Prv Actv SGDB2E > DB2E06 0DA9 3390-9 14333 10650 952 710 7369 71 Prv Actv SGDB2E > DB2E07 0DAA 3390-9 9203 5205 604 347 7227 81 Prv Actv SGDB2E > DB2E09 0DAE 3390-9 49916 49895 3327 3326 7446 0 Prv Actv SGDB2E > DB2E08 0DAF 3390-9 7046 6990 469 466 7424 85 Prv Actv SGDB2E > > > > > I don't understand why I have 2 x IGD17272I messages here but even so I > make > each of the allocation requests to be approx 6000 cylinders. Why can't the > allocation be done from the available space above. > > > > Jim McAlpine > > > > _____ > > Site Links: View post online > <http://www.idug.org/p/fo/st/post=155284&anc=p155284#p155284> View > mailing list online <http://www.idug.org/p/fo/si/topic=19> Send new > post > via email <mailto:[email protected]> Unsubscribe from this mailing > list <mailto:[email protected]?Subject=Unsubscribe> > Manage > your subscription <http://www.idug.org/p/us/to/> > ** ** ** IDUG DB2 Tech Seminar in Bangalore, India 2013 ** ** ** > ---> At the Vivanta by Taj Hotel in Bangalore on the 20th of March 2013 > <--- > http://www.idug.org/p/cm/ld/fid=291 > > Use of this email content is governed by the terms of service at: > http://www.idug.org/p/cm/ld/fid=2 > > _____ > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > -- This is a test of the Emergency Broadcast System. If this had been an actual emergency, do you really think we'd stick around to tell you? Maranatha! <>< John McKown ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
