KSDS vs PS for sequential access

Post your questions related to VSAM

Moderator: Moderator Group

Post Reply
mfkseek
Member
Posts: 1
Joined: Fri Aug 06, 2010 1:31 am
Location: India

KSDS vs PS for sequential access

Post by mfkseek » Fri Aug 06, 2010 2:08 am

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.

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Fri Aug 06, 2010 2:41 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.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

Post Reply

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



Other References
Mainframe Tools and others