What is the meaning of each of the values in SHA

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

(Continued from previous question...)

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

Value of 2 for cross region means that the file can be processed simultaneously by multiple users provided only one of them is an updater. Value of 3 for cross system means that any number of jobs can process the file for input or output (VSAM does nothing to ensure integrity).

(Continued on next question...)

Other Job Interview Questions

• What more info you should give in the DD statement while defining the next generation of a GDG ?
• What are the three levels of definition for the VSAM DEFINE?
• What is the index set?
• How do you initialize a VSAM file before any operation ? a VSAM with alternate index ?
• Do primary key values have to be unique? Do alternate key values have to be unique?
• 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 is a Base Cluster ?
• What is the meaning of dynamic processing
• What are the distinctive features of a KSDA, key sequenced dataset?
• How do you define a GDG ?
• More...