Yes I had meant 800,000 (close to 80 times more EXCP from with the internal sort)
-----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Gary Green Sent: Tuesday, March 27, 2007 12:17 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Cobol Internal sort and DLI Databases Not that I have an answer but I wanted to confirm that you really meant 800,000 EXCP's and not 800,000,000 EXCP's. Correct? (800,000k = 800,000,000) On Tue Mar 27 11:46 , GAVIN Darren * OPS EAS <[EMAIL PROTECTED]> sent: >Does anyone know why when an Internal Sort is performed while a program >also accessing a DLI Database That the amount of I/O against DLI >increases by a few orders of magnitude? > > > >I had a program extracting data off a DLI Database inside a Sort Input >phase. It was extracting only 181 records form 60,000 DLI Segments, but >taking over 800,000K EXCP I/O and 10 minutes. > > > >When I instead just wrote the Sort Record to a Flat file and Eliminated >the sort completely, It extract the same records, but only took 11,000 >EXCP I/O and about 5 seconds. > > > >Thanks, > > > >Darren > > >---------------------------------------------------------------------- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO >Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html