Re: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K
Hi, If by any chance your ACS routine is defining the dataset as multivolume, the additional entries in catalog, even if not used, will occupy a TIOT slot. Best Regards Ituriel do Nascimento Neto z/OS System Programmer Em segunda-feira, 13 de junho de 2022 09:32:12 BRT, Seymour J Metz escreveu: What size volumes are you using? EAV might help you reduce the number of extents. -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Ron Thomas [ron5...@gmail.com] Sent: Saturday, June 11, 2022 12:14 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K Hello - We are splitting a very large files in to 750 files dynamically based on key , which means if the key changes the file is moved to the respective ones we are getting the message STEPBB - TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K STEPBB - STEP WAS NOT EXECUTED. and hence the step is not getting executed . File LRECL = 500 Key is from position 19,4. Here is the control card used SORT FIELDS=COPY OUTREC IFTHEN=(WHEN=GROUP,KEYBEGIN=(19,4),PUSH=(501:ID=3)) OUTFIL FNAMES=OUT001,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,001) OUTFIL FNAMES=OUT002,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,002) OUTFIL FNAMES=OUT003,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,003) OUTFIL FNAMES=OUT004,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,004) OUTFIL FNAMES=OUT005,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,005) OUTFIL FNAMES=OUT006,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,006) OUTFIL FNAMES=OUT007,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,007) OUTFIL FNAMES=OUT008,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,008) --- -- OUTFIL FNAMES=OUT749,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,749) OUTFIL FNAMES=OUT750,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,750) so could some let me know how to get this fixed ? of is there any other way we can build this one ? Regards Ron T -- 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
Re: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K
What size volumes are you using? EAV might help you reduce the number of extents. -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Ron Thomas [ron5...@gmail.com] Sent: Saturday, June 11, 2022 12:14 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K Hello - We are splitting a very large files in to 750 files dynamically based on key , which means if the key changes the file is moved to the respective ones we are getting the message STEPBB - TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K STEPBB - STEP WAS NOT EXECUTED. and hence the step is not getting executed . File LRECL = 500 Key is from position 19,4. Here is the control card used SORT FIELDS=COPY OUTREC IFTHEN=(WHEN=GROUP,KEYBEGIN=(19,4),PUSH=(501:ID=3)) OUTFIL FNAMES=OUT001,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,001) OUTFIL FNAMES=OUT002,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,002) OUTFIL FNAMES=OUT003,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,003) OUTFIL FNAMES=OUT004,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,004) OUTFIL FNAMES=OUT005,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,005) OUTFIL FNAMES=OUT006,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,006) OUTFIL FNAMES=OUT007,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,007) OUTFIL FNAMES=OUT008,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,008) --- -- OUTFIL FNAMES=OUT749,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,749) OUTFIL FNAMES=OUT750,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,750) so could some let me know how to get this fixed ? of is there any other way we can build this one ? Regards Ron T -- 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
Re: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K
The first job can do one pass of the input to split the output into three files of 250 IDs each. Then run three subsequent jobs concurrently to split the first step output files into the individual files. That is one less pass on the total input. If there is enough TIOT space, an additional variation to try is to split the first 250 IDs in the first job with two additional outputs for groups 251-500 and 501-750. Then run additional jobs to split the additional groups. That can save from having to do a second pass on part of the data. If the OP has enough system resources in the second step, they can consider changing the first step output files to groups of 125 IDs to run additional splits concurrently. HTH Alan From: "Farley, Peter x23353" <031df298a9da-dmarc-requ...@listserv.ua.edu> Sent: Saturday, June 11, 2022 11:35 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K The simple solution is to split the single job into multiple jobs. As a start, put the first 250 into JOB1, the second 250 into JOB2 and the last 250 into JOB3. It means 3 passes of the input file instead of one, but the jobs will run and you will get the result you need. HTH Peter -Original Message- From: IBM Mainframe Discussion List On Behalf Of Ron Thomas Sent: Saturday, June 11, 2022 12:14 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K Hello - We are splitting a very large files in to 750 files dynamically based on key , which means if the key changes the file is moved to the respective ones we are getting the message STEPBB - TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K STEPBB - STEP WAS NOT EXECUTED. and hence the step is not getting executed . File LRECL = 500 Key is from position 19,4. Here is the control card used SORT FIELDS=COPY OUTREC IFTHEN=(WHEN=GROUP,KEYBEGIN=(19,4),PUSH=(501:ID=3)) OUTFIL FNAMES=OUT001,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,001) OUTFIL FNAMES=OUT002,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,002) OUTFIL FNAMES=OUT003,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,003) OUTFIL FNAMES=OUT004,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,004) OUTFIL FNAMES=OUT005,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,005) OUTFIL FNAMES=OUT006,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,006) OUTFIL FNAMES=OUT007,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,007) OUTFIL FNAMES=OUT008,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,008) --- -- OUTFIL FNAMES=OUT749,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,749) OUTFIL FNAMES=OUT750,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,750) so could some let me know how to get this fixed ? of is there any other way we can build this one ? Regards Ron T -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. -- 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
Re: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K
I agree with one of the other posters that this is most likely due to the fact that you either have too many extents or too many eligible volumes for the data sets. On Sat, Jun 11, 2022, 14:36 Farley, Peter x23353 < 031df298a9da-dmarc-requ...@listserv.ua.edu> wrote: > The simple solution is to split the single job into multiple jobs. As a > start, put the first 250 into JOB1, the second 250 into JOB2 and the last > 250 into JOB3. > > It means 3 passes of the input file instead of one, but the jobs will run > and you will get the result you need. > > HTH > > Peter > > -Original Message- > From: IBM Mainframe Discussion List On Behalf > Of Ron Thomas > Sent: Saturday, June 11, 2022 12:14 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K > > Hello - > > We are splitting a very large files in to 750 files dynamically based on > key , which means if the key changes the file is moved to the respective > ones > > > we are getting the message > > STEPBB - TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K STEPBB - STEP WAS NOT > EXECUTED. > > and hence the step is not getting executed . > > File LRECL = 500 Key is from position 19,4. > > Here is the control card used > > SORT FIELDS=COPY > OUTREC IFTHEN=(WHEN=GROUP,KEYBEGIN=(19,4),PUSH=(501:ID=3)) > OUTFIL FNAMES=OUT001,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,001) > OUTFIL FNAMES=OUT002,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,002) > OUTFIL FNAMES=OUT003,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,003) > OUTFIL FNAMES=OUT004,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,004) > OUTFIL FNAMES=OUT005,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,005) > OUTFIL FNAMES=OUT006,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,006) > OUTFIL FNAMES=OUT007,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,007) > OUTFIL FNAMES=OUT008,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,008) > --- > -- > OUTFIL FNAMES=OUT749,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,749) > OUTFIL FNAMES=OUT750,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,750) > > > so could some let me know how to get this fixed ? of is there any other > way we can build this one ? > > > Regards > Ron T > -- > > This message and any attachments are intended only for the use of the > addressee and may contain information that is privileged and confidential. > If the reader of the message is not the intended recipient or an authorized > representative of the intended recipient, you are hereby notified that any > dissemination of this communication is strictly prohibited. If you have > received this communication in error, please notify us immediately by > e-mail and delete the message and any attachments from your system. > > > -- > 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
Re: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K
The simple solution is to split the single job into multiple jobs. As a start, put the first 250 into JOB1, the second 250 into JOB2 and the last 250 into JOB3. It means 3 passes of the input file instead of one, but the jobs will run and you will get the result you need. HTH Peter -Original Message- From: IBM Mainframe Discussion List On Behalf Of Ron Thomas Sent: Saturday, June 11, 2022 12:14 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K Hello - We are splitting a very large files in to 750 files dynamically based on key , which means if the key changes the file is moved to the respective ones we are getting the message STEPBB - TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K STEPBB - STEP WAS NOT EXECUTED. and hence the step is not getting executed . File LRECL = 500 Key is from position 19,4. Here is the control card used SORT FIELDS=COPY OUTREC IFTHEN=(WHEN=GROUP,KEYBEGIN=(19,4),PUSH=(501:ID=3)) OUTFIL FNAMES=OUT001,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,001) OUTFIL FNAMES=OUT002,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,002) OUTFIL FNAMES=OUT003,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,003) OUTFIL FNAMES=OUT004,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,004) OUTFIL FNAMES=OUT005,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,005) OUTFIL FNAMES=OUT006,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,006) OUTFIL FNAMES=OUT007,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,007) OUTFIL FNAMES=OUT008,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,008) --- -- OUTFIL FNAMES=OUT749,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,749) OUTFIL FNAMES=OUT750,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,750) so could some let me know how to get this fixed ? of is there any other way we can build this one ? Regards Ron T -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K
You could do it with a small assembler or cobol program with dynamic allocation dependent on your data. Bin unterwegs hab nur iPhone zur Verfügung. > Am 11.06.2022 um 06:39 schrieb Michael Oujesky : > > Failing in allocation. Going to have to use fewer output files in a single > step. > > Michael > > > At 11:14 PM 6/10/2022, Ron Thomas wrote: > >> Hello - >> >> We are splitting a very large files in to 750 files dynamically based on key >> , which means if the key changes the file is moved to the respective ones >> >> >> we are getting the message >> >> STEPBB - TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K >> STEPBB - STEP WAS NOT EXECUTED. >> >> and hence the step is not getting executed . >> >> File LRECL = 500 Key is from position 19,4. >> >> Here is the control card used >> >> SORT FIELDS=COPY >> OUTREC IFTHEN=(WHEN=GROUP,KEYBEGIN=(19,4),PUSH=(501:ID=3)) >> OUTFIL FNAMES=OUT001,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,001) >> OUTFIL FNAMES=OUT002,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,002) >> OUTFIL FNAMES=OUT003,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,003) >> OUTFIL FNAMES=OUT004,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,004) >> OUTFIL FNAMES=OUT005,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,005) >> OUTFIL FNAMES=OUT006,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,006) >> OUTFIL FNAMES=OUT007,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,007) >> OUTFIL FNAMES=OUT008,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,008) >> --- >> -- >> OUTFIL FNAMES=OUT749,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,749) >> OUTFIL FNAMES=OUT750,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,750) >> >> >> so could some let me know how to get this fixed ? of is there any other way >> we can build this one ? >> >> >> Regards >> Ron T >> >> -- >> 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
Re: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K
>> we are getting the message STEPBB - TASK I/O TABLE EXCEEDS TIOT LIMIT OF >> 0064K STEPBB - STEP WAS NOT EXECUTED. Ron, Are your output files writing to a tape? If you are writing to DASD then you shouldn't have any issue. Your shop seems to have TIOT limit of 64 which should allow 3273 dd statements. Your job is only writing 750 files which should be within the limits. Maximum number of DDs allowed when every DD Maximum number requests the SIZE Valueof single Unitmaximum number Dec (Hex)Size of TIOT DDs allowed of units (59) = = === 16 10 16384 (16K) 819 64 24 18 24576 (24K)1226 97 32 20 32768 (32K)1635 129 40 28 40960 (40K)2045 162 48 30 49152 (48K)2454 194 56 38 57344 (56K)2864 227 64 40 65536 (64K)3273 259 Thanks, Kolusu DFSORT Development -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K
https://www.ibm.com/support/pages/tiot-space-and-dynvol TIOT size is modifyable up to 64K in PARMLIB(ALLOCxx), which you have already done. >> The TIOT size is specified in the ALLOCxx PARMLIB member and has a default of 32K. This is sufficient for 1635 data sets on a single volume and 129 data sets with the maximum of 59 volumes defined. So, reduce the number of datasets to 129 with 59 volumes each, or limit volumes so 1635 datasets of 1 volume can be used, or something in between. With 64K TIOT about 250 datasets with 59 volumes should work, maybe a little less, depending on how many other DDNAMEs are in the job. Maybe defrag the datasets so they are on fewer volumes? Reduce candidate volumes from allocation or ALTER DSN(/) REMOVEVOLUMES(*)? Maybe examine each file and extract the changed keys to 1 dataset, sort them by data set order, then insert into the new dataset? Maybe change the transaction that changes the key to write to the new dataset instead of updating the old dataset? On Fri, Jun 10, 2022 at 11:14 PM Ron Thomas wrote: > > Hello - > > We are splitting a very large files in to 750 files dynamically based on key > , which means if the key changes the file is moved to the respective ones > > > we are getting the message > > STEPBB - TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K > STEPBB - STEP WAS NOT EXECUTED. > > and hence the step is not getting executed . > > File LRECL = 500 Key is from position 19,4. > > Here is the control card used > > SORT FIELDS=COPY > OUTREC IFTHEN=(WHEN=GROUP,KEYBEGIN=(19,4),PUSH=(501:ID=3)) > OUTFIL FNAMES=OUT001,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,001) > OUTFIL FNAMES=OUT002,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,002) > OUTFIL FNAMES=OUT003,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,003) > OUTFIL FNAMES=OUT004,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,004) > OUTFIL FNAMES=OUT005,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,005) > OUTFIL FNAMES=OUT006,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,006) > OUTFIL FNAMES=OUT007,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,007) > OUTFIL FNAMES=OUT008,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,008) > --- > -- > OUTFIL FNAMES=OUT749,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,749) > OUTFIL FNAMES=OUT750,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,750) > > > so could some let me know how to get this fixed ? of is there any other way > we can build this one ? > > > Regards > Ron T > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Mike A Schwab, Springfield IL USA Where do Forest Rangers go to get away from it all? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K
Failing in allocation. Going to have to use fewer output files in a single step. Michael At 11:14 PM 6/10/2022, Ron Thomas wrote: Hello - We are splitting a very large files in to 750 files dynamically based on key , which means if the key changes the file is moved to the respective ones we are getting the message STEPBB - TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K STEPBB - STEP WAS NOT EXECUTED. and hence the step is not getting executed . File LRECL = 500 Key is from position 19,4. Here is the control card used SORT FIELDS=COPY OUTREC IFTHEN=(WHEN=GROUP,KEYBEGIN=(19,4),PUSH=(501:ID=3)) OUTFIL FNAMES=OUT001,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,001) OUTFIL FNAMES=OUT002,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,002) OUTFIL FNAMES=OUT003,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,003) OUTFIL FNAMES=OUT004,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,004) OUTFIL FNAMES=OUT005,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,005) OUTFIL FNAMES=OUT006,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,006) OUTFIL FNAMES=OUT007,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,007) OUTFIL FNAMES=OUT008,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,008) --- -- OUTFIL FNAMES=OUT749,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,749) OUTFIL FNAMES=OUT750,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,750) so could some let me know how to get this fixed ? of is there any other way we can build this one ? Regards Ron T -- 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
Re: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K
Hi edjaffe - I am not sure how to make that changes in then job . would you be able to let me know what changes i should make in the job ? Thanks Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K
On 6/10/2022 9:14 PM, Ron Thomas wrote: Hello - We are splitting a very large files in to 750 files dynamically based on key , which means if the key changes the file is moved to the respective ones we are getting the message STEPBB - TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K STEPBB - STEP WAS NOT EXECUTED. Is there no way to dynamically-allocate the files and have DFSORT use XTIOT entries instead of the normal TIOT? -- Phoenix Software International Edward E. Jaffe 831 Parkview Drive North El Segundo, CA 90245 https://www.phoenixsoftware.com/ This e-mail message, including any attachments, appended messages and the information contained therein, is for the sole use of the intended recipient(s). If you are not an intended recipient or have otherwise received this email message in error, any use, dissemination, distribution, review, storage or copying of this e-mail message and the information contained therein is strictly prohibited. If you are not an intended recipient, please contact the sender by reply e-mail and destroy all copies of this email message and do not otherwise utilize or retain this email message or any or all of the information contained therein. Although this email message and any attachments or appended messages are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by the sender for any loss or damage arising in any way from its opening or use. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K
Hello - We are splitting a very large files in to 750 files dynamically based on key , which means if the key changes the file is moved to the respective ones we are getting the message STEPBB - TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K STEPBB - STEP WAS NOT EXECUTED. and hence the step is not getting executed . File LRECL = 500 Key is from position 19,4. Here is the control card used SORT FIELDS=COPY OUTREC IFTHEN=(WHEN=GROUP,KEYBEGIN=(19,4),PUSH=(501:ID=3)) OUTFIL FNAMES=OUT001,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,001) OUTFIL FNAMES=OUT002,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,002) OUTFIL FNAMES=OUT003,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,003) OUTFIL FNAMES=OUT004,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,004) OUTFIL FNAMES=OUT005,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,005) OUTFIL FNAMES=OUT006,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,006) OUTFIL FNAMES=OUT007,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,007) OUTFIL FNAMES=OUT008,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,008) --- -- OUTFIL FNAMES=OUT749,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,749) OUTFIL FNAMES=OUT750,BUILD=(1,500),INCLUDE=(501,3,ZD,EQ,750) so could some let me know how to get this fixed ? of is there any other way we can build this one ? Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
