DB2THRD - DB2 threads

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.

Availability

The DB2THRD view is available for CICS Transaction Server for OS/390, Version 1 Release 3 and later.

Access

Issue command:
DB2THRD [init-tran [db2plan [db2sys [Active]]]]

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.

Select:
DB2 from the OPERATE menu, and DB2THRD from the DB2 submenu.
Hyperlink from:
the DB2 ID field of the DB2SS view.

Figure 19 is an example of the DB2THRD view.

Figure 19. 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
 
 

Action commands

None.

Hyperlinks

Table 41 shows the hyperlink fields on the DB2THRD view.

Table 41. DB2THRD view hyperlink fields
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.
Note:
You can also display the DB2THRDS view by issuing the SUM display command.
[[ Contents Previous Page | Next Page Index ]]