• This is because the new X row lock and the is table lock are not compatible.

    是因为新的x锁定is锁定兼容的。

    youdao

  • All back rise seams should be two-thread chain stitch or double row lock stitch.

    所有应当链式式线迹。

    youdao

  • The row is formatted in the target page and an X (exclusive) row lock is obtained on it.

    目标该行进行格式化,并获得该行上的一个Xexclusive,独占的)

    youdao

  • The LOCK TABLE command can be used to lock a table instead of using the default row locking.

    使用LOCKTABLE命令锁定一个而不是使用缺省锁定

    youdao

  • G stands for "granted" and means that the transaction with transaction handle 2 owns the row lock.

    g代表granted”,事务句柄为2的事务拥有

    youdao

  • After some small number of row locks are obtained, a lock escalation to a table lock will occur automatically.

    获得少量时,行自动地逐渐升级锁。

    youdao

  • If a transaction obtains a row lock for a row, the transaction also acquires a table lock for the corresponding table.

    如果事务获得了一的行,那么这个事务同时获得相关的锁。

    youdao

  • 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兼容a1in表锁定。

    youdao

  • If this row lock is protecting an uncommitted UPDATE or DELETE action, DB2 cannot process or ignore the row until the outcome of the change is known.

    如果这个保护一个未提交UPDATEDELETE动作那么DB 2不能处理忽略该行直到变化结果已知。

    youdao

  • 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.

    数据库管理器通过查看应用程序列表查找最多来决定哪些锁进行升级

    youdao

  • 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.

    DB2在执行索引扫描如果遇到个被一个事务独占 (X) 锁定的未提交,那么 DB2阻塞在行上。

    youdao

  • If a concurrently connected application happens to be holding an incompatible row lock, the import utility pauses until that application commits or rolls back its transaction.

    如果一个并发连接应用程序碰巧持有兼容,那么import工具就会暂停直到应用程序提交事务

    youdao

  • These next key locks are only obtained when the key INSERT finds that a scanner with a Repeatable Read (RR) isolation level has a row lock on the next-higher key in the index.

    这些nextkey只有keyINSERT发现带有RepeatableRead (RR)隔离级别扫描器索引中的next -higher一个才能获得

    youdao

  • Shortages in the lock maintenance space can lead to so-called lock escalations, in which row locks are escalated to undesirable table locks, which can even lead to deadlock situations.

    维护空间不足可能导致所谓的“锁提升”,其中,提升为不必要锁,甚至可能会导致死情况。

    youdao

  • Another special case of locking is the need to lock something where currently no database row exists.

    锁定另一个特例需要锁定当前数据库行中存在的项目。

    youdao

  • The only alternative to a lock on every new row is a table lock (since there are no page locks in DB2).

    对于每个之上惟一可以替代锁(DB 2没有)。

    youdao

  • In this case, a logical lock (not a physical database lock) is used to flag that a row is in use for a long-term duration.

    方案中通过逻辑(而不是物理锁)来对在时间使用数据行进行标记

    youdao

  • And the location of every row is in a fixed location, allowing for techniques such as lock escalation when too many fine-grained locks would otherwise be needed.

    并且由于每一行都存储固定位置使得升级这样的技术得以实现,以避免过多细粒度锁。

    youdao

  • If the MDB locks resources transactionally (for example, it may lock a database row), these resources will not become unlocked until the end of the batch.

    如果MD b以事务的方式锁定资源(例如可以锁定数据库),则结束之前这些资源保持锁定

    youdao

  • In the first session, execute the UPDATE statement shown in Listing 16, which places an exclusive lock on the row with department number B01.

    第一会话中执行清单16中的update语句部门为B01的部门设置独占

    youdao

  • 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

    youdao

  • In the meantime, transaction 2 wants access to that same row, but it has to wait until the lock is released by transaction 1.

    同时事务2希望访问这个但是必须等待事务1释放该行

    youdao

  • 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

    youdao

  • So to find the row that satisfies the predicate in the select statement, the optimizer has to lock, read in, and compare all the rows in the main table with the value supplied in the predicate.

    因此找到满足select语句谓词这个优化器必须主表中的所有上锁读取它们的谓词中提供的值进行比较

    youdao

  • Reduction in false lock contentions for row and table locks in the lock manager's hash table

    减少管理器hash虚假竞争

    youdao

  • As a result, the DB2 update lock for the row is released and this row is found by the next SQL select statement in Listing 2.

    因此会释放DB2更新清单2中的一个SQLselect语句看到一行。

    youdao

  • Before an RPG program updates a row accessed by a key it must perform a read operation to lock the row for update intent.

    R PG程序更新通过访问之前必须执行一个操作以便锁定该行,进行更新。

    youdao

  • If you issue a new query within this transaction, your new row is displayed, because your transaction holds the lock for the new row.

    如果事务发出一个查询将显示因为事务持有行的

    youdao

  • It returns the most recently committed version of the rows, even if another concurrent session holds an exclusive row-level lock.

    即使并发会话持有一个独占仍然返回最近提交行。

    youdao

  • Rows are only locked at the point in time that a cursor is positioned on them; once the next row is fetched, the lock is released.

    数据只是游标定位它们时才锁定一旦获取之后,解除。

    youdao

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定