DB2 Sort and SyncSort do not have that limitation. Their limitation is 2**40 rather than 2**32.
Chris Blaicher Senior Software Engineer, Software Services Syncsort Incorporated 50 Tice Boulevard, Woodcliff Lake, NJ 07677 P: 201-930-8260 | M: 512-627-3803 E: cblaic...@syncsort.com -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Mehrshad Manshadi Sent: Tuesday, October 09, 2012 1:39 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Reorganizing Partition Table Space With REBALANCE Option Problem. Hi David, Thanks for your useful information. So The APAR PM43006 will solve our problem? Am I right? Best regards Manshadi ________________________________ From: David Betten <bet...@us.ibm.com> To: IBM-MAIN@LISTSERV.UA.EDU Sent: Monday, October 8, 2012 6:01 PM Subject: Re: Reorganizing Partition Table Space With REBALANCE Option Problem. Unfortunately, you are exceeding a DFSORT limitation on the number of records that can be sorted. DFSORT has the following limitations 1. Variable-length records - 4294967295 records 2. EQUALS in effect - 4294967295 records 3. VLSHRT in effect - 2147483647 records 4. Blockset technique not selected - 2147483647 records Number 4 will not be a problem since Blockset is always used for sorts invoked by DB2 Utilities. DB2 APAR PM43006 causes the utilities to pass NOVLSHRT and NOEQUALS which would resolve numbers 2 and 3 but since this is a vaiable length sort, you're still going to have that first limitation of 4,294,967,295 records. Normally you'd want to break up the reorg by partitions but since you're doing a rebalance, I guess that's why it's trying to sort the entire file at once. I suggest you open PMR and see if DB2 Utilities support can provide a solution. Also two additional notes about this. 1. It looks like your DFSORTinstallation default for DSA is 64 and that's causing the utility to limit the mainsize it passes. You probably want something much larger for a sort this size. I'd suggest changing your installation default to something much larger like DSA=256. 2. It appears you are running DFSORT V1R5. That has been out of service for quite some time. Have a nice day, Dave Betten DFSMS Performance Engineer IBM Corporation email: bet...@us.ibm.com 1-301-240-3809 DFSORT/MVSontheweb at http://www.ibm.com/storage/dfsort/ IBM Mainframe Discussion List <IBM-MAIN@listserv.ua.edu> wrote on 10/08/2012 10:10:10 AM: > From: Mehrshad Manshadi <m_mansh...@yahoo.com> > To: IBM-MAIN@listserv.ua.edu, > Date: 10/08/2012 10:11 AM > Subject: Re: Reorganizing Partition Table Space With REBALANCE Option Problem. > Sent by: IBM Mainframe Discussion List <IBM-MAIN@listserv.ua.edu> > > Hi Dave, > > > > The attached is sort message of the output job. > > > 1ICE143I 0 BLOCKSET SORT TECHNIQUE SELECTED > > ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, > EXAMPLES A > ICE000I 0 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 11: > 18 ON MON OC > 0 OPTION MOSIZE=0 > ICE140I 0 END OF PARAMETERS FROM DFSPARM - SYSIN OR SORTCNTL/ > PARAMETER LIST CO > SORT FIELDS=(00005.0,00028. > 0,A),FORMAT=BI,FILSZ=E000004979426640,DYNA > OC=(SYSDA,04) > RECORD TYPE=V,LENGTH=(00070,00070,00070) > OPTION MSGPRT=ALL,MSGDDN=UTPRINT,AVGRLEN=00070,MAINSIZE=065536K > ICE201I 0 RECORD TYPE IS V - DATA STARTS IN POSITION 5 > ICE751I 0 C5-BASE C6-BASE C7-BASE C8-Q83041 E4-BASE C9-BASE > E5-Q90312 > ICE193I 0 ICEAM2 ENVIRONMENT IN EFFECT - ICEAM2 INSTALLATION MODULE SELECTED > ICE089I 0 ROINHORB.REORG .DSNUPROC, INPUT LRECL = 70, TYPE = V > ICE092I 0 MAIN STORAGE = (67108864,67108864,67108864) > ICE156I 0 MAIN STORAGE ABOVE 16MB = (66060288,66060288) > ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 > ,SPANINC=RC16,VLSCMP=N,SZERO=Y > ICE128I 0 OPTIONS: > SIZE=67108864,MAXLIM=1048576,MINLIM=450560,EQUALS=Y,LIST=Y,E > ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHA > ICE130I 0 OPTIONS: RESALL=0,RESINV=0,SVC=109 > ,CHECK=Y,WRKREL=Y,OUTREL=Y,CKPT=N, > ICE131I 0 OPTIONS: > TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=16384,CINV=Y,CFW > ICE132I 0 OPTIONS: > VLSHRT=N,ZDPRINT=Y,IEXIT=N,TEXIT=N,LISTX=N,EFS=NONE ,EXIT > ICE133I 0 OPTIONS: HIPRMAX=OPTIMAL,DSPSIZE=MAX > ,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAM > ICE235I 0 OPTIONS: NULLOUT=RC0 > ICE750I 0 DC 0 TC 0 CS DSVXX KSZ 32 VSZ 32 > ICE752I 0 FSZ=4979426640 RE IGN=0 C AVG=70 70 WSP=452719355 E > DYN=0 0 > ICE121A 7 FILE SIZE IS TOO LARGE > ICE751I 1 D8-Q83041 D4-Q84357 E8-BASE > ICE052I 0 END OF DFSORT > > > Best regards > Manshadi > > > > ________________________________ > From: David Betten <bet...@us.ibm.com> > To: IBM-MAIN@LISTSERV.UA.EDU > Sent: Monday, October 8, 2012 4:05 PM > Subject: Re: Reorganizing Partition Table Space With REBALANCE Option Problem. > > You need to look at the sort messages to determine why the sort failed. If > you want, send the entire joblog to the DFSORT hot line (dfs...@us.ibm.com) > and we can look it over for you. > > > Have a nice day, > Dave Betten > DFSMS Performance Engineer > IBM Corporation > email: bet...@us.ibm.com > 1-301-240-3809 > DFSORT/MVSontheweb at http://www.ibm.com/storage/dfsort/ > > IBM Mainframe Discussion List <IBM-MAIN@listserv.ua.edu> wrote on > 10/08/2012 08:03:35 AM: > > > From: Mehrshad Manshadi <m_mansh...@yahoo.com> > > To: IBM-MAIN@listserv.ua.edu, > > Date: 10/08/2012 08:06 AM > > Subject: Reorganizing Partition Table Space With REBALANCE Option > Problem. > > Sent by: IBM Mainframe Discussion List <IBM-MAIN@listserv.ua.edu> > > > > Hi, > > > > We have a table space with 250 partition and 4,600,000,000 records > > which it's have to re partition. > > > > Because of lack space on the DASD we are trying to use Tape on some > > DD cards as follows : > > > > //SYSREC DD DSN=TEMPDS.TAPE1,DISP=(MOD,CATLG), > > // UNIT=CART,RETPD=36,BLKSIZE=0,LABEL=(,SL) > > //SYSUT1 DD DSN=TEMPDS.TAPE2,DISP=(NEW,CATLG), > > // UNIT=CART,RETPD=36,BLKSIZE=0,LABEL=(,SL) > > //SORTOUT DD > DSN=TEMPDS.TAPE3,DISP=(NEW,CATLG), > > // UNIT=CART,RETPD=36,BLKSIZE=0,LABEL=(,SL) > > //SYSCOPY DD DSN=TEMPDS.TAPE4,DISP=(NEW,CATLG), > > // UNIT=CART,RETPD=36,BLKSIZE=0,LABEL=(,SL) > > > > We are using 123 work data sets as follows : > > > > //SORTWK01 DD DISP=(NEW,DELETE),UNIT=SYSDA, // > > SPACE=(CYL,(4300,1000),RLSE), // > > VOL=(,,,180),STORCLAS=SCLARGE > > //SORTWK02 DD DISP=(NEW,DELETE),UNIT=SYSDA, // > > SPACE=(CYL,(4300,1000),RLSE), // > > VOL=(,,,180),STORCLAS=SCLARGE > > //SORTWK03 DD DISP=(NEW,DELETE),UNIT=SYSDA, // > > SPACE=(CYL,(4300,1000),RLSE), // > VOL=(,,,180),STORCLAS=SCLARGE > > > > . > > . > > . > > . > > . > > . > > //SORTWK4F DD DISP=(NEW,DELETE),UNIT=SYSDA, // > > SPACE=(CYL,(4300,1000),RLSE), // > > VOL=(,,,180),STORCLAS=SCLARGE > > > > And the reorg options as follows : > > > > //DFSPARM DD * > > OPTION MOSIZE=0 > > //DSNUPROC.SYSIN DD * > > REORG TABLESPACE QQBANCS.TSINHO REBALANCE > > LOG NO SORTDATA SORTDEVT SYSDA SORTNUM 4 > > COPYDDN(SYSCOPY) > > /* > > > > The problem is the unload phase cont the number of records which we > > expected and after this we assume that it should be switch to next > > step , but the job failed with following error: > > > > DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = ROINHORB DSNUGTIS - > PROCESSING SYSIN AS EBCDIC > > DSNUGUTC - REORG TABLESPACE QQBANCS.TSINHO REBALANCE LOG NO > > SORTDATA > > > > DSNUGSRT - ERROR FROM SORT COMPONENT RC=16, UTILITY STOPPED DSNUGBAC > > - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40005' > > > > Please help if you have any idea about it. > > > > Best regards > > Manshadi > > > > -------------------------------------------------------------------- > > -- 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 > ---------------------------------------------------------------------- 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 ATTENTION: ----- The information contained in this message (including any files transmitted with this message) may contain proprietary, trade secret or other confidential and/or legally privileged information. Any pricing information contained in this message or in any files transmitted with this message is always confidential and cannot be shared with any third parties without prior written approval from Syncsort. This message is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any use, disclosure, copying or distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and/or Syncsort and destroy all copies of this message in your possession, custody or control. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
