IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

VSAM vs DB2 - Which is better to use and why


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
richa.setia

New User


Joined: 23 Mar 2005
Posts: 10
Location: Noida

PostPosted: Mon May 16, 2005 10:40 am
Reply with quote

Please let me know out of VSAM and DB2, which is better to use and why?
Back to top
View user's profile Send private message
avalanches

New User


Joined: 10 May 2005
Posts: 28

PostPosted: Mon May 16, 2005 11:31 am
Reply with quote

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.
Back to top
View user's profile Send private message
avalanches

New User


Joined: 10 May 2005
Posts: 28

PostPosted: Mon May 16, 2005 11:33 am
Reply with quote

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.
Back to top
View user's profile Send private message
radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 435
Location: chennai, India

PostPosted: Mon May 16, 2005 12:46 pm
Reply with quote

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.
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Mon May 16, 2005 6:10 pm
Reply with quote

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.
Back to top
View user's profile Send private message
ashutosh719

New User


Joined: 06 Apr 2005
Posts: 12

PostPosted: Tue May 17, 2005 10:56 am
Reply with quote

refer to an article on DB2 vs. VSAM byCraig Mullins on this...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts CVDA value for RRDS VSAM dataset. CICS 2
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
No new posts Open VSAM File in IMS DC Region - DFS... IMS DB/DC 0
Search our Forums:

Back to Top