VSAM Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 6043

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.

2498

What is RECOVERY and SPEED parameters in DEFINE CLUSTER command?

1 14433

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

1 17829

What does the KEYRANGES parameter in Define Cluster commend do?

1 7553

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

IBM,

1 6307

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

4 19199

How to delete a member using JCL.?

5 15603

What is the Difference between LDS & ESDS ?

3 15477

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

3 10533

What is an alternate index and path ?

Infosys, TCS,

2 26875

How many buffers are allotted to VSAM KSDS and ESDS?

1 8327

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

Anjana, CTS, DSRC, IBM,

8 20741

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

1 5842

How many times secondary space allocated?

5 11071

Post New VSAM Questions

Un-Answered Questions { VSAM }

What are the different parameters that are used in vsam?

1204

What is the function of linear dataset in vsam?

1119

what is the purpose of the verify function of idcams?

1105

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...

2798

Explain what are the optional parameters to the input dataset while loading the empty cluster with the data records?

1223

Define gdg?

1032

what do you mean by idcams? Explain its purpose?

1021

differentiate between sequential files and esds files in vsam?

1237

What are the different dataset organizations used in vsam?

1056

what do you mean by a upgrade set in vsam?

1128

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?

1515

Explain the index set?

1147

what are the idcams commands that can be used for vsam and explain each of them.

1058

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

1352

What is the use of access method services in vsam?

1125

For More Un-Answered { VSAM } Questions Click Here