VSAM Interview Questions : Part 2

Mainframe Virtual Storage Access Method Interview Questions collected form various MNCs

How do you decide on optimum values for CI, FREESPACE etc.?

Would you specify FREESPACE CE for an ESDS ?

What is SHAREOPTS ?

What is the meaning of each of the values in SHAREOPTS (2 3) ?

How do you define a kSDS ?

How do you define an ALTINDX ? How do you use ALTINDXs in batch, CICS program's ?

Using Alternate Indexes in Batch program:

Using Alternate Indexes in CICS program:

What happens when you open an empty VSAM file in a COBOL program for input ?

How do you initialize a VSAM file before any operation ? a VSAM with alternate index ?

What does a file status of 02 on a VSAM indicate ?

How do you calculate record size of an alternate cluster ? Give your values for both unique and nonunique.

What is the difference between sequential files and ESDS files ?

Suppose 3 generations of a GDG exist. How would you reference the 1st generation in the JCL ?

Suppose a generation of GDG gets created in a particular step of a proc. How would you refer the current generation in a subsequent step ? What would be the

disposition of this generation now ?

What more info you should give in the DD statement while defining the next generation of a GDG ?

Assuming that the DEFINE JCL is not available, how do you get info about a VSAM file's organisation ?

During processing of a VSAM file, some system error occurs and it is subsequently unusable What do you do ?

How do you fix the problem associated with VSAM out of space condition ?

What is the meaning of VSAM RETURN-CODE 28 ?

On which dataset You can have ALT INDEX ?

What is an alternate index and path ?

How do you load a VSAM data set with records ?

How do you define a GDG ?

Do all versions of the GDG have to be of the same record length ?

How are different versions of GDG named ?

How many buffers are allotted to VSAM KSDS and ESDS ?

What is the biggest disadvantage of using a VSAM dataset ?

What are the types of VSAM datasets ?

How are records stored in an ESDS, entry sequenced dataset?

What is a CI, control interval?

What are the distinctive features of a KSDA, key sequenced dataset?

What is a CA, control area?

How many ALternate Indexes you can have on a dataset ?

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

What does the KEYRANGES parameter in Define Cluster commends do ?

People who read this, may find the below Interesting