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

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

    youdao

  • When using CS in application A1, there will be an IS (intent share) table lock.

    应用程序a 1使用CS时,一个IS (intentshare)锁定

    youdao

  • RR does not allow phantom reads by creating an S (share) table lock when selecting rows.

    RR允许幻象读取,它会选择行时创建一个Sshare锁定

    youdao

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

    减少管理器hash虚假竞争

    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

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

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

    youdao

  • If after replacing these with a single table lock, the MAXLOCKS value is no longer exceeded, lock escalation stops.

    如果替换这些行锁,将不再会超出maxlocks,那么锁升级就会停止。

    youdao

  • The Database Engine chooses the appropriate lock and can escalate the lock from a row or page lock to a table lock.

    数据库引擎将选择相应并且可以将锁升级表锁。

    youdao

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

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

    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, you can address this with perhaps a table lock, or some other syncing field in the database to ensure duplicates don't appear.

    因此可以通过数据库中的其他同步字段解决这个问题,确保不会出现重复项

    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

  • 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锁,并且必须每次提交之后请求另一个锁。

    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

  • With this type of lock, concurrent applications can read from or write to the locked table.

    有了类型并发应用程序就可以已锁定

    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

  • 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取得用于某一个表的时,这个不会影响对其他访问

    youdao

  • When a table holds a Z lock, no concurrent application can read or update data in that table.

    持有z时,任何并发应用程序都不能读取更新该表中的数据

    youdao

  • We are now ready to export the data from the NEWSTAFF table, and to simultaneously capture a database lock snapshot.

    现在我们已经准备就绪,可以newstaff导出数据同步捕获数据库快照了。

    youdao

  • When a table holds an IX lock, the lock owner and concurrent applications can read and update data in that table.

    持有IX时,锁拥有者并发应用程序可以更新该表中的数据

    youdao

  • This means that an exclusive lock is always placed on the indexed table while a functional index is being created or dropped.

    说明创建删除函数索引时,执行索引的始终持有一个排他

    youdao

  • 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操作没有应用于定义特定索引情况下执行的。

    youdao

  • 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错误。

    youdao

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

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

    youdao

  • As all rows in the EMPLOYEE table are X-locked by the first transaction, the second application goes into lock wait mode.

    由于employee中的所有行都第一事务独占锁定,第二应用程序进入等待模式

    youdao

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

    一个资源行数决定可以同时访问这个资源最大应用程序数量

    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

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

    如果只有单一类型关联到给定那么可以添加额外的原始表中控制锁定

    youdao

  • Confirm that the server has a sufficient number of lock resources to alter the associated delete table along with the replication table.

    确信服务器足够资源用以修改相关删除复制表。

    youdao

  • If the collected lock event data should not be kept for further analysis purposes, the unformatted event table must be dropped manually using the drop table statement, as shown in Listing 22.

    如果需要保留收集的事件数据用作将来的分析必须使用DROPtable语句手动删除格式化事件,如清单22所

    youdao

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

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

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