View previous topic :: View next topic
|
Author |
Message |
Aniyaa
New User
Joined: 07 Dec 2007 Posts: 26 Location: Bangalore
|
|
|
|
Why do we have to use a VSAM file when we can use a DB2 table. ? . |
|
Back to top |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
You don't have to use a VSAM, but some shops still prefer them to DB2. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
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 |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
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 |
|
|
|