How does DB2 determine what lock-size to use?

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

(Continued from previous question...)

How does DB2 determine what lock-size to use?

There are three methods to detemine the lock-size. They are;
1. Based on the lock-size given while creating the tablespace.
2. Programming can direct the DB2 what lock-size to use
3. If lock-size ANY is specified, DB2 usually choses a lock-size of PAGE

(Continued on next question...)

Other Job Interview Questions

• In terms of DB2 indexing, what is the root page ?
• What is meant by repeatable read?
• How to see the structure of DB2 table?
• Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
• Name some of field from SQLCA?
• How do you simulat the EXPLAIN of an embedded SQL statement in SPUFI/QMF ?
• What is the syntax required for the creation of a cursor ?
• What is a data page?
• What is the purpose of the DSNC transaction?
• What is cursor stability?
• More...