| Feature | DB2 | VSAM |
| Data Archival | Selective archival Selective retrieval Upto row level archival Specific Products | No Selective archival No Selective retrieval Dataset level archival Dataset Migration |
| Personnel | IBM & 3rd party training Easy to find Skills Reuse any RDBMS skill Same across platforms | Not much training Scarce skill VSAM Specific skill Mainframe Specific skill |
| Data Warehouse | Real time updates Direct Propagation Product suites available | Batch updates only Extract & transform Not suitable for warehouse |
| Data types | Images, Video, Audio etc Contents can be in file | Text only No such option |
No comments:
Post a Comment