不过,让其事务看到未提交的数据可以带来意料之外的副作用,如更新冲突和读取不一致等。
Letting uncommitted data be seen by other transactions, however, can result in unexpected side effects, such as clashing updates and inconsistent reads.
我们还可以选择使用COMMIT或ROLLBACK选项在SQL或OS错误期间提交或回滚未提交的事务。
We can also choose to commit or roll back the uncommitted transactions during SQL or OS errors using commit or ROLLBACK options.
ACR不会重放正在运行的事务,建立客户机连接后,所有未提交的工作必须重新执行。
ACR does not replay in-flight transactions, and once the client connection is established, any uncommitted work will have to be performed.
如果未捕获此异常,则缺省操作是提交事务(包括CICS执行的所有工作),直到异常终止点。
If this exception is left uncaught, the default action will be to commit the transaction, including all work performed by CICS, up to the point of the abend.
将分割镜像初始化为快照时,将执行崩溃恢复,回滚所有未提交的事务,并使数据库可以被所有读或写操作访问。
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.
DB2在执行索引或表扫描时,如果遇到一个被另一个事务独占 (X)锁定的未提交行,那么 DB2 将阻塞在行锁上。
When DB2 performs an index or table scan, DB2 will block on a row lock when it comes across an uncommitted row which another transaction has exclusively (X) locked.
UR:允许应用程序访问其他事务未提交的更改。
UR: Allows an application to access uncommitted changes of other transactions.
崩溃恢复是对日志文件进行处理,确保所有已提交的事务被写到磁盘,所有未提交的事务被回滚。
Crash recovery is the processing of the log files, making sure all committed transactions are written to disk and uncommitted transactions are rolled back.
该参数只会当超过logprimary值时才会分配日志文件,这种情况最有可能在一系列长时间未提交的事务期间发生。
This parameter only causes an allocation of log files when the logprimary value is exceeded, which most likely can happen during a series of long uncommitted transactions.
此点保证不存在这样的事务:在一个日志中显示为已提交,在另一个日志中显示为未提交。
At this point, it is guaranteed that there are no transactions that appear as committed in one log, but not committed in another log.
在前一主体上,客户端断开了与数据库的连接,并且未提交的事务将回滚。
On the former principal, clients are disconnected from the database and in-flight transactions are rolled back.
事务隔离:当前事务和其它事务的隔离的程度。例如,这个事务能否看到其他事务未提交的写数据?
Isolation: the degree of isolation this transaction has from the work of other transactions. For example, can this transaction see uncommitted writes from other transactions?
这个协议可以避免死锁,而且高优先级事务不会被未提交的低优先级事务阻塞。
We show that this protocol is free of deadlock and in addition a high priority transaction is not blocked by uncommitted lower priority transactions.
这个协议可以避免死锁,而且高优先级事务不会被未提交的低优先级事务阻塞。
We show that this protocol is free of deadlock and in addition a high priority transaction is not blocked by uncommitted lower priority transactions.
应用推荐