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

DFHD2CC

XMEOUT parameters/Message inserts

  1. date
  2. time
  3. applid
  4. db2conn-name
  5. db2-id

Destination

CDB2 and Terminal End User



DFHDB2014.html | Timestamp icon Last updated: Sunday, 4 June 2017