VSAM Interview Questions
Questions Answers Views Company eMail

Is it slower if you access a record through ALT INDEX as compared to Primary INDEX? Why?

1 5004

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.

1870

What is RECOVERY and SPEED parameters in DEFINE CLUSTER command?

1 13307

Describe SHAREOPTIONS parameter (SHR) in Define Cluster command.?

1 16861

What does the KEYRANGES parameter in Define Cluster commend do?

1 6663

What are the optional parameters to the input dataset While loading the empty cluster with the data records?

IBM,

1 5036

What is IDCAMS? and what is the purpose of it?

4 17400

How to delete a member using JCL.?

5 13480

What is the Difference between LDS & ESDS ?

3 13863

Is a delete operation possible in an ESDS?B. Is rewrite operation possible in ESDS ?

3 8659

What is an alternate index and path ?

Infosys, TCS,

2 25384

How many buffers are allotted to VSAM KSDS and ESDS?

1 7391

what's the biggest disadvantage of using a VSAM dataset?

Anjana, CTS, DSRC, IBM,

8 17547

what's the device independent method to indicate where a Record is Stored?

1 4919

How many times secondary space allocated?

5 9227


Post New VSAM Questions

Un-Answered Questions { VSAM }

What is a lds (linear data set)?

548


Explain the difference between lds and esds?

573


What is the biggest disadvantage of using a vsam dataset?

591


what is the meaning of dynamic processing in vsam?

578


How is record management performed in vsam?

584






what do you mean by a upgrade set in vsam?

633


Describe the uses of ams?

534


differentiate between sequential files and esds files in vsam?

576


What is the main function of linear dataset?

554


what are the codes returned by the ams (access method services) command during the execution in vsam?

760


Is it slower if you access a record through alt index as compared to primary index?

587


Explain the significance of the shareoptions parameter?

530


why ci and ca splits are not possible in esds and rrds?

700


OPEN INPUT StudentFile READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ PERFORM UNTIL EndOfStudentFile DISPLAY StudentId SPACE StudentName SPACE CourseCode SPACE YOBirth READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ END-PERFORM CLOSE StudentFile STOP RUN what will be output

2059


What is control area?

634