What is the significance of DB2 free space and w

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

(Continued from previous question...)

What is the significance of DB2 free space and what parameters control it?

The two parameters used in the CREATE statement are the PCTFREE which specifies the percentage of free space for each page and FREEPAGE which indicates the number of pages to be loaded with data between each free page. Free space allows room for the insertion of new rows.

(Continued on next question...)

Other Job Interview Questions

• What is a clustering index ?
• What is meant by a unit of recovery?
• What is the difference between TYPE 1 index and TYPE 2 index?
• EXPLAN has output with MATCHCOLS ...
• What is lock escalation?
• What is the difference between TYPE 1 index and TYPE 2 index?
• What is a view ? Why use it
• What information can you find in SYSIBM.SYSLINKS table?
• What is the meaning of -805 SQL return code ?
• What is the maximum number of tables that can be stored on a Partitioned Tables Space?
• More...