View previous topic :: View next topic
|
Author |
Message |
haidude
New User
Joined: 11 May 2007 Posts: 10 Location: Mumbai
|
|
|
|
I have faced one interview in this below question.Why 2 databases in a single application(DB2 and Vsam),why not one database(either DB2 or Vsam)? |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
VSAM is not a database; It is an Access Method.
Do you know that DB2 keeps its data in VSAM files?
O. |
|
Back to top |
|
|
haidude
New User
Joined: 11 May 2007 Posts: 10 Location: Mumbai
|
|
|
|
I am agree with ur post but my question is why most of the Mainfrae application contain Db2 and Vsam,is there any specific reason? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Quote: |
VSAM is not a database; It is an Access Method.
Do you know that DB2 keeps its data in VSAM files? |
Another way of putting this, is that VSAM is an access method, a way to access the data, and VSAM structured file can be used to store DB2, IMS, CICS, and more, not only DB2. |
|
Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Hi Ofer71
Quote: |
VSAM is not a database; It is an Access Method.
Do you know that DB2 keeps its data in VSAM files? |
Expact
Quote: |
Another way of putting this, is that VSAM is an access method, a way to access the data, and VSAM structured file can be used to store DB2, IMS, CICS, and more, not only DB2. |
Can I know the real time exmples ot situation we use VSAM to store the data. I read this. But I never get a chance to work on VSAM till now. Please clarify my doubt. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
There are millions of VSAM files around the world that are 10 -25 years old. Actually, in many places, the vsam environment is managed as a database environment - there just is no rdbms.
Many organizations have decided to implement new systems or upgrade older systems to take advantage of database technology. Often these new/upgraded systems still need to interact with existing systems.
If is very common for an application to use both vsam and database in the same code. |
|
Back to top |
|
|
|