Re: VSAM Performance - CPU reduction

2018-01-08 Thread Arun Venkatratnam
Hi Ron and all, I have captured the strobe report for the full run of the job. I will try to send it to later. In addition to strobe, i snapped the below statistics of the job from Mainview. The report shows that the EXCP and the SSCH counts are almost equal. I am of the understanding that if

Re: VSAM Performance - CPU reduction

2018-01-08 Thread Arun Venkatratnam
Ron, The job was not profiled for its entire run. All 32M records are read from the 1st file and 80% will qualify from the 2nd file. The job was profiled to capture 4000 samples in an elapsed time of 3 minutes. As I had mentioned in my initial post, the job takes nearly 7 minutes of CPU. The pr

Re: VSAM Performance - CPU reduction

2018-01-07 Thread Arun Venkatratnam
Thanks Ron for the CI calculation, I have sent you the strobe report. Thanks Arun -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: VSAM Performance - CPU reduction

2018-01-07 Thread Arun Venkatratnam
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.

Re: VSAM Performance - CPU reduction

2018-01-06 Thread Arun Venkatratnam
1. Have you looked at adding STRNO on the VSAM definition or using RLS to provide the records to be instorage? No, STRNO is not provided explicitly in the VSAM file definition.Strobe apparently shows the number of Strings is 48. RLS is also not used. 2. In your JCL for the job, have you coded B

Re: VSAM Performance - CPU reduction

2018-01-06 Thread Arun Venkatratnam
DATASET-OWNER-(NULL) CREATION2018.005 RELEASE2 EXPIRATION--.000 SMSDATA STORAGECLASS -SCTEST MANAGEMENTCLASS---M

Re: VSAM Performance - CPU reduction

2018-01-05 Thread Arun Venkatratnam
Just to be clear. The similar behavior i am referring to is the strobe report listing QSAM INIT I/O & EXITS and PARTITION COMMUNICATION as the top CPU contributors. -- For IBM-MAIN subscribe / signoff / archive access instructi

Re: VSAM Performance - CPU reduction

2018-01-05 Thread Arun Venkatratnam
Apologies. I missed to mention that depending on a record that matches in the 2nd file, there are some random reads that refer back to a previous record as per the business logic. Hence, the second file has to be VSAM. We also see a similar behavior with few other programs that do skip sequentia

VSAM Performance - CPU reduction

2018-01-05 Thread Arun Venkatratnam
Hi All, We are looking to improve the performance of a COBOL program that processes 2 VSAM files. The first file is the I/P file and every record read from the input VSAM file is searched for a matching record in the other file and a report is written. The program also applies some business rul