Threads in a CICS region - DB2THRD
The DB2 thread in a CICS region (DB2THRD) views display information about all of the threads defined in the DB2 DSNCRCT table. The threads are listed by initial transaction ID. When a thread is shared by multiple DB2 transactions, the view shows the names of the sharing transactions. It is associated with the DB2THRD resource.
Supplied views
To access from the main menu, click:
| View | Notes |
|---|---|
| DB2 threads in a CICS region EYUSTARTDB2THRD.DETAILED |
Detailed information about a selected DB2 thread. |
| DB2 threads in a CICS region EYUSTARTDB2THRD.TABULAR |
Tabular information about DB2 threads. |
Actions
None.
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 performed | 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:
|
| Number of current threads | CURTHREADS | The number of threads currently active for this DSNCRCT entry |
| 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:
|
| Maximum number of threads | MAXTHREADS | The maximum number of active 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 | 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 exit for pool threads | 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:
|
| Number of reserved threads | RSVTHREADS | The number of started thread subtasks for this DSNCRCT entry, as specified on the THRDS= parameter |
| Peak number of concurrent 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 |