What is a VSAM split?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a VSAM split?

If there isn't enough space in the control interval VSAM performs a control interval split by moving some records to the free control intervals. If there isn't a free control interval VSAM performs a control area split by allocating a new control area and moving half of the control intervals to it.

(Continued on next question...)

Other Job Interview Questions

• Is a delete operation possible in an ESDS ? B, is rewrite operation possible in ESDS ?
• 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 ?
• How do you calculate record size of an alternate cluster ? Give your values for both unique and nonunique.
• Describe SHAREOPTIONS parameter (SHR) in Define Cluster command.
• What is the upgrade set?
• What is the utility program closely associated with VSAM?
• How do you calculate record size of an alternate cluster ? Give your values for both unique and nonunique.
• Assuming that the DEFINE JCL is not available, how do you get info about a VSAM file's organisation ?
• How many ALternate Indexes you can have on a dataset ?
• In the COBOL SELECT statement for a KSDS what are the three possibilities for ACCESS?
• More...