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 dbd?
Define psb?
What is meant by bmp mode?
What is mpp mode?
What is batch dl/i mode?
What information does a psb contain?
My IMS main progam is calling Db2 subroutine ...Its giving - 923 db2 sql code..so could any one tell how to solve this issue.
Define dl/i?
How many root segments do we have per database record?
What is dl/i?
Explain acbgen process?
Explain 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?
What is the advantage of creating the acbs well ahead of time?
What are the two ways in which dl/i interface can be invoked?