Locate the application, UOW and activity ID for the data.
确定数据的应用、UOW和活动id。
Locate the application, UOW, and activity ID for the data.
定位数据的应用、UOW和活动ID。
When a transaction (COMMIT or ROLLBACK) occurs or at the end of a unit-of-work (UOW)
当某个事务(COMMIT或ROLLBACK)发生或在工作单元 (UOW)结束时
The db2stop quiesce command waits for that UOW to be completed before stopping that member.
db2stopquiesce命令会等待UOW完成后才会停止该成员。
A transaction is a set of one or more statements that are executed together as a unit of work (UOW).
事务是一条或多条语句的集合,这些语句作为一个工作单元(UOW)一起执行。
Sometimes a unit of work (UOW) is started for a user session, but the UOW is not committed or rolled back.
有时一个用户会话会启动一个工作单元(UOW),但是 UOW不会提交或回滚。
Any applications that complete the UOW within the ten minutes are automatically rerouted to the active members.
任何在10分钟内完成这个UOW的应用都会自动转发到活跃成员。
Find the UOW ID and Activity ID using the following query by substituting the application handle found in Step 1.
通过替换第1步中找到的应用句柄,使用下面的查询来查找UOWID和Activity ID。
Only the first statement in a UOW is used to determine if rerouting the statement to another partition should occur.
只有UOW中的第一条语句被用于判断是否应该将语句重路由到另一个分区。
If, after ten minutes, the UOW is not completed, then the DB2 software will automatically force off that application.
如果在10分钟之后,UOW未完成,那么DB 2软件会自动强制关闭该应用程序。
Unless a timeout value is specified, the db2stop quiesce will have to wait for that UOW to be completed before stopping that member.
除非指定一个超时值,否则db2stop默认在停止该成员之前必须等待那个UOW完成。
Transactions are used to make sure that all transactions that are part of a UOW are executed or that none of them are executed at all.
使用事务是为了确保一个UOW中的所有处理要么一起执行,要么都不执行。
The locks are released when the process ends or when a commit operation releases locks that were acquired during a unit of work (UOW).
当进程结束,或者当提交操作释放在工作单元(unitof work,UOW)期间获得的锁时,锁就被释放。
In some cases you may encounter situations where a user session for which a unit of work (UOW) was started but was not committed or rolled back.
有时您会遇到这种情况,其中为一个工作单元(UOW)启动了用户会话,但是没有提及或回滚。
For situations like this, you can specify a timeout value, for example - ten minutes, which would allow the application ten minutes to complete the UOW.
对于这种情况,您可以指定一个超时值,例如10分钟,这将允许应用程序在10分钟内完成UOW。
In addition to this, deciphering the cause of a deadlock often requires understanding everything that has occurred in a UOW, not just what SQL statements were executed.
除此以外,解密死锁的原因通常需要了解UOW中出现的任何东西,不只是要了解执行了哪些sql语句。
It will collect all the detailed activity information including section explain and section actuals for the given combination of application ID, UOW ID, and activity ID.
而是会收集所有相关的活动信息,包括应用id、UOW ID和活动ID的特定组合的片段解释和片段实绩。
A UOW is a recoverable sequence of operations within an application process; it ends as a result of a commit operation, a rollback operation, or the end of the application process.
UOW是应用程序进程中的一个可恢复的操作序列;它由于提交操作、回滚操作或者结束应用程序进程而结束。
Under the heading List of Inactive SQL statements from current UOW, you see all the SQL statements that were executed in the lock owner's transaction prior to the occurrence of the lock timeout.
在标题Listof InactiveSQLStatementsfromcurrent UOW下边,可以看到在发生锁定超时之前锁持有者的事务执行的所有sql语句。
Under the heading List of Inactive SQL statements from current UOW, you see all the SQL statements that were executed in the lock owner's transaction prior to the occurrence of the lock timeout.
在标题Listof InactiveSQLStatementsfromcurrent UOW下边,可以看到在发生锁定超时之前锁持有者的事务执行的所有sql语句。
应用推荐