This is because the new X row lock and the is table lock are not compatible.
这是因为新的x行锁定和is表锁定是不兼容的。
When using CS in application A1, there will be an IS (intent share) table lock.
在应用程序a 1中使用CS时,将有一个IS (intentshare)表锁定。
RR does not allow phantom reads by creating an S (share) table lock when selecting rows.
RR不允许幻象读取,它会在选择行时创建一个S(share)表锁定。
What are the consequences of using the table lock option with a fast load destination?
使用表锁选项与快速加载目的地的后果是什么?
Reduction in false lock contentions for row and table locks in the lock manager's hash table
减少锁管理器的hash表中对行和表锁的虚假锁竞争。
The only alternative to a lock on every new row is a table lock (since there are no page locks in DB2).
对于每个新行之上的锁,惟一可以替代的是表锁(DB 2中没有页锁)。
After some small number of row locks are obtained, a lock escalation to a table lock will occur automatically.
当获得少量的行锁时,行锁就会自动地逐渐升级为表锁。
If after replacing these with a single table lock, the MAXLOCKS value is no longer exceeded, lock escalation stops.
如果用一个表锁替换这些行锁,将不再会超出maxlocks值,那么锁升级就会停止。
The Database Engine chooses the appropriate lock and can escalate the lock from a row or page lock to a table lock.
数据库引擎将选择相应的锁,并且可以将锁从行锁或页锁升级到表锁。
If a transaction obtains a row lock for a row, the transaction also acquires a table lock for the corresponding table.
如果一个事务获得了一行的行锁,那么这个事务同时获得了相关的表的锁。
This causes DB2 to use a table lock for all subsequent SQL statements using the table, until the locksize is changed back to ROW.
这将导致DB 2为随后使用该表的所有sql语句使用一个表锁,直到locksize参数改回到ROW。
So, you can address this with perhaps a table lock, or some other syncing field in the database to ensure duplicates don't appear.
因此,您可以通过表锁或数据库中的其他同步字段来解决这个问题,以确保不会出现重复项。
Application 2 can establish an IX lock on the table and an X row lock, because the table lock IX is compatible to the IN table lock from A1.
应用程序2可以在表上建立一个IX锁定和一个x行锁定,因为表锁定ix兼容a1的in表锁定。
Because the acquired lock does not persist across transaction boundaries, the import utility loses its IX table lock and must request another lock after each commit.
因为获得的锁不会跨事务边界存在,所以import工具将失去它的IX表锁,并且必须在每次提交之后请求另一个锁。
Why does DB2 lock this table, row, or object?
为什么DB 2锁住了这个表、行或者对象?
With this type of lock, concurrent applications can read from or write to the locked table.
有了这一类型的锁,并发应用程序就可以读或写已锁定的表。
The database manager determines which locks to escalate by looking through the lock list for the application and finding the table with the most row locks.
数据库管理器通过查看应用程序的锁列表并查找行锁最多的表,来决定对哪些锁进行升级。
For table Spaces containing more than one table, when DB2 acquires locks on a table, that lock does not affect access to segments of other tables.
对于包含多个表的表空间,当DB 2取得用于某一个表的锁时,这个锁不会影响对其他表的段的访问。
When a table holds a Z lock, no concurrent application can read or update data in that table.
当表持有z锁时,任何并发应用程序都不能读取和更新该表中的数据。
We are now ready to export the data from the NEWSTAFF table, and to simultaneously capture a database lock snapshot.
现在我们已经准备就绪,可以从newstaff表导出数据,并同步捕获数据库锁快照了。
The example above shows how to fill the lock table for two full-text index resources.
上面的示例演示如何在锁表中填充两个全文索引资源。
When a table holds an IX lock, the lock owner and concurrent applications can read and update data in that table.
当表持有IX锁时,锁拥有者和并发应用程序可以读和更新该表中的数据。
This means that an exclusive lock is always placed on the indexed table while a functional index is being created or dropped.
这说明,在创建或删除函数索引时,执行索引的表中始终持有一个排他锁。
When you use the ONLINE keyword, DDL operations execute without applying an exclusive lock to the table on which the specified index is defined.
在使用ONLINE关键字时,DDL操作是在没有将排它锁应用于定义特定索引表的情况下执行的。
If you attempt to alter a table to use this lock size option, and it isn't an MDC table, you will receive an SQLSTATE 628n error.
如果您尝试修改一个表,以便使用这种锁粒度选项,而那个表又不是mdc表,那么您将收到一个SQLSTATE 628n错误。
The LOCK TABLE command can be used to lock a table instead of using the default row locking.
可使用LOCK TABLE命令来锁定一个表,而不是使用缺省的行锁定。
The hang is caused by an exclusive row lock on table EMPLOYEE.
挂起是由表 EMPLOYEE上一个独占式的行锁导致的。
The maximum number of applications allowed to access a resource concurrently is defined by the number of rows for this resource in the lock table.
锁表中一个资源的行数决定了可以同时访问这个资源的最大应用程序数量。
Within the child thread, open a new connection to DB2 and fetch a row from the lock table for the requested resource ID.
在子线程中,打开新的DB 2连接,在锁表中获取具有所请求的资源ID的一行。
These locks could be table level, row level, or lock on index, and so on.
这些锁可以是表级锁、行级锁、索引锁等等。
应用推荐