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
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?
What are the advantages of vsam over isam?
What are the different parameters that are used in vsam?
is it necessary that all versions of the gdg have to be of the same record length?
How do you define an altindx?
is delete operation supported in an esds? Is rewrite operation possible in esds?
explain in brief what are the 3 types of vsam files?
explain in brief how are different versions of gdg named?
What is control area?
What is a ca split?
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?
How is the sorting of vsam files carried?
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?
explain how do you define a gdg in vsam?
what do you mean by a vsam split?