If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?

Posted by: Pdfprep Category: C2090-320 Tags: C2090-320 exam questions, C2090-320 practice exam, IBM Certified Database Administrator Post Date: January 13, 2021

Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64.

If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?
A . PAGE
B . TABLE
C . PARTITION
D . TABLESPACE

Answer: C

If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?

Author