在应用程序a 1中使用CS时，将有一个IS (intentshare)表锁定。
When using CS in application A1, there will be an IS (intent share) table lock.
可使用LOCKTABLE命令来锁定一个表，而不是使用缺省的行锁定。
The LOCK TABLE command can be used to lock a table instead of using the default row locking.
虽然有一些增加并发的技巧，但是，如果应用程序需要的是表级别或行级别的锁定，那么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.
在导出操作期间，行级别锁定应用于导出表(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.
改变表的锁定粒度。
系统级的锁定表通常被认为是系统中的热点。
System-wide locking tables are often considered to be hotspots.
在不锁定表的情况下创建和删除索引。
我们的第一个主要问题是，当我们想要一行的内容时，我们会扫描整个账单表，并锁定我们读取的每一行。
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.
行锁定，具有到表锁的升级。
然而，表模式也会影响乐观锁定的行为。
However, the schema of the table also affects the behavior of optimistic locking.
当执行大量更新时，更新之前，在整个事务期间锁定整个表(使用SQLLOCKtable语句)。
When performing many updates, lock the entire table for the duration of the transaction before updating (using the SQL lock table statement).
向要使用乐观锁定的表中添加一个额外的整数列；该列保存修订计数器。
We add an extra integer column to the table for which optimistic locking is required; this holds a revision counter.
每位参赛者需要做的第一件事是将每个表更改为行级别锁定。
The first thing every contestant needed to do was change every table to row-level locking.
为资源锁定创建一个db2表。
例如，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.
这样，您将能够存档或删除这些记录，而不必锁定数据库的活动实例表中的数据。
This allows you to archive or delete these records without having to lock the data in the active instance tables of the database.
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.
下一条语句通知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.)
不管数据行是否被提交，以及根据语句的谓词它是否被排除，对于索引扫描和表访问都执行这样的锁定操作。
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.
每个对象都有一些附加字节，通用语言运行库用来管理对象，如对象的虚表指针和同步锁定引用。
Every object has some additional bytes that the common language runtime USES to manage the object, such as the object's virtual table pointer and a reference to a sync block.
悲观锁定策略的前提是，另一个用户很可能试图修改您正在修改的某个表行。
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.
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.
此脚本将读取Informix系统表，找出哪些表具有页面级锁定，然后生成另一段sql脚本来将这些表更改为行级别锁定。
This script will read the Informix system tables, find out which tables have page-level locking, and then generate another SQL script to change those tables to row-level locking.
为了促使一个锁定超时错误发生，我们首先建立一个数据库连接，并执行一些sql语句来模拟表employee上的真实事务。
To force a lock timeout error, establish a first database connection and execute some SQL statements simulating a real transaction on the table employee.
这意味着在搜索的时候行、页或甚至整个表都被锁定。
This means rows, pages, or even whole tables can be locked while a search is being performed.
有了这一类型的锁，并发应用程序就可以读或写已锁定的表。
With this type of lock, concurrent applications can read from or write to the locked table.
ROWSHARE允许并发访问被锁定的表，但是禁止用户以排他访问的方式锁定整张表 。
ROW SHARE permits concurrent access to the locked table but prohibits users from locking the entire table for exclusive access.
对于受保护的表，此属性返回下一个未被锁定的单元格。
On a protected sheet, this property returns the next unlocked cell.
创建一个db2表(在下文中称为锁表(locktable))，它定义与会话锁定相关的资源。
Create a DB2 table (hereafter referred to as lock table) to define the resources related to session locking.
为了确定数据库中的哪些表具有页面级锁定以及需要修改为行级别锁定，我使用了一段sql脚本：genlockmod . sql(参见清单1)。
To determine which tables in a database have page-level locking and need to be modified to row-level locking, I use a helpful SQL script: genlockmod.sql (see Listing 1).
应用推荐