Mainframe For Dummies

Why DB2 and why not VSAM (DB2 Vs VSAM)? This is the common query raised by the programmers, whether to go with DB2/VSAM, hope below information helps. VSAM DB2 Definition Database with file Concepts Database built on File management storage system-DBMS concepts Security levels Provides at Dataset level only Provides Good security levels at various levels (like table, table space etc.,) Data Maintenance It’s difficult compared to DB2. Data retrieval or insertion or updates etc, is a bit difficult (puts more burden on programmer to achieve this). Simply speaking Query interface is not supported It’s easy to maintain data by using SQL Data retrieval or insertion or updates etc, is far easier using SQl . Query interface is