How do you calculate record size of an alternate

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

(Continued from previous question...)

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

UniqueCase: 5 + (alt-key-length + primary - key )
Non unique Case: 5 + (alt-key-length + n * primary - key ) where n = number of duplicate records for the alternate key

(Continued on next question...)

Other Job Interview Questions

• Would you specify FREESPACE CE for an ESDS ?
• What is IDCAMS ?
• Using Alternate Indexes in Batch program:
• How do you calculate record size of an alternate cluster ? Give your values for both unique and nonunique.
• How to delete a member using JCL.
• Do all versions of the GDG have to be of the same record length ?
• What is the difference between sequential files and ESDS files ?
• What is the index set?
• What is the device independent method to indicate where a Record is Stored ?
• What is a LDS (Linear Data Set ) and what is it used for ?
• More...