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

Explain the maximum number of levels allowed in ims db?

3432


What is the maximum number of segment types allowed for a single database?

728


What is acbgen process?

772


What is psb?

700


What is psbgen process?

778






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

609


What is a segment in ims?

664


Define psb?

669


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

643


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

644


What is the advantage of dynamic generation of acb?

638


What is the maximum of key fields and search fields allowed in a segment?

658


What are the advantages of a hierarchical database?

2830


What is meant by bmp mode?

655


What are the processing modes available in ims db?

732