What are the advantages of DB2 over VSAM?

Question

Here is a list of points which explain [why DB2 is better than VSAM](http://search400.techtarget.com/tip/0,289483,sid3_gci1072318,00.html). I hope it helps. cheers — Arnkrishn, Jan 24 '10 at 18:30
Here you can find a good comparison artical between two: http://www.tatasafariclub.com/post-94008.html for the advantages of db2 over VSAM look here : http://search400.techtarget.com/tip/0,289483,sid3_gci1072318,00.html — GuruKulki, Jan 24 '10 at 18:28

score 0 · Answer 1 · edited Nov 12 '12 at 14:51

0

VSAM : file system, so no concurrent updates, no logging, no back-outing
DB2 : database : concurrent updating with logging and back-outing

edited Nov 12 '12 at 14:51

j0k

22,600
28
79
90

answered Nov 12 '12 at 14:32

Y Forgeau

1

score 0 · Answer 2 · answered Nov 16 '11 at 17:16

Links take you to nice explanations, but it boils down to DB2 offering referential integrity and ability to use SQL. In addition to that DB2 supports things like procedures, views, and triggers. DB2 understands relationships between tables. In z/OS implementations DB2 tables are actually stored as linear VSAM files.

What are the advantages of DB2 over VSAM?

2 Answers2