table lock信息详情

table lock发音

意思翻译

表锁定

相似词语短语

lock lock───锁定

lock───n.锁;车锁;(机器部件等的)锁定;前轮转向角度;船闸;一缕头发;(并列争球的)第二排前锋;(对某物的)完全控制;(摔跤及武术用语)抱,夹;(交通)堵塞;完全转向;枪栓;毛撮;n.(Lock)(美)洛克(人名);v.(用锁)锁上;被锁住;把……锁起来;(使)固定;陷入;被紧紧抓住(或抱住);加锁;过船闸

child lock───儿童安全锁;儿童锁

num lock───数字锁定键;小键盘开关

lock away───把…锁起来;藏起来;将…锁藏起来

hard lock───硬锁

cill lock───锡尔洛克

machine lock───机器锁

copulatory lock───交配锁

双语使用场景

When using CS in application A1, there will be an IS (intent share) table lock.───在应用程序a 1中使用CS时,将有一个IS (intent share)表锁定。

This is because the new X row lock and the is table lock are not compatible.───这是因为新的x行锁定和is表锁定是不兼容的。

RR does not allow phantom reads by creating an S (share) table lock when selecting rows.───RR 不允许幻象读取,它会在选择行时创建一个 S(share)表锁定。

If after replacing these with a single table lock, the MAXLOCKS value is no longer exceeded, lock escalation stops.───如果用一个表锁替换这些行锁,将不再会超出MAXLOCKS值,那么锁升级就会停止。

A row share table lock is the least restrictive mode of table lock, offering the highest degree of concurrency for a table.───行共享模式的表级锁的限制程度最低,因而能够保证表的最大的并发访问能力。

After some small number of row locks are obtained, a lock escalation to a table lock will occur automatically.───当获得少量的行锁时,行锁就会自动地逐渐升级为表锁。

The table lock prevents conflicting DDL operations that would override data changes in a current transaction.───表锁防止有冲突(可能覆盖数据的更新操作)的DDl操作。

The only alternative to a lock on every new row is a table lock (since there are no page locks in DB2).───对于每个新行之上的锁,惟一可以替代的是表锁(DB2中没有页锁)。

If a transaction obtains a row lock for a row, the transaction also acquires a table lock for the corresponding table.───如果一个事务获得了一行的行锁,那么这个事务同时获得了相关的表的锁。

英语使用场景

Information about the lock that was requested by the waiting application, such as row or table lock, shared or exclusive lock, table name, and so on.

When A2 commits the insert, because IS and IX table lock mode are compatible, application A1 can reopen the cursor and retrieve the inserted row.