DSNJ031I csect-name WARNING - UNCOMMITTED UR HAS WRITTEN number LOG RECORDS - CORRELATION NAME = correlation-name CONNECTION ID = connection-id LUWID = logical-unit-of-work-id=token PLAN NAME = plan-name AUTHID = authorization-id END USER ID = user-id TRANSACTION NAME = transaction-name WORKSTATION NAME = workstation-name
Explanation
A unit of recovery (UR) has reached the threshold number of log records that were written without a commit or rollback operation. This threshold was defined during installation in subsystem parameter URLGWTH.
- csect-name
- The name of the control section that issued the message.
- number
- The cumulative number of log records that were written since the beginning of the UR.
- correlation name
- The correlation name that is associated with the UR.
- connection-id
- The connection ID that is associated with the UR.
- logical-unit-of-work-id
- The logical unit of work ID. An asterisk (*) denotes that the
thread originated at the local site.
This value consists of a fully qualified LU network name followed by a period and an LUW instance number. The LU network name consists of a one- to eight-character network ID, a period, and a one- to eight-character network LU name. The LUW instance number consists of 12 hexadecimal characters that uniquely identify the unit of work.
- token
- A unique token number that is associated with the logical unit of work ID.
- plan-name
- The plan that is associated with the UR.
- authorization-id
- The authorization ID that is associated with the UR.
- user-id
- The user ID that is associated with the UR, if known. Otherwise, an asterisk (*).
- transaction-name
- The transaction that is associated with the UR, if known. Otherwise, an asterisk (*).
- workstation-name
- The workstation hostname that is associated with the UR, if known. Otherwise, an asterisk (*).
System action
Processing continues. If statistics class 3 is active, IFCID 0313 is written.
This message is repeated each time the threshold is reached.
System programmer response
Consult with the application programmer to determine if this UR is problematic.
If an application program caused the UR to reach its threshold number of log records, you can use CANCEL THREAD (token) to cancel the UR. If you cancel an uncommitted UR, Db2 rolls back the changes. The amount of time that is required for this process depends on the amount of work that was done by the UR.
Programmer response
Ensure that the application commits frequently enough, or consult with your Db2 administrator about increasing the threshold number of log records. Use the URLGWTH subsystem parameter.