Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Where to get sample for processing RM... vice_versa PL/I & Assembler 2 Tue Jan 16, 2018 2:03 pm
No new posts VSAM dataset not found abdulrafi JCL & VSAM 5 Fri Jan 12, 2018 11:19 am
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us