Inactive Threads
This panel shows information about inactive threads. The information is collected from a Db2 display thread command.
A distributed thread is accessing a remote site on behalf of a request from another location. The thread is currently an inactive connection (type 2 inactive thread). It is waiting for an agent to become available.
Each row displays information about an individual
inactive thread. The columns are ordered by location name initially.
________________ ZINACU VTM O2 V550./C SZ11 G 08/31/13 13:40:59 2
> Help PF1 Back PF3 Up PF7 Down PF8 Sort PF10
> U.I
> Thread Activity: Enter a selection letter on the top line.
> A-All-Idle B-TSO C-CICS D-IMS E-Background F-Dist Allied
> G-Dist DBAC H-Util *-Inact J-Filter K-Functions L-Stored Proc
> M-Triggers N-Sysplex O-Enclaves P-Worksta Q-All+Idle
===============================================================================
> Inactive Threads
THDW
+ *
+ Location Authid Corrid Plan Token
+ ------------------------------------- --------- ------------ -------- ------
+ ::FFFF:9.65.90.233 HONG db2jcc_appli DISTSERV 8155
+ LUW ID : G9415AE9.DE1F.CBE4864A37F6=8155 MEMBER: SZ11
+ Connection Name: SERVER
+ End User ID :
+ hong
+ Workstation ID :
+ 9.65.90.233
+ Transaction ID :
+ db2jcc_application
+ Correlation TKN:
+ N/P
+ Accounting Text:
+ N/P
+
+ ::FFFF:9.65.90.233 HONG db2jcc_appli DISTSERV 13565
+ LUW ID : G9415AE9.DE1E.CBE485F2CBEE=13565 MEMBER: SZ12
+ Connection Name: SERVER
+ End User ID :
+ hong
+ Workstation ID :
+ 9.65.90.233
+ Transaction ID :
+ db2jcc_application
+ Correlation TKN:
+ N/P
+ Accounting Text:
+ N/P
===============================================================================
Navigation
For additional information about
- A different Db2 subsystem, data sharing group, or member of a data sharing group, enter the name of a Db2 subsystem, group, or member in the topmost row and press Enter.
- other types of threads, select one of the options at the top of the panel.
- other topics, use the PF keys.
Fields
- Location
- The network address of the remote location. This value might be blank.
- Authid
- The authorization identifier that is associated with a signed-on connection.
- Corrid
- The correlation identifier.
- Plan
- The plan name that is associated with the thread. For distributed
database access threads, this field contains one of the following
values:
- DISTSERV
- For threads that use application-directed access from a non-DB2 requester, a plan name is not identified.
- requester-value
- For threads that use system-directed access or application-directed access from a Db2 requester, this value is the plan name that is being executed at the requesting location.
- Token
- The thread token that is assigned to the thread.
- LUW ID
- The output is in the format of
text=num- text
- The global logical unit of work ID (LUWID).
- num
- The local token that identifies the thread. This token can be used in place of the LUWID in any Db2 command that accepts LUWID as input.
- Member
- The data sharing group member name for this DB2 subsystem. For Db2 subsystems
that do not belong to a data sharing group,
N/Pis displayed. - Connection Name
- The connection name that is used to establish the thread. For
distributed database access threads, this field contains the following
information:
- requester-value
- For threads that access the server from a DB2 for z/OS® requester, this value is the connection name of the thread at the requesting location.
- SERVER
- For threads that access the server from a non-DB2 for z/OS requester, a connection name is not identified.
- blank
- For threads where the originating task is running on the same DB2 subsystem, this value is blank.
- End User ID
- The user ID of the end user.
- Workstation ID
- The name of the workstation.
- Transaction ID
- The name of the client application.
- Correlation TKN
- The correlation token consists of the following components:
- ip-address
- The length of the IP address can be from 3 to 39 characters.
- port-address
- The length of the port address can be from 1 to 8 characters.
- unique-id
- The length of the unique ID is 12 characters.
- Accounting Text
- The client end-user accounting information. This information is provided if the appropriate information is provided by the client system and if Db2 recognizes the format of the information.