What does the KEYRANGES parameter in Define Clus

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

(Continued from previous question...)

What does the KEYRANGES parameter in Define Cluster commends do ?

It divides a large dataset into several volumes according to the Key ranges specified. e.g. KEYRANGES ((0000001 2999999) (3000000 5999999)). if the activity on the key ranges are evenly distributed, concurrent access is possible, which is a performance inprovement.

(Continued on next question...)

Other Job Interview Questions

• What is the device independent method to indicate where a Record is Stored ?
• What is a CI, control interval?
• What is the biggest disadvantage of using a VSAM dataset ?
• Using Alternate Indexes in Batch program:
• What is FREESPACE ?
• What are the optional parameters to the input dataset While loading the empty cluster with the data records ?
• What is the significance of the SHAREOPTIONS parameter?
• Under IDCAMS, multiple functions can be executed, each of which returns a condition code. What will be the condition code returned to the operating system ?
• What is the catalog?
• What is free space?
• More...