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.