DB2 Connect User's Guide

Getting Snapshot Monitor Data for DB2 Connect

This section summarizes the new command formats for the Snapshot Monitor enhancements provided by DB2 Connect Enterprise Edition Version 5.2.

The syntax and output of the GET SNAPSHOT CLP command has been changed. The command has five new clauses that allow the user to display statistics about a specific DCS application currently running on the DB2 Connect Gateway or all DCS applications, as well as about a specific DCS database or all DCS databases.

Here are the new forms of the GET SNAPSHOT command:

To display statistics for the specified DCS application:

   GET SNAPSHOT FOR DCS APPLICATION [APPLID appl-id | AGENTID agentid]

To display statistics for all DCS applications currently being executed.:
```
   GET SNAPSHOT FOR ALL DCS APPLICATIONS
```
To display statistics for the specified DCS database:
```
   GET SNAPSHOT FOR DCS DB ON <db_alias>
```
To display statistics for all currently active DCS databases:
```
 GET SNAPSHOT FOR ALL DCS DATABASES
```
To display statistics for all DCS applications connecting to the specified DCS database:
```
   GET SNAPSHOT FOR DCS APPLICATIONS ON <db_alias>
```

Changed Output from the Existing Forms of GET SNAPSHOT Command

The output from the commands GET SNAPSHOT FOR APPLICATION, GET SNAPSHOT FOR ALL APPLICATIONS, and GET SNAPSHOT FOR APPLICATIONS ON <db_alias> will now display the following new data elements (when applicable):

Outbound communication protocol
Outbound communication address
Inbound communication address
TP Monitor client user ID
TP Monitor client workstation name
TP Monitor client application name
TP Monitor client accounting string
Transaction ID (XID)

The output from the command GET SNAPSHOT FOR DBM will now display the following new data elements:

Total number of connections for DB2 Connect since db2start
Current number of connections for DB2 Connect
Number of connections for DB2 Connect waiting for host to reply
Number of connections for DB2 Connect waiting for client to send a request

More information about the reports produced by the above GET SNAPSHOT commands can be found in the Command Reference, and What's New. Also, the GET SNAPSHOT API call sqlmonss has been enhanced to handle requests equivalent to the above commands. Details about the GET SNAPSHOT API call and the changes in its output can be found in API Reference.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]