CREATE TEMPORARY TABLES, LOCK TABLES.
创建临时表,锁表。
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取得用于某一个表的锁时,这个锁不会影响对其他表的段的访问。
A special case of the session locking pattern, mentioned above, is the need for a single lock on a set of tables.
如前面所提到的,会话锁定模式中的一个特例是需要对表集合施加单一的锁。
The result of the messaging engine holding an exclusive lock was that the database maintenance utilities could not be run in the preferred manner, which was to do so for all tables in the database.
消息引擎持有独占锁的结果在于,数据库维护实用工具无法以首选的方式运行,该方式旨在对数据库中的所有表进行维护。
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.
Informix创建的表默认执行了页面级锁定,所以当两个或更多用户尝试更新同一页面中的一行时,至少一个用户将获得锁定错误。
Let's lock the tables in exclusive mode.
我们会以独占模式锁定表。
When a big query like that is performed, it can lock your tables and bring your web application to a halt.
这类操作请求是锁表的,可能导致网站应用挂起。
This allows you to archive or delete these records without having to lock the data in the active instance tables of the database.
这样,您将能够存档或删除这些记录,而不必锁定数据库的活动实例表中的数据。
This allows you to archive or delete these records without having to lock the data in the active instance tables of the database.
这样,您将能够存档或删除这些记录,而不必锁定数据库的活动实例表中的数据。
应用推荐