Locking Behavior

The new LOCK WITH FORCE option (see Figure 11.1) permits you to force applications to release the locks they have on a table, allowing a load operation to proceed. Either SYSADM or SYSCTRL authority is required to use the LOCK WITH FORCE option. Table 11.1 summarizes locking behavior under different access modes with and without the LOCK WITH FORCE option.

Figure 11.1. Partial syntax of the LOAD command showing the new ALLOW READ ACCESS and the LOCK WITH FORCE clauses.

Table 11.1. Behavior Under Different Access Modes with and without the LOCK WITH FORCE Option if an Attempt to Acquire a Lock Is Unsuccessful
Access ModeTable Lock ...

Get DB2® Version 8: The Official Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial