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:
| 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
| 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
| 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:
|
| 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:
|
| 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:
|
| 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:
|
| 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:
|
| Number of times plan used | USECOUNT | The number of times the specified plan has been used. |