What is lock escalation?

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

(Continued from previous question...)

What is lock escalation?

Promoting a PAGE lock-size to table or tablespace lock-size when a transaction has acquired more lock than specified in NUMLKTS. Locks should be taken on objects in single tablespace for escalation to occur.

(Continued on next question...)

Other Job Interview Questions

• When one binds a PACKAGE of a plan what package information is stored and where it is stored?
• What is the syntax of SELECT statement when embedded in a COBOL program ?
• What is the size of a data page ?
• What is the syntax of SELECT statement when embedded in a COBOL program ?
• What is DB2 ( IBM Database 2 )?
• What is the difference between group by and order by ?
• Is there any advantage to denormalizing DB2 tables ?
• What is the equivalent COBOL DATA Type for Decimal(x,y) in DB2 ?
• What is the format (internal layout) of "TIMESTAMP"?
• What is the error code - 803 ?
• More...