这是因为新的x行锁定和is表锁定是不兼容的。
This is because the new X row lock and the is table lock are not compatible.
如果未使用表锁定，默认使用行级锁定，除非。
If table locking is not used, the default USES row - level locks, unless the.
RR不允许幻象读取，它会在选择行时创建一个S（share）表锁定。
RR does not allow phantom reads by creating an S (share) table lock when selecting rows.
在应用程序a 1中使用CS时，将有一个IS (intentshare)表锁定。
When using CS in application A1, there will be an IS (intent share) table lock.
应用程序2可以在表上建立一个IX锁定和一个x行锁定，因为表锁定ix兼容a1的in表锁定。
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.
虽然有一些增加并发的技巧，但是，如果应用程序需要的是表级别或行级别的锁定，那么DBMS能够更好地满足您的需求。
There are little tricks one can do to increase concurrency, but if your applications need table-level or row-level locks, a DBMS will better suit your needs.
每位参赛者需要做的第一件事是将每个表更改为行级别锁定。
The first thing every contestant needed to do was change every table to row-level locking.
我们的第一个主要问题是，当我们想要一行的内容时，我们会扫描整个账单表，并锁定我们读取的每一行。
Our first major problem is that we are scanning the full bills table every time we want a row out of it and locking every row we read.
向要使用乐观锁定的表中添加一个额外的整数列；该列保存修订计数器。
We add an extra integer column to the table for which optimistic locking is required; this holds a revision counter.
可使用LOCKTABLE命令来锁定一个表，而不是使用缺省的行锁定。
The LOCK TABLE command can be used to lock a table instead of using the default row locking.
系统级的锁定表通常被认为是系统中的热点。
System-wide locking tables are often considered to be hotspots.
不管数据行是否被提交，以及根据语句的谓词它是否被排除，对于索引扫描和表访问都执行这样的锁定操作。
This locking was done for both index scans and table access whether or not the row of data was committed or whether it would have been excluded based on the statement's predicates.
DB2在执行索引或表扫描时，如果遇到一个被另一个事务独占 (X)锁定的未提交行，那么 DB2 将阻塞在行锁上。
When DB2 performs an index or table scan, DB2 will block on a row lock when it comes across an uncommitted row which another transaction has exclusively (X) locked.
当执行大量更新时，更新之前，在整个事务期间锁定整个表(使用SQLLOCKtable语句)。
When performing many updates, lock the entire table for the duration of the transaction before updating (using the SQL lock table statement).
在目标表行上保持更新锁定。
然而，表模式也会影响乐观锁定的行为。
However, the schema of the table also affects the behavior of optimistic locking.
改变表的锁定粒度。
我们会以独占模式锁定表。
悲观锁定策略的前提是，另一个用户很可能试图修改您正在修改的某个表行。
A pessimistic locking strategy assumes that the probability is high that another user will try to modify the same row in a table that you are changing.
复制索引不需要锁定表。
行锁定，具有到表锁的升级。
在导出操作期间，行级别锁定应用于导出表(exportingtable)，这意味着一次只持有一个锁。
During an export operation, row-level locking is applied to the exporting table, which means that only one lock is held at a time.
为资源锁定创建一个db2表。
Informix创建的表默认执行了页面级锁定，所以当两个或更多用户尝试更新同一页面中的一行时，至少一个用户将获得锁定错误。
Tables created by Informix default to page-level locking, so when two or more users attempt to update a row on the same page, at least one will get a lock error.
例如，DB 2Fundamentals考试测试考生的安全知识，表、索引和视图的创建和使用，SQL使用，以及隔离级别和锁定。
For example, the DB2 Fundamentals exam tests a candidate's knowledge of security; creating and working with tables, indexes, and views; using SQL; and isolation levels and locking.
在不锁定表的情况下创建和删除索引。
下一条语句通知Grails表没有version列（GORM通常会创建一个 version列来优化乐观锁定）。
The next statement tells Grails that the table does not have a version column. (GORM normally creates one to help facilitate optimistic locking.)
有了这一类型的锁，并发应用程序就可以读或写已锁定的表。
With this type of lock, concurrent applications can read from or write to the locked table.
换句话说，我们顺序地扫描了此表，锁定了每个行，操作进行了很多次。
In other words, we have sequentially scanned this table, locking every row, a lot of times.
会话锁还可保存在被锁定的表中(或表集合的根表中)。
Session locks can also be kept on the table that is being locked (or the root table of a set of tables).
应用推荐