Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 7830 Views
- Target, I also Faced
- E-Mail Answers
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?
Yes. Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.
Tell about the ams used in vsam?
explain in brief what are the 3 types of vsam files?
write a program to read from a VSAM file , there will be a 5 records to create name. empno. resignation and address to update in a db2 table and call another program using dynamic call to find the matching fields in program 1 to update in db2 table. anybody pls send de program for dis ? thanks in advance...
Why is master catalog used in vsam?
what do you mean by the repro command?
How to get the last record in vsam file in cluster? And how can u get the ksds file records into cobol program?
Explain the index set?
What are the distinctive features of a ksda, key sequenced dataset?
How does control intervals and control areas related to each other?
What are the building blocks used in vsam datasets?
how many buffers are allocated to vsam ksds and esds?
what are the codes returned by the ams (access method services) command during the execution in vsam?
explain in brief how are different versions of gdg named?
