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
 

 

Advantages of db2 over vsam

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
p.d.prasad

New User


Joined: 20 Jun 2006
Posts: 14
Location: hyderabad

PostPosted: Thu Jul 13, 2006 12:41 am    Post subject: Advantages of db2 over vsam
Reply with quote

HI
Could anyone clarify :VSAM is a database and DB2is also a data base so why we should go for DB2 ,then why to learn VSAM in mainframes if DB2 can alone suffice the need??
Back to top
View user's profile Send private message

Hanfur

Active User


Joined: 21 Jun 2006
Posts: 104

PostPosted: Fri Jul 14, 2006 10:43 am    Post subject: Hi
Reply with quote

Prasad,
Though the data in Db2 is stored as Vsam datasets data retrivel could be done with relational SQL statements which is very powerfull and conveneinet in retrieveing from and puttitng data in to Db2 tables;the one which lacks in case with stand alone VSAM datasets(KSDS,ESDS,RRDS etc)..

Also complex relation operations of joining sorting grouping etc can be done using the SQL which is not possible thru ordinary VSAM files .Also you could think of a code fragment which is required to retrieve data from a VSAM file and from Table.The latter looks requires less coding and is more readable and flexible.

-Han.
Back to top
View user's profile Send private message
parikshit123

Active User


Joined: 01 Jul 2005
Posts: 269
Location: India

PostPosted: Fri Jul 14, 2006 4:35 pm    Post subject:
Reply with quote

Hi,

VSAM is not a database but DB2 is a database management system . More specifically RDBMS.

The major advantage of using DB2 over VSAM is "Physical data Independence". i.e. when you use DB2 , you don't need to write relatively lower level of code involving physical charastericstics of file, read, write.... operations. This can be done via higher level language called SQL when you use DB2.

Also, data sharing and higher level of concurancy, integrity and transaction control can be achived if you use DB2.

The advantages of using DB2 over using VSAM is a huge list. Please google for the more advantages.. icon_smile.gif
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts VSAM define for large file jerryte JCL & VSAM 9 Wed Oct 05, 2016 1:51 am


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