Jim, Yes, Ext Add applies to physical sequential as well as VSAM.
Dave O'Brien -----Original Message----- From: Jim McAlpine [mailto:jim.mcalp...@gmail.com] Sent: Thursday, February 21, 2013 8:55 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: [DB2-L] - DB2 V10 upgrade - SMS allocation failure Lizette, I thought that was only for the DB2 catalog and directory. This is just for an image copy dataset, does that requires those attributes also ? Jim On Thu, Feb 21, 2013 at 1:43 PM, Lizette Koehler <stars...@mindspring.com>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:jim.mcalp...@gmail.com] > Sent: Thursday, February 21, 2013 6:37 AM > To: db...@lists.idug.org; 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:db...@lists.idug.org> Unsubscribe from this mailing > list <mailto:db2-l+unsubscr...@lists.idug.org?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 lists...@listserv.ua.edu with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
