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


Please Help Members By Posting Answers For Below Questions

What are the advantages of a hierarchical database?

2748


Explain the two ways in which dl/i interface can be invoked?

3119


What are the two ways in which dl/i interface can be invoked?

529


What is the maximum number of levels allowed in ims db?

545


What is acbgen process?

693






What is the maximum number of pcbs allowed in a psb?

549


What information does a dbd contain?

596


Explain the advantage of creating the acbs well ahead of time?

3140


What is hierarchical database?

3182


Can we use procopt on pcb and segment field (senseg)?

569


What are the disadvantages of a hierarchical database?

2761


how do you bind the cobol with db2

2313


What is an ims database?

599


What is the disadvantage of dynamic generation of acb?

578


What is meant by bmp mode?

582