There is not much to be said about this query other than the fact that it is the only query that can run with a cursor stability isolation level.
关于这个查询没有很多要讲的,只有一点:该查询是惟一可以以curs or stability隔离级别运行的查询。
That is because the export utility is bound with the cursor stability (CS) isolation level (for a description of the DB2 isolation levels, see the sidebar).
这是因为export工具被绑定为具有游标稳定性(CS)隔离级别(有关DB 2隔离级别的描述,请参阅侧栏)。
I've always thought that READ_COMMITTED (DB2 calls it Cursor Stability (CS)) meant that you do NOT lock on reads, and that you only read the committed data.
我一直认为read_committed (DB 2调用游标稳定性(CS))意味着你不锁上读,那你只能读提交的数据。
Supports table and row level locking and 4 isolation levels, RR (repeatable read), rs (read stability), CS (default - cursor stability) and ur (uncommitted read).
支持表级和行级锁以及4个隔离级别:RR(可重复读)、RS(读可靠)、CS(默认——游标可靠)和UR(未提交读)。
Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table (for example, use isolation level cursor stability or uncommitted read).
释放行锁,以便其他应用程序可以对表执行SELECT、INSERT、UPDATE和DELETE(例如,使用游标稳定性(curs or stability)隔离级别或未提交读(uncommitted read)隔离级别)。
Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table (for example, use isolation level cursor stability or uncommitted read).
释放行锁,以便其他应用程序可以对表执行SELECT、INSERT、UPDATE和DELETE(例如,使用游标稳定性(curs or stability)隔离级别或未提交读(uncommitted read)隔离级别)。
应用推荐