What are the advantages of DB2 over VSAM? [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. 开发者_Python百科 Closed 10 years ago.

What are the advantages of DB2 over VSAM?

---

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.

---

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