How do you decide on optimum values for CI, FREE

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

(Continued from previous question...)

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

CI size should be based on record length, type of processing. Usually CI is 4K. If record length is larger (>1K), chose 6K or 8K. FREESPACE should be large if more number of insertions are envisaged. Usual values are (20 20 ) when heavy updates are expected. CI size can be calculated.

(Continued on next question...)

Other Job Interview Questions

• How to delete a member using JCL.
• What is an alternate index and path ?
• What is the utility program closely associated with VSAM?
• There are at least seven IDCAMS commands; name and explain each of them?
• In the COBOL SELECT statement what is the ORGANIZATION for a KSDS?
• What is a VSAM split?
• If you wish to use the REWRITE command haw must the VSAM file be opened?
• Can AMS commands be run from the TSO prompt ?
• What is the purpose of the FILE STATUS clause in the SELECT statement?
• Do all versions of the GDG have to be of the same record length ?
• More...