The DB2THRD view shows general 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 DB2TRAN view shows the names of the sharing transactions.
The DB2THRD view is available for CICS Transaction Server for OS/390, Version 1 Release 3 and later.
init-tran
is the specific
or generic name of an initial transaction assigned to a DB2 thread or *
for all initial transactions.
db2plan
is
the specific or generic name of a DB2 plan. Use this parameter to determine
what initial transactions make use of a particular plan.
db2sys
is the specific or generic name of a DB2
subsystem.
Active
Limits the
view to currently active DB2 threads.
If you do not specify parameters, the view includes information about all DB2 threads in use within the current scope.
Figure 19 is an example of the DB2THRD view.
27FEB2005 09:26:18 ----------- INFORMATION DISPLAY ----------------------------- COMMAND ===> SCROLL ===> PAGE CURR WIN ===> 1 ALT WIN ===> W1 =DB2THRD===========EYUPLX01=EYUPLX01=27FEB2005==09:26:18=CPSM===========64= CMD Initial Plan DB2 CICS Other Use Thread Thread Current --- Tran--- Name---- Subsys System-- IDs Count Maximum Subtasks Threads -CMD DBH2 EYUMAS1A 0 0 2 0 0 -CMD DB2J EYUMAS1B 0 0 2 0 0 -POL DEFAULT DBH2 EYUMAS1A 0 0 3 3 0 -POL DEFAULT DB2J EYUMAS1B 0 0 3 3 0 BOK0 TLOK0 DBH2 EYUMAS1A 0 0 5 0 0 BOK0 TLOK0 DB2J EYUMAS1B 0 0 5 0 0 BOK1 TLOK1 DBH2 EYUMAS1A 0 0 5 0 0 BOK1 TLOK1 DB2J EYUMAS1B 0 0 5 0 0
None.
Table 41 shows the hyperlink fields on the DB2THRD view.
Hyperlink field | View displayed | Description |
---|---|---|
Initial Tran | DB2THRDD | Detailed view of the specified DB2 thread. |
Other IDs | DB2TRAN | General view of the transaction IDs associated with the specified DB2 initial transaction ID. |