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
 
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

Senior Member


Joined: 14 Mar 2007
Posts: 10478
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 Not able to export the VSAM cluster sandeep kumar302 JCL & VSAM 6 Fri May 04, 2018 12:42 pm
No new posts IDCAMS RENAMING VSAM FILE ALONG WITH ... upendrasri JCL & VSAM 12 Tue Apr 17, 2018 10:42 pm
No new posts VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm
No new posts VSAM - Accessing beyond record size Benchwarmer JCL & VSAM 6 Wed Apr 11, 2018 9:20 pm
No new posts VSAM File free space sancraig16 JCL & VSAM 14 Fri Mar 30, 2018 1:02 am

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