You can use the Management Console to:
Active StarPipes connections are displayed in the right pane. To refresh the display, click on the Refresh icon from the toolbar, press F5, or choose View Refresh from the menu bar. To sort the active connections into different categories, click on the column header on the right pane. A count of all the active connections is displayed in the lower left corner of the Management Console. You can also view the count of active connections in the Configuration Application Service panel.
The right pane displays session details including connection id, username, RDB name, and the client application name. Information may vary according to the ODBC driver being used and whether it is 32-bit or 16-bit. This pane also allows you to trace a specific connection or terminate an active one.
The StarPipes Management Console displays the following fields:
|
Field |
Description |
|---|---|
|
Connection ID |
The Windows process ID associated with this connection. |
|
Username |
The user ID used to login into DB2 as passed on the EXCSAT. This field may be blank if password encryption is used. |
|
RDB name |
The DB2 database server name and the relational database name specified in the StarSQL data source setup. This value is used to route the connections. |
|
Client Application (EXTNAM) |
The value in the EXCSAT command for EXTNAM. This value may vary depending on your ODBC or JDBC driver. If you are using StarSQL, the client machine login, the application name and the StarSQL version are displayed. |
|
Connect time |
Total time of the connection, including idle time and time waiting for DB2 to respond. The format is HH:MM:SS. |
|
Idle time |
The total idle time since the last client activity. Each time the connection becomes active, the idle timer is reset. The format is HH:MM:SS. |
|
Avg turn |
Average turn-around time in seconds for StarPipes to receive a request from PC client and return DB2 response. |
|
Avg rsp |
Average response time in seconds for StarPipes to receive data from DB2 and return data to PC client. Subtract the average turnaround time from average response to calculate the average StarPipes processing time for the client request |
|
Bytes sent |
Total bytes sent by the client. |
|
Bytes rcvd |
Total bytes received by the client |
|
#CCs |
The number of command chains (SQL commands) sent by StarPipes |
|
Client IP |
The IP address of the client machine. |
|
Route (CSI) |
The connection parameters that StarPipes uses to connect to DB2. If the connection is an SNA-APPC connection, the format is Local LU:Remote LU: Mode. If the connection is a native TCP/IP connection, the format is RDBNAME:Listening Port:*TCPIP. If the connection is an SSL connection, the format is RDBNAME:Listening Port:*SSL. |
|
Trace |
The status of tracing for this connection. |
To kill a connection:
Highlight the connection you want to terminate.
Right-click and select Kill from the context menu.