|
View previous topic :: View next topic
|
| Author |
Message |
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  |
|
| Back to top |
|
 |
stodolas
Active Member
Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin
|
|
|
|
| The answer is and will always be "It depends on too many shop specific factors to give you the correct answer for your situation" |
|
| Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
| Back to top |
|
|
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 |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
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? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| Let me clarify the position a bit. |
More clarification would be good. . .
| Quote: |
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 |
Why do you suspect that multiple vsam accesses will perform better than database accesses?
| Quote: |
| which is faster a key sequenced VSAM or a DB search |
Is the db2 access also via key? If not, maybe it should be.
If you more clearly explain your requirement (show some data examples) we can probably offer more usable suggestions. As was suggested, you may only need a simple match/merge. |
|
| Back to top |
|
|
|
|
