VSAM access faster than DB2 access

vighnesh_r · New User Joined: 23 Aug 2006 Posts: 14

Hi,

Can anyone please tell me which access method will be better ... accessing data from VSAM or from DB2.

Any supporting document, links will also be very helpful

stodolas · Posted: Tue Mar 25, 2008 5:48 pm Post subject:

The answer is and will always be "It depends on too many shop specific factors to give you the correct answer for your situation"

Gnanas SNG · Posted: Tue Mar 25, 2008 6:18 pm Post subject:

This link might give some ideas about Why DB2 is better than VSAM...

vighnesh_r · New User Joined: 23 Aug 2006 Posts: 14

Let me clarify the position a bit.
I have to decide between taking a dump of a few tables onto a VSAM or accessing those tables multiple times for my processing.

In this case, i feel that given the large no. of transactions i will be better off taking a dump and then using the VSAM rather than querying the DB multiple times.

The basic question is this, for a single search which is faster a key sequenced VSAM or a DB search. any inputs will be valuable

TIA

dbzTHEdinosauer · Posted: Thu Mar 27, 2008 1:12 pm Post subject:

too much depends on the type of box you have, what releases of cobol and db2 you have, what op-sys are you running?.

also, sounds as if a match merge is a possible solution.

plus, what kind of updating is required?

dick scherrer · Posted: Thu Mar 27, 2008 7:46 pm Post subject:

Hello,