Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 or VSAM ? Which one is effective for my requirement?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Vijay Subramaniyan

New User


Joined: 06 Jul 2011
Posts: 15
Location: india

PostPosted: Mon Apr 16, 2012 4:15 pm    Post subject: DB2 or VSAM ? Which one is effective for my requirement?
Reply with quote

Hi ,

My client has 65 million accounts to be processed. The accounts count may increase while the batch runs daily . My requirement is such that I need to display the reporting history for the last two reporting periods on a CICS screen,for a particular account. Hence I need to save the details for every account that comes in batch .

Which one is preferrabe in this case ? VSAM or a DB2 table ? Is there anything that lies as a problem of using a Table for this (CPU consumption, or some overheads ) ?
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Mon Apr 16, 2012 4:22 pm    Post subject: Reply to: DB2 or VSAM ? Which one is effective for my requir
Reply with quote

since ...
we do not belong to Your client/organization,
we do not know anything about the client application design
we do not know anything about Your client/organization standards
we do not ....
we do not ....
we do not ....

and since, from Your profile ...
Quote:
Employer :TCS

spending time giving advice un such a problem at the end will result in a waste of time for everybody !

and furthermore we will be doing at no charge
the work for which Your organization is getting paid for

ask Your colleagues! icon_evil.gif
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: Mon Apr 16, 2012 9:14 pm    Post subject:
Reply with quote

Hello,

Quote:
Which one is preferrabe in this case ? VSAM or a DB2 table ? Is there anything that lies as a problem of using a Table for this (CPU consumption, or some overheads ) ?
As this appears to be something "long-term" you might consider implementing both and running some performance tests that reflect the "real work" to be done.

As Enrico mentioned, we know basically nothing about the client environment, so specific suggestions will be less likely.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fail to change physical VSAM filename... jacobdng CICS 6 Fri Jan 20, 2017 12:36 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
This topic is locked: you cannot edit posts or make replies. Mainframe Developer requirement in Ku... capricorn Mainframe Jobs 0 Sun Oct 23, 2016 3:49 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us