Hello,
Good day!
I need suggestion on below issue, Please advise me..
One COBOL Program using MQ and it Executing for 25 to 30 mins everyday in Cycle run. This causing to performance issue.
Coming Issue, Program will use 1 PS file( This is a driver file), 2 VSAM files( One is Date file and another is Main file) and Have defined Control card with MQ name included in it. Every day Driver file will have 1 to 2 lakh records for processing thru MQ. JCL is taking 25 to 30mins to Complete.
To increase performance i have introduced a sort step before this program execution and reduced 50K to 70K records for processing, But there is time NO difference in the JCL execution. PLEASE SUGGEST ME ON THIS?
Here is my program flow,
House Keeping:: Here Files will be open and Accepting System Date.
Connect MQ
Open MQ
Read I/P file
Main Processing
Final Message
COMMIT MQ
Update Restart
DB2 COMMIT
Close MQ
Disconnect MQ
End of Prog
Let me if more details needed.
Please advice me to speed up the JCL execution..
Thank you!
[/b]
Performance tune of a Cobol program which uses MQ!!
Moderator: Moderator Group
Let's be clear (and pedantic) here: the JCL is finished before the JOB even starts.
25-30 minutes is not necessarily a long time - you are processing quite a few records - I don not know how many a lakh is - it is non-standard terminology - and you are using technologies that can take a bit of time to do what is being requested (SQL in DB2). Also, you do not say anything about the buffering that you use for your sequential file or blocksize or anything about your VSAM definitions. In fact - it could all be highly tuned or very untuned but you have notgiven any indications of how anything is tuned except that you have reduced your sequential (presumably) file by a number of records presumably by use of INCLUDE, EXCLUDE or OMIT in sort.
25-30 minutes is not necessarily a long time - you are processing quite a few records - I don not know how many a lakh is - it is non-standard terminology - and you are using technologies that can take a bit of time to do what is being requested (SQL in DB2). Also, you do not say anything about the buffering that you use for your sequential file or blocksize or anything about your VSAM definitions. In fact - it could all be highly tuned or very untuned but you have notgiven any indications of how anything is tuned except that you have reduced your sequential (presumably) file by a number of records presumably by use of INCLUDE, EXCLUDE or OMIT in sort.
Regards
Nic
Nic
I believe what you have identified is that the 50-70k records removed were not contributing to the "excessive" run time. . .
Knowing the program flow is not nearly as important as knowing what the program is actually doing. How many records are being read/written in the qsam and vsam files? How many rows need to be "touched" in the database for the run or for individual iteratons? What does an EXPLAIN of the queries being used show?
Why does someone believe there is an issue with MQ?. What happens if you run an experiment where MQ is not used just to see the timing difference?
Knowing the program flow is not nearly as important as knowing what the program is actually doing. How many records are being read/written in the qsam and vsam files? How many rows need to be "touched" in the database for the run or for individual iteratons? What does an EXPLAIN of the queries being used show?
Why does someone believe there is an issue with MQ?. What happens if you run an experiment where MQ is not used just to see the timing difference?
Have a good one
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page