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.
Answers were Sorted based on User's Feedback
Answer / shenbagasundari pilavadian
b.free space
Because, it increases the disk space requirements of system.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
How many cluster index can have in a table?
How is the sorting of vsam files carried?
How do you load a VSAM data set with records ?
By looking into JCL can we identify the dataset is VSAM (VSAM dataset supposed to be a input dataset).In this scenerio how will we identify the dataset is VSAM ?
5 Answers Cognizant, EDS, Shridhar,
can we create PS file using IDCAMS utility?
explain in brief what are the 3 types of vsam files?
What is the maximum number of Alternate Index ???
difference between vsam and database tables
should a AIX should be a unique value?
what is the concept of IMPORT in vsam??
Alt key is used for what type of vsam file
What is Base Cluster ?