Threads - MDB2THRD

The Monitor data for DB2 threads (MDB2THRD) views display information about monitored DB2 threads defined in the DB2 DSNCRCT table. The threads are listed by initial transaction ID.

Supplied views

To access from the main menu, click:

Monitoring views > DB2 monitoring views > Threads

Table 1. Views in the supplied Monitor data for DB2 threads (MDB2THRD) view set
View Notes
Monitor data for DB2 threads

EYUSTARTMDB2THRD.DETAILED

Detailed information about a selected DB2 thread.
Monitor data for DB2 threads

EYUSTARTMDB2THRD.DISCARD

Removes a DB2 thread from CICSPlex SM monitoring for the current sample interval and discards its accumulated statistics.
Monitor data for DB2 threads

EYUSTARTMDB2THRD.RESET

Resets the CICSPlex SM statistics counters associated with a DB2 thread to 0.
Monitor data for DB2 threads

EYUSTARTMDB2THRD.TABULAR

Tabular information about display information about monitored DB2 threads.

Actions

Table 2. Actions available for MDB2THRD views
Action Description
DISCARD Removes a DB2 thread from CICSPlex SM monitoring for the current sample interval and discards its accumulated statistics.
RESET Resets the CICSPlex SM statistics counters associated with a DB2 thread to 0.

Fields

Table 3. Fields in MDB2THRD views
Field Attribute name Description
Number of aborts ABORTCNT The number of units of recovery, including both abends and sync point rollbacks, that were rolled back. This count is incremented only when CICS calls DB2 with an abort call during commit processing; other types of DB2 aborts are not counted.
Number of authorizations done AUTHCNT The number of authorization checks that have been performed for this DSNCRCT entry.
Authorization type AUTHTYPE The type of authorization for this transaction, as defined by the first AUTH= subparameter of the DSNCRCT entry:
  • CHARSTR - Specific character string
  • N/A - Authorization cannot be determined
  • RACFGID - RACF user-ID and group name
  • SIGNID - CICS system authorization ID
  • TERMID - Terminal ID
  • TRANID - Transaction ID
  • USER - User operator ID (3-character)
  • USERID - Sign-on user ID (8-character)
Current number of threads CURTHREADS The number of threads currently defined for this DSNCRCT entry.
Usage rate for current sample CURUSERATE The rate of DB2 usage based on the current sample.
Dispatching mode DPMODE The dispatching priority for connection subtasks relative to CICS, as specified on the DPMODE= or DPMODI= parameter of the DSNCRCT entry:
  • EQUAL - Subtasks must be allowed to have equal priority with CICS.
  • HIGH - Subtasks can have a higher priority than CICS.
  • LOW - Subtasks will have a lower priority than CICS.
Initial transaction INITTRAN Identifies the first transaction in the thread, as specified on the TXID= parameter of the DSNCRCT entry. The value shown here depends upon which TYPE= statement was used:
  • -CMD - TYPE=COMD
  • -POL - TYPE=POOL
  • tranid - TYPE=ENTRY
Interval identifier INTERVALID The ID of the interval.
Usage rate for interval INTUSERATE The usage rate based on an interval.
Maximum number of threads MAXTHREADS The maximum number of threads for this DSNCRCT entry, as specified on the THRDM= parameter.
DB2 subsystem NAME The name of the DB2 subsystem to which this thread belongs.
Number of transactions in group OTHERIDS The number of other transactions specified on the TXID= parameter of the DSNCRCT entry.
Plan name if not dynamic allocation PLANNAME The name of the application plan associated with this transaction, as specified on the PLAN= parameter of the DSNCRCT entry.

If this field is blank, no plan name was specified. A value of '********' means plan name does not apply because the PLNEXIT=YES parameter was specified.

Dynamic plan allocation exit program PLANPRGM The name of the exit program for this transaction, as specified on the PLANPGME= parameter of the DSNCRCT entry. If this field is blank, no exit program name was specified.
Number of read only commits READCOMMIT The number of read-only commits processed for transactions associated with this thread.
Rollback option ROLLBACKOPT The rollback option for this transaction, as specified on the ROLBE= or ROLBI= parameter of the DSNCRCT entry:
  • YES - A sync point rollback is issued before returning control to the application.
  • NO - No rollback is issued.
Reserved threads RSVTHREADS The number of started thread subtasks for this DSNCRCT entry, as specified on the THRDS= parameter.
Peak number of threads in use THREADHWM The maximum number of threads the attachment facility allows to be connected for this DSNCRCT entry, as specified on the THRDA= parameter.
Number of thread waits THREADWAIT The number of times this transaction has had to wait for a thread.
Thread wait option THREADWOPT The thread wait option for this DSNCRCT entry, as specified on the TWAIT= or TWAITI= parameter. This value indicates how the transaction will respond when all threads are busy:
  • YES - Waits for a thread in the current entry.
  • NO - Terminates with an abend.
  • POOL - Makes use of the next available pool thread.
Number of times plan used USECOUNT The number of times the specified plan has been used.


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