Db2 Connect Server - Statement Information

This panel shows SQL statement-, time-, and network traffic-related information for 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.


________________ ZTCNS    VTM     O2       V550./C DA61 03/06/14 13:02:29   2  
> Help PF1                                                            Back PF3  
>                                                                               
>       THREAD INFORMATION:  Enter a selection letter on the top line.          
>                                                                               
> A-DB2 Connect Server  B-Overview   *-Statement Info   D-Package Statistics    
>                                                                               
=============================================================================== 
>              DB2 Connect Server - Statement Information                       
 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                                          
 tcns                                                                           
+                                                                               
+ SQL Statements                                                                
+ --------------------------------------------------------                      
+ Section Number                    =        2                                  
+ Query Cost Estimate               =        0                                  
+ Query Number of Rows Estimate     =        0                                  
+ Statement Operation               = SELECT                                    
+ Number of Successful Fetches      =        0                                  
+ Blocking Cursor                   =        0                                  
+ Outbound Blocking Cursor          =        0                                  
+ Application Creator               = NULLID                                    
+ Package Name                      = SYSLH100                                  
+ Stmt Trans: No of Transmissions   =        2                                  
+ Stmt Trans: No of Statements      =        3                                  
+                                                                               
+ Time                                                                          
+ --------------------------------------------------------------                
+ Statement Start Timestamp         = 2014-03-06-12.55.07.287000                
+ Statement Stop Timestamp          = N/P                                       
+ Time Spent on Gateway Processing  = 00:00:00.000000                           
+ Host Response Time                = 00:00:00.000000                           
+ Most Recent Stmt Elapsed Time     = 00:00:00.000000                           
+ Stmt Elapsed Execution Time       = 00:00:00.000000                           
+ Local: System CPU Time            = N/P                                       
+ Local: User CPU Time              = N/P                                       
+                                                                               
+ Network Statistics                                                            
+ --------------------------------------------                                  
+ Inbound Number of Bytes Sent      =        0                                  
+ Inbound Number of Bytes Received  =      508                                  
+ Outbound Number of Bytes Sent     =        0                                  
+ Outbound Number of Bytes Received =        0                                  
===============================================================================

Navigation

For additional information about

related topics, select one of the options at the top of the panel.
other topics, use the PF keys.

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.; Attach information is displayed only if the thread is a distributed allied thread (not for distributed database access threads).

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.

Package: The Db2 package name of the active thread. Up to 18 characters of the package name are returned.
Collection: The package collection identifier. This field is displayed only if a package is being used.

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=token

The 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/A is shown, the DB2C Master is currently being changed. For more information, see the description of panel Redirect Monitoring to Another Db2.

SQL statements:

Section Number: Shows the internal section number in the package for the SQL statement that is currently processing or has processed most recently.
Query Cost Estimate: Shows the estimated cost, in timerons, for a query, as determined by the SQL compiler.
Query Number of Rows Estimate: Shows the estimated number of rows that is returned by a query.
Statement Operation: Shows the statement operation that is currently being processed or has processed most recently (if none is currently running).
Number of Successful Fetches: For statement snapshot monitoring and statement event type, this is the number of successful fetches performed on a specific cursor.
Blocking Cursor: Indicates whether the statement being executed is using a blocking cursor.
Outbound Blocking Cursor: Indicates whether blocking is used for data transfer from DRDA server to the Db2 Connect gateway for a particular query.
Application Creator: Shows the authorization ID of the user who precompiled the application.
Package Name: Shows the name of the package that contains the SQL statement that is currently executing.
Stmt Trans: No of Transmissions: Shows the number of data transmissions between the Db2 Connect gateway and the host that was used to process this DCS statement.
Stmt Trans: No of Statements: Shows the number of SQL statements that have been attempted since the latter of: application startup, database activation, or last reset.

Time fields:

Statement Start Timestamp: Shows the date and time at which the statement operation started execution.
Statement Stop Timestamp: Shows the date and time at which the statement operation stopped execution.
Time Spent on Gateway Processing: Shows the time, in seconds and microseconds, at the Db2 Connect gateway to process an application request (since the connection was established), or to process a single statement.
Host Response Time: For a DCS statement, this is the elapsed time between the time that the statement was sent from the Db2 Connect gateway to the host for processing and the time when the result was received from the host.
Most Recent Stmt Elapsed Time: Shows the elapsed execution time of the most recently completed statement.
Stmt Elapsed Execution Time: For a DCS statement, this is the elapsed time spent processing an SQL request on a host database server.
Local: System CPU Time: Shows the total system CPU time, in seconds and microseconds, used by the statement that is currently executing.
Local: User CPU Time: Shows the total user CPU time, in seconds and microseconds, used by the statement that is currently executing.

Network Statistics fields:

Inbound Number of Bytes Sent: Shows the number of bytes sent by the Db2 Connect gateway to the client, excluding communication protocol overhead, for example, TCP/IP or SNA headers.
Inbound Number of Bytes Received: Shows the number of bytes received by the Db2 Connect gateway from the client, excluding communication protocol overhead, such as TCP/IP or SNA headers.
Outbound Number of Bytes Sent: Shows the number of bytes sent by the Db2 Connect gateway to the host, excluding communication protocol overhead, for example, TCP/IP or SNA headers.
Outbound Number of Bytes Received: Shows the number of bytes received by the Db2 Connect gateway from the host, excluding communication protocol overhead, such as TCP/IP or SNA headers.