MDB2THRD - Monitor DB2® threads

The MDB2THRD view shows general information about monitored DB2 threads defined in the DB2 DSNCRCT table. The threads are listed by initial transaction ID.

Availability

The MDB2THRD view is available for all managed CICS® systems except CICS for Windows.

Access

Issue command:
MDB2THRD [init-tran]

init-tran
Is the specific or generic name of an initial transaction assigned to a DB2 thread. If you omit this parameter, the view includes information about all monitored DB2 threads within the current scope.

Select:
DB2 from the MONITOR menu and MDB2THRD from the DB2 submenu.

Figure 11 is an example of the MDB2THRD view.

Figure 11. The MDB2THRD view
 27FEB2005  09:27:50 ----------- INFORMATION DISPLAY ---------------------------
 COMMAND  ===>                                                 SCROLL ===> PAGE
 CURR WIN ===> 1        ALT WIN ===>
  W1 =MDB2THRD==========EYUPLX01=EYUPLX01=27FEB2005==09:27:45=CPSM=========64===
 CMD Initial CICS     Use     Thread  Thread   Maximum  DB2
 --- Tran--- System-- Count-- Waits-- Authrzd- Cncrrnt- Subsys
     DB2P    EYUMAS1A       0       0        0        3 DBH2
     DB2P    EYUMAS1B       0       0        0        3 DB2J
     DB2T    EYUMAS1A       0       0        0        3 DBH2
     DB2T    EYUMAS1B       0       0        0        3 DB2J
     DB20    EYUMAS1A       0       0        0        1 DBH2
     DB20    EYUMAS1B       0       0        0        1 DB2J
     D22X    EYUMAS1A    9975       0      135       97 DBH2
     D22X    EYUMAS1B       0       0        0        5 DB2J
     D23X    EYUMAS1A       0       0        0        5 DBH2
     D23X    EYUMAS1B    4760       6        5        5 DB2J
 

Action commands

None.

Hyperlinks

Table 21 shows the hyperlink field for the MDB2THRD view.

Table 21. MDB2THRD view hyperlink field
Hyperlink field View displayed Description
Initial Tran MDB2TRDD Detailed view of the specified DB2 thread.
Note:
You can also display the MDB2THRS view by issuing the SUM display command.
[[ Contents Previous Page | Next Page Index ]]