No it will not. You need to find a way to break this up so the utility is not sorting over 4294967295 variable length records.
Have a nice day, Dave Betten DFSMS Performance Engineer IBM Corporation email: [email protected] 1-301-240-3809 DFSORT/MVSontheweb at http://www.ibm.com/storage/dfsort/ IBM Mainframe Discussion List <[email protected]> wrote on 10/09/2012 02:39:06 AM: > From: Mehrshad Manshadi <[email protected]> > To: [email protected], > Date: 10/09/2012 02:41 AM > Subject: Re: Reorganizing Partition Table Space With REBALANCE Option Problem. > Sent by: IBM Mainframe Discussion List <[email protected]> > > Hi David, > > Thanks for your useful information. > > So The APAR PM43006 will solve our problem? Am I right? > > Best regards > Manshadi > > > > > ________________________________ > From: David Betten <[email protected]> > To: [email protected] > 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: [email protected] > 1-301-240-3809 > DFSORT/MVSontheweb at http://www.ibm.com/storage/dfsort/ > > IBM Mainframe Discussion List <[email protected]> wrote on > 10/08/2012 10:10:10 AM: > > > From: Mehrshad Manshadi <[email protected]> > > To: [email protected], > > Date: 10/08/2012 10:11 AM > > Subject: Re: Reorganizing Partition Table Space With REBALANCE Option > Problem. > > Sent by: IBM Mainframe Discussion List <[email protected]> > > > > 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 <[email protected]> > > To: [email protected] > > 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 > ([email protected]) > > and we can look it over for you. > > > > > > Have a nice day, > > Dave Betten > > DFSMS Performance Engineer > > IBM Corporation > > email: [email protected] > > 1-301-240-3809 > > DFSORT/MVSontheweb at http://www.ibm.com/storage/dfsort/ > > > > IBM Mainframe Discussion List <[email protected]> wrote on > > 10/08/2012 08:03:35 AM: > > > > > From: Mehrshad Manshadi <[email protected]> > > > To: [email protected], > > > Date: 10/08/2012 08:06 AM > > > Subject: Reorganizing Partition Table Space With REBALANCE Option > > Problem. > > > Sent by: IBM Mainframe Discussion List <[email protected]> > > > > > > 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 [email protected] with the message: INFO IBM-MAIN > > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to [email protected] with the message: INFO IBM-MAIN > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to [email protected] with the message: INFO IBM-MAIN > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
