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: 10256
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 VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
No new posts Need inputs on Space requirement and... ashek15 IMS DB/DC 0 Sat Apr 01, 2017 8:26 am
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts SORT requirement sjiraga COBOL Programming 6 Thu Mar 09, 2017 9:11 pm


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