DFHDB2014 date time applid Statistics report follows for db2conn-name accessing DB2 db2-id
Explanation
A CICS-DB2 attachment facility statistics display was requested and follows this message. The name of the DB2CONN that is currently in use is db2conn-name and db2-id, if not blank, is the name of the DB2 subsystem involved.
The statistics displayed are those that have been accumulated after the expiry of the last statistics collection interval, end of day expiry, or requested reset. These statistics represent a subset of those available as CICS-DB2 Global and resource statistics collected via the CICS statistics spi commands.
The following information is displayed for each DB2ENTRY and for the command and pool sections of the DB2CONN:
-
DB2ENTRY
The name of the DB2ENTRY or '*COMMAND' for the command section and '*POOL' for the pool section.
-
PLAN
DB2 Plan name
-
CALLS
Total number of SQL calls made
-
AUTHS
Total number of sign-on invocations for transactions associated with this entry. A sign-on does not indicate whether a new thread is created or an existing thread reused. If a thread is reused a sign-on may occur dependent on the ACCOUNTREC setting of the DB2ENTRY.
-
W/P
Number of times all available threads for this entry were busy and the transaction had to wait or the thread request was diverted to the POOL.
-
HIGH
Maximum number of concurrent threads required by transactions associated with this DB2ENTRY at any time since the last reset.
-
ABORTS
Total number of units of work that were rolled back.
-
COMMITS
One of the following two fields is incremented each time a DB2 transaction associated with this DB2ENTRY takes an explicit or implicit (end of task) syncpoint.
-
1-PHASE
The total number of single-phase commits for transactions associated with this DB2ENTRY.
-
2-PHASE
The total number of two-phase commits for transactions associated with this DB2ENTRY.
System action
Processing continues normally.
User response
None.
Module
XMEOUT parameters/Message inserts
- date
- time
- applid
- db2conn-name
- db2-id
Destination
CDB2 and Terminal End User