Which DB access method (OSAM or VSAM) is better and why?
Answer Posted / s
OSAM is better because with even block sizes you can have a
maximum size of 8 GB for a dataset. OSAM supports
sequential buffering, reads 10 consecutive blocks with one
1 I/O operation. This will reduce the elapsed time by 50%.
It also supports queued writes which also results CPU and
elapsed time savings.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is psb?
Explain psbgen process?
What is hierarchical database?
Explain the maximum number of pcbs allowed in a psb?
What is dbdgen process?
Portfolio analysis application is an example of?
Explain the disadvantage of dynamic generation of acb?
What are the disadvantages of a hierarchical database?
What is the maximum number of pcbs allowed in a psb?
how do you bind the cobol with db2
Explain the two ways in which dl/i interface can be invoked?
What are the advantages of a hierarchical database?
What is the maximum number of fields allowed per segment and what is the maximum number of fields per database?
What are the retrieval sequences in ims db?
What is meant by mpp mode?