I think FOCUS database is built over a BDAM file. However, I/O could still be an issue...
At the risk of sounding dumb, have you contacted IBI customer support? There are some FOCWizards there who might be able to shed some light. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Larry Crilley Sent: Thursday, March 18, 2010 9:55 AM To: [email protected] Subject: Re: Any FOCUS performance guru's here? I don't know much about FOCUS, and we don't run it here, but does it use LSR to process the VSAM files? Is it possible the size of the LSR pool built by FOCUS needs to be increased due to the added data? In other words, since you have more data, has the random access pattern (assuming FOCUS does DIRECT I/O to the VSAM files) exceeded a threshold and you now have some buffer thrashing within an LSR pool? Really just guessing here... -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Dana Sent: Thursday, March 18, 2010 9:33 AM To: [email protected] Subject: Re: Any FOCUS performance guru's here? Dave, thanks for the response. Here's answers to your questions: > >When you say "starting to run a really long time," does that mean >suddenly or progressively over time? > Suddenly. These are weekly jobs and last month the elapsed time really jumped. The only difference according to the application folks, is just more data, approximately 10% added. The main database is not huge (4500 trks). >Are you running FOCUS interactively (TSO) or from a remote client? >Does your job contain the FOCUS code, or does it call an RPC? > Not sure what you mean. It's just a batch job, EXEC PGM=FOCUS, the SYSIN DD contains: EX <focuspgm> FIN >Are you using the FOCUS SVC, or the IBI subsystem? > Subsystem >Have you upgraded FOCUS recently or installed a new release in parallel? > No >Is your data in a FOCUS database, or are you using an adapter to >another data source? > Focus Database >What sort of performance measurements do you have to compare with and without FOCSU? > Elapsed wall clock time. >Regards, >Dave Barry Thanks for any ideas you might have! Dana ---------------------------------------------------------------------- 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
