Dear Experts ,
In the existing system--- Repro is done on a Vsam file into a PS and PS is input to program.
Proposed Future state --- suggests to use VSAM KSDS directly as input to program for sequential access.
We have astronomical volume of data (bank), and there are 3 such files as input to the program.
I would want to know which of the above two performs better
Would syncsort for copy and then PS as input give better performance than both of the above.
Please suggest.
KSDS vs PS for sequential access
Moderator: Moderator Group
- dbzTHEdinosauer
- Moderator
- Posts: 981
- Joined: Mon Oct 02, 2006 8:31 pm
Repro is known to be slower than sort.
have you insured that you had large blocksize output
have you increased the DD BUFFNO parm for the program reading the PS.
you can increase ksds reads by amp parm
the idea is to reduce hardware I/O.
so you have to find a balance where copying/processing is faster that reading the ksds directly, since the ksds is somewhat delimited by ci/ca size.
would suggest you refer to VSAM Demystified Redbook
you have to experiment and test.
on a more rational note:
you have to be doing something really wrong
if a repro and process ps is faster than just reading the ksds.
have you insured that you had large blocksize output
have you increased the DD BUFFNO parm for the program reading the PS.
you can increase ksds reads by amp parm
the idea is to reduce hardware I/O.
so you have to find a balance where copying/processing is faster that reading the ksds directly, since the ksds is somewhat delimited by ci/ca size.
would suggest you refer to VSAM Demystified Redbook
you have to experiment and test.
on a more rational note:
you have to be doing something really wrong
if a repro and process ps is faster than just reading the ksds.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
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