Normalization is a design procedure for representing data in tabular format The five normal forms are progressive rules to represent the data with minimal redundancy.
Promoting a PAGE lock-size to table or tablespace lock-size when a transaction has acquired more locks than specified in NUMLKTS. Locks should be taken on objects in single tablespace for escalation to occur.
SHARE, EXCLUSIVE, UPDATE
No. To lock a view, take lock on the underlying tables.
SQL command used to change the definition of DB2 objects.