what is the drawback of vsam dataset??
a.execution slow.
b.free space.
c.independent storage device.
d.none of the above.
let me know the answer with reason.

Answer Posted / e s hudders

The question is too vague because there are 4 different types of VSAM data sets. Eliminating Linear Data Sets (LDS) that are used by DB2, the other types of VSAM data sets have different purposes and can be used to substitute previous access method - KSDS replaces ISAM, RRDS replaces DAM and ESDS replaces SAM. There are many advantages to using VSAM especially when compared to the older access methods that run below the line. As far as free space and splits, this applies to KSDS and you need to compare it to its equivalent how ISAM handled new record insertions. So, personally although things like free space takes up more disk space is not as important as having the capability to insert records in a file and to be able to process it sequentially as well as direct. The resulting splits are the price of splits can occur but again compared to ISAM, this is not as costly.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In a KSDS file, key is missing for one record. How to insert the key for that particular record from back up file. Is there any sorting needed for the back up file before the key insertion?

1188


What are the advantages of vsam over isam?

878


What are the different parameters that are used in vsam?

907


is it necessary that all versions of the gdg have to be of the same record length?

884


How do you define an altindx?

755


is delete operation supported in an esds? Is rewrite operation possible in esds?

805


explain in brief what are the 3 types of vsam files?

827


explain in brief how are different versions of gdg named?

725


What is control area?

836


What is a ca split?

772


If fspc(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both ci and ca are specified to be empty?

849


How is the sorting of vsam files carried?

806


Under idcams, multiple functions can be executed, each of which returns a condition code. What will be the condition code returned to the operating system?

780


explain how do you define a gdg in vsam?

754


what do you mean by a vsam split?

789