Which DB access method (OSAM or VSAM) is better and why?
Answer Posted / john i harper
With IMS HALDBs, OSAM or VSAM can go to 40 terabytes, so
size is no longer a problem. However, OSAM was written by
IMS to do one thing, hold IMS data securely, and move it
quickly. VSAM was written to do many things, making the code
path longer. That increases the time needed to run, and
presents
a greater risk of failure.
Finally, OSAM is written and owned by IMS, so you only have
to ask one development team instead of two if you want any
new features added.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a segment in ims?
What are the processing modes available in ims db?
Explain the maximum of key fields and search fields allowed in a segment?
What is the maximum number of fields allowed per segment and what is the maximum number of fields per database?
Explain the disadvantage of dynamic generation of acb?
Explain the two ways in which dl/i interface can be invoked?
how do you bind the cobol with db2
What is the need for a secondary index in ims?
What is dbms in ims?
What is psb?
What is the advantage of dynamic generation of acb?
What is the advantage of creating the acbs well ahead of time?
What are the objectives of dbms in ims?
Explain the maximum number of segment types allowed for a single database?
What is acbgen process?