This function module will remove a lock entry from the lock table.
这个功能模块会去除加锁表中的一条加锁记录。
This function module is used to generate a lock entry in the lock table.
这个功能模块用于在加锁表中生成一条加锁记录。
The example above shows how to fill the lock table for two full-text index resources.
上面的示例演示如何在锁表中填充两个全文索引资源。
The LOCK TABLE command can be used to lock a table instead of using the default row locking.
可使用LOCK TABLE命令来锁定一个表，而不是使用缺省的行锁定。
Create a DB2 table (hereafter referred to as lock table) to define the resources related to session locking.
创建一个db2表(在下文中称为锁表(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的一行。
When performing many updates, lock the entire table for the duration of the transaction before updating (using the SQL lock table statement).
当执行大量更新时，更新之前，在整个事务期间锁定整个表(使用SQLLOCK table语句)。
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.
锁表中一个资源的行数决定了可以同时访问这个资源的最大应用程序数量。
When having duplicate rows in the lock table (see the Create a DB2 table for resource locking section), concurrent use of the resource is possible.
如果锁表中有重复的行(参见为资源锁定创建一个DB 2表一节)，就可以对资源进行并发使用。
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.
数据库管理器通过查看应用程序的锁列表并查找行锁最多的表，来决定对哪些锁进行升级。
If after replacing these with a single table lock, the MAXLOCKS value is no longer exceeded, lock escalation stops.
如果用一个表锁替换这些行锁，将不再会超出maxlocks值，那么锁升级就会停止。
The only alternative to a lock on every new row is a table lock (since there are no page locks in DB2).
对于每个新行之上的锁，惟一可以替代的是表锁(DB 2中没有页锁)。
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表导出数据，并同步捕获数据库锁快照了。
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 hang is caused by an exclusive row lock on table EMPLOYEE.
挂起是由表 EMPLOYEE上一个独占式的行锁导致的。
This is because the new X row lock and the is table lock are not compatible.
这是因为新的x行锁定和is表锁定是不兼容的。
These locks could be table level, row level, or lock on index, and so on.
这些锁可以是表级锁、行级锁、索引锁等等。
Its primary deficiency is that it takes an exclusive lock on the table.
主要的缺陷是它对表实施了独占锁。
This causes an X lock to be immediately taken on the table.
这将导致表上立即上了一个x锁。
If only a single type of lock can be associated with the given table, then it may make sense to add extra columns to the original table to control the locking.
如果只有单一类型的锁关联到给定表，那么可以添加额外的列到原始表中来控制锁定。
Confirm that the server has a sufficient number of lock resources to alter the associated delete table along with the replication table.
确信服务器有足够的锁资源数，用以修改相关的删除表和复制表。
After some small number of row locks are obtained, a lock escalation to a table lock will occur automatically.
当获得少量的行锁时，行锁就会自动地逐渐升级为表锁。
After some small number of row locks are obtained, a lock escalation to a table lock will occur automatically.
当获得少量的行锁时，行锁就会自动地逐渐升级为表锁。
应用推荐