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
