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:

CICS operations views > DB2, DBCTL and WebSphere MQ operations views > Threads in a CICS region

Table 1. Views in the supplied DB2 threads in a CICS region (DB2THRD) view set
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

Table 2. Fields in DB2THRD 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 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:
  • CHARSTR - Specific character string
  • NA - Authorization cannot be determined
  • NULL - No RACF group available for specified USERID.
  • 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)
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:
  • EQ - 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
  • DB2THRDD (from DB2THRD)
  • DB2TRAN (from DB2THRDD)
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:
  • YES - A sync point rollback is issued before returning control to the application.
  • NO - No rollback is issued.
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:
  • YES or TWAIT - If all threads are busy, a transaction will wait until one becomes available.
  • NO or NOTWAIT - If all threads are busy, a transaction will be terminated with an abend.
  • POOL - Specifies that, if all threads are busy, a transaction must be diverted to use the pool of threads. If the pool is also busy, and NO has been specified for the TWAIT or TWAITI parameter on the TYPE=POOL form of the macro, a transaction is terminated with an abend.
  • NA - Thread wait option cannot be determined.
Number of times plan used USECOUNT The number of times the specified plan has been used


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