我一直认为read_committed (DB 2调用游标稳定性(CS))意味着你不锁上读,那你只能读提交的数据。
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.
在读事务中,没有变更需要提交,但是事务会防止对正在被读取的数据的修改,直到所有的读操作全部结束。
In a read transaction, there are no changes to commit, but the transaction prevents the data being read from changing until all of the reads are complete.
将分割镜像初始化为快照时,将执行崩溃恢复,回滚所有未提交的事务,并使数据库可以被所有读或写操作访问。
The initialization of the split mirror as snapshot performs a crash recovery, rolls back all uncommitted transactions, and makes the database available for any read or write operation.
事务再次读取某数据时发现它自最后一次读操作之后由于另一个事务修改并提交了该数据而发生了更改,则会发生不可重读。
An unrepeatable read can occur when the transaction reads some data again and finds that it changed since the last read due to another transaction that modified this data and committed.
读事务需要数据的一致视图 ——即当同时提交两个读事务时,如果它们选择相同的数据范围,那么应该产生一致的结果集。
Read transactions require a consistent view of the data -- meaning if two read transactions are submitted at the same time, they should produce uniform result sets if they select the same data ranges.
当事务再次执行查询,并发现一组结果自最后一次查询后由于另一个事务提交了新的数据而发生了更改,则会发生幻像读。
A phantom read occurs when a transaction re-executes a query and finds a set of results changed since the last query due to another transaction that committed new data.
会发生不可重读、幻像读和读未提交数据。
An unrepeatable read, phantom read, and reads of uncommitted data can occur.
支持表级和行级锁以及4个隔离级别:RR(可重复读)、RS(读可靠)、CS(默认——游标可靠)和UR(未提交读)。
Supports table and row level locking and 4 isolation levels, RR (repeatable read), rs (read stability), CS (default - cursor stability) and ur (uncommitted read).
例如,如果一个成员正在更新一行数据,那么另一个成员就不能以未提交读(uncommitted read)以外的任何隔离级别读取这一行。
For example, if one member is updating a row, it would not be proper for another member to read the row with any other isolation level than uncommitted read.
脏读:A 1检索a 2未提交的数据。
Readcommitted(读已提交) ——事务可以读取由另一事务提交的数据。
Read committed -- The transaction can read data committed by other transactions.
释放行锁,以便其他应用程序可以对表执行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).
提交读,未提交读,可重复读,可串行读。
Read committed, Read uncommitted, Repeatable Read, Serializable.
比如,读取只读的查找表不需要可重复读级别,未提交读级别就足够了。
For example, reading from a read - only look up table doesn t require repeatable read, and uncommitted read is sufficient.
虽然他曾为校刊撰写过一些幽默专栏,但后来报读一个创意写作班时却被拒之门外,得到的解释是,他提交的作品样本较为逊色。
Despite 11 penning a few humor columns for the school paper, he was subsequently rejected from a creative-writing class because of what he was told were weak sample submissions.
当表单提交时我读隐藏表单字段与用户的会话令牌比较。
When form is submitted I read hidden form field and compare it with token in user session.
胡斯尼说,商品及服务税条例草案,将在目前的议会会议,并预计将于二读2010年3月提交的一读审议。
Husni said the GST Bill would be tabled for first reading in the current sitting of Parliament and is expected to be tabled for second reading March 2010.
胡斯尼说,商品及服务税条例草案,将在目前的议会会议,并预计将于二读2010年3月提交的一读审议。
Husni said the GST Bill would be tabled for first reading in the current sitting of Parliament and is expected to be tabled for second reading March 2010.
应用推荐