LOCK TABLES 锁定表 ; 锁表 ; 允许锁表
Lock tables before read 读表之前锁定
flush tables with read lock 数据库只读锁定命令 ; 防止导出数据库的时候有数据写入
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.
消息引擎持有独占锁的结果在于,数据库维护实用工具无法以首选的方式运行,该方式旨在对数据库中的所有表进行维护。
应用推荐