VSAM vs DB2 - Which is better to use and why

richa.setia · New User Joined: 23 Mar 2005 Posts: 10 Location: Noida

Please let me know out of VSAM and DB2, which is better to use and why?

avalanches · New User Joined: 10 May 2005 Posts: 28

Hi,

Using either VSAM or DB2 purely based on one's application's needs. Even though the basic representation in DB2 is in VSAM!

Cheers,
avalanches.

avalanches · New User Joined: 10 May 2005 Posts: 28

Hi,

Using either VSAM or DB2 purely based on one's application's needs. Even though the basic representation in DB2 is in VSAM!

Cheers,
avalanches.

radhakrishnan82 · Posted: Mon May 16, 2005 12:46 pm Post subject:

Hi,

It is much easier to write ad hoc SQL against DB2 tables than it is to code programs that access VSAM files.Now-a-days,people converting from vsam to db2.The predominant reason is to ease data access.

priyesh.agrawal · Posted: Mon May 16, 2005 6:10 pm Post subject: Re: VSAM vs DB2?

agree with radhakrishnan82,....

Though its purely a decision of programmer depending on needs, DB2 is preferable over VSAM.

Using SPUFI feature you can easily access info'n from DB2.

Regards,

Priyesh.

ashutosh719 · New User Joined: 06 Apr 2005 Posts: 13

refer to an article on DB2 vs. VSAM byCraig Mullins on this...