Db2 Connect Server
This panel shows information about a Db2 Connect server that is related to the previously selected Distributed Database Access Thread (DBAT).
If the distributed
thread does not have a connection through a Db2 Connect
gateway, or if the Performance Expert Agent for Db2
Connect Monitoring (PE Agent) is not installed or not running on the Db2 Connect Server, the message No Db2 Connect server data
available is displayed.
________________ ZTDBC VTM O2 V540./C DA61 03/06/14 12:49:02 2
> Help PF1 Back PF3
>
> THREAD INFORMATION: Enter a selection letter on the top line.
>
> *-DB2 Connect Server B-Overview C-Statement Info D-Package Statistics
>
===============================================================================
> DB2 Connect Server
PLAN
+ Thread: Plan=DISTSERV Connid=SERVER Corrid=javaw Authid=MIS
+ Dist : Type=DATABASE ACCESS, Luwid=G9987A90.A2F1.CCCFEFB7D0DA=214
+ Location : ::FFFF:9.152.122.144
+ Host Name:polk.boeblingen.de.ibm.com
tdbc
+
+ DB2 Connect Server Information:
+ --------------------------------------------
+ Name = POLK
+ IP Address = 9.152.122.144
+ Node Name = N/P
+ Node Number = 0
+ Server Product/Version ID = SQL09078
+ Server Instance Name = db2inst1
+ Server Version = 7
+ Time Zone Displacement = 1h 0mn
=============================================================================== Fields
Thread identifier: This information identifies the thread to which the information in this
panel applies.
- Plan
- The Db2 plan name of the active thread.
- Connid
- The Db2 connection identifier of the active thread.
- Corrid
- The Db2 correlation identifier of the active thread. If the correlation is not set, N/A is displayed.
- Authid
- The Db2 authorization identifier of the active thread.
- Attach
- Depending on the type of connection, the appropriate information is displayed.
- Connection Type
-
- Batch
- The MVS jobname and ASID.Note: For threads from remote Db2, the MVS job name is N/A.
- CICS®
- The CICS jobname, task name, task number, terminal ID,
and thread type. The thread type is:
- Pool
- The thread in use is a pool thread.
- Entry
- The thread in use is a nonprotected entry thread.
- Prot
- The thread in use is a protected thread. Protected threads are defined in an RCT entry definition using the THRDS operand.
- IMS
- The IMS region number, transaction name, region name, and terminal ID (LTERM).
- RRSAF
- The MVS job name and ASID.Note: For threads from remote Db2, the MVS job name is N/A.
- System
- The originating Db2 job name and the resource manager that is the source of the thread. An additional line below the Attach line identifies the user thread, if any, being served by the system thread.
- TSO
- The TSO user ID and region ASID.
- Utility
- No additional information.
- Db2
- The Db2 subsystem identifier.
- MVS
- The MVS system identifier.
- ORIGAUTH
- The original (primary) Db2 authorization identifier of the thread. This field displays only when the original identifier is different from the Authid.
Package identifier: This information identifies the package to which the information in
this panel applies.
Distributed thread identifier: The following fields are displayed if the thread has a
distributed relationship with a remote Db2 subsystem.
- Type
- The distributed thread type.
- Distributed Allied
- A requesting thread; one that has issued an SQL call to a remote Db2 location.
- Database Access
- A responding thread; one that is serving a remote Db2 location by responding to an SQL call.
- Db2=
- The Db2 subsystem ID, indicating the member of the data sharing group of this thread.
- Luwid
- This value consists of two parts: the logical unit of work ID (luw-id) and a
token. The token can be used in place of the luw-id in any Db2
command that accepts luw-id as input. Format:
luw-id=tokenThe luw-id consists of the network name, the originating VTAM® LUNAME, and a unique identifier (separated by periods). Thus, the Luwid field displays data like in the following example:
USCACO01.O2D22A.A1FE8E04B9D4=8 - System
- The originating Db2 job name and the resource manager that is the source of the thread. An additional line below the Attach line identifies the user thread, if any, being served by the system thread.
- DB2C Master
- Shows the name of the member of the data sharing group that controls Db2 Connect monitoring for the group. If
N/Ais shown, the DB2C Master is currently being changed. For more information, see the description of panel Redirect Monitoring to Another Db2.
Db2 Connect Server Information:
- Name
- Shows the name in the database manager configuration file at the client node. It identifies the client node that is running the application.
- IP Address
- Shows the current IP address.
- Node Name
- Shows the name of the node being monitored by the database system monitor. It identifies the database server node being monitored.
- Node Number
- Shows the number assigned to the node in the db2nodes.cfg file.
- Server Product/Version ID
- Shows the product and version that is running on the Db2 data server in the form pppvvrrm, where:
- ppp stands for SQL
- vv identifies a 2-digit version number (with high-order 0 in the case of a 1-digit version)
- rr identifies a 2-digit release number (with high-order 0 in the case of a 1-digit release)
- m identifies a 1-digit modification level
- Server Instance Name
- Shows the name of the database manager instance for which the snapshot was taken.
- Server Version
- Shows the version of the Db2 data server returning the information.
- Time Zone Displacement
- Shows the number of hours and minutes that the local time zone is displaced from Greenwich Mean Time (GMT).