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
 

 

Need for VSAM files when there is a Db2 table

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

New User


Joined: 07 Dec 2007
Posts: 26
Location: Bangalore

PostPosted: Mon Dec 31, 2007 1:36 pm    Post subject: Need for VSAM files when there is a Db2 table
Reply with quote

Why do we have to use a VSAM file when we can use a DB2 table. ? .
Back to top
View user's profile Send private message

stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Wed Jan 02, 2008 9:36 pm    Post subject:
Reply with quote

You don't have to use a VSAM, but some shops still prefer them to DB2.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Wed Jan 02, 2008 9:51 pm    Post subject: Re: Need for VSAM files when there is a Db2 table
Reply with quote

Aniyaa wrote:
Why do we have to use a VSAM file when we can use a DB2 table. ? .


Cost! It cost more to use DB2 and you may have existing processes that use VSAM and the users don't want the extra cost to convert them.
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Wed Jan 02, 2008 9:54 pm    Post subject:
Reply with quote

Its can also be a big pain in the neck to develop against DB2. Shops will usually allow developers to create their own VSAM for testing with, but they will only let DBAs create new tables or alter tables after going through a design process. My shop is still heavily VSAM for just that reason. Using DB2 would slow development and testing to almost a crawl.
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 Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
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 VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm


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