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?
What is the maximum number of segment types allowed for a single database?
Explain the maximum number of levels allowed in ims db?
Explain the advantage of creating the acbs well ahead of time?
What are the processing modes available in ims db?
Define psb?
What are the retrieval sequences in ims db?
What is meant by mpp mode?
Define dl/i?
What are the objectives of dbms in ims?
How many root segments do we have per database record?
Explain the maximum number of pcbs allowed in a psb?
Can we use procopt on pcb and segment field (senseg)?
What is dbdgen process?
What is the advantage of creating the acbs well ahead of time?