Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
VSAM access faster than DB2 access

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
vighnesh_r

New User


Joined: 23 Aug 2006
Posts: 14

PostPosted: Tue Mar 25, 2008 12:08 pm    Post subject: VSAM access faster than DB2 access
Reply with quote

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 icon_smile.gif
Back to top
View user's profile Send private message

stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Tue Mar 25, 2008 5:48 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 788
Location: Chennai, India

PostPosted: Tue Mar 25, 2008 6:18 pm    Post subject:
Reply with quote

This link might give some ideas about Why DB2 is better than VSAM...
Back to top
View user's profile Send private message
vighnesh_r

New User


Joined: 23 Aug 2006
Posts: 14

PostPosted: Thu Mar 27, 2008 11:38 am    Post subject: VSAM access faster than DB2 access : updated
Reply with quote

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 icon_smile.gif

TIA
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6970
Location: porcelain throne

PostPosted: Thu Mar 27, 2008 1:12 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Mar 27, 2008 7:46 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts User access certification In Mainfram... Virendra Shambharkar All Other Mainframe Topics 4 Tue Oct 03, 2017 12:32 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us