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

Global Moderator


Joined: 14 Mar 2007
Posts: 10374
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 Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
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

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