IBM InfoSphere DataStage v11.5 — Question 1

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?

Answer options

• A. PAGE
• B. TABLE
• C. PARTITION
• D. TABLESPACE

Correct answer: C

Explanation

When the number of locks exceeds the LOCKMAX setting of 1000, the lock escalation occurs. Since TS1 is non-partitioned, the lock will escalate to the PARTITION level, which is applicable even though there are no explicit partitions.