Gerhard, He has BUFNI=120, so I don't think the occasional misses on the 2nd level index set are a root cause.
It would show up in strobe as high IO to the index rather than data component, or he has, I hope, looked at the type 64 and 42 subtype 6 records. Ron -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Gerhard Adam Sent: Sunday, January 7, 2018 11:04 AM To: [email protected] Subject: Re: [IBM-MAIN] VSAM Performance - CPU reduction To me it still looks like you don't have enough index buffers. My calculation suggests you need at least 137 buffers to keep the index set in memory. Sent from my iPhone > On Jan 7, 2018, at 10:21 AM, Arun Venkatratnam <[email protected]> wrote: > > Ron, > > About 80% of the records qualify from the second file. I tried running the job with BUFND of 2 for the second file. It increased the EXCPs significantly (from strobe report) on the data records for the 2nd file and the CPU time went over the other runs and the elapsed time also increased. The job runs better with higher values of BUFND for the second file. > > You had mentioned that the job reads 30 CI for every skip-seq access. Could you please tell how did you arrive at that number. LISTCAT shows that for a CISZ of 26KB, there are 30 CI in 1 CA. > > > Thanks > Arun > > ---------------------------------------------------------------------- > 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
