The Application window shows information about the Application activity.
The grid located at the top of the window shows each database partition. It allows you to filter applications for each database partition.
The next grid shows each individual application with the following information for each one:
Name The name of the application running at the client, as known to the database or DB2(R) Connect server. Partition Database partition number. Agent A system-wide unique ID for the application. On a single-partitioned database, this identifier consists of a 16 bit counter. On a multi-partitioned database, this identifier consists of the coordinating partition number concatenated with a 16 bit counter. In addition, this identifier will be the same on every partition where the application may make a secondary connection. Auth The authorization ID of the user who invoked the application that is being monitored. On a DB2 Connect(TM) gateway node, this is the user's authorization ID on the host. Address This is the communication address of the client. For example, it could be an SNA net ID and LU partner name, or an IP address and port number for TCP/IP. PID The process ID of the client application that made the connection to the database. Status The current status of the application. DB Name The real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created. Con Time The date that an application started a connection request. Idle Time Number of seconds since an application has issued any requests to the server. This includes applications that have not terminated a transaction, for example not issued a commit or rollback.
By default, the last snapshot is displayed in the grid. Use the slidder (or the arrow buttons) located at the top of the grid to navigate through the collected snapshots. In monitoring, the "Update" button must be unchecked to be able to navigate through the collected snapshots.
Select one or more applications in the grid (Check box at the left of the grid) to update the graphes located at the bottom of the window. If several applications are selected, the statistics are aggregated.
Commit The total number of SQL COMMIT statements that have been attempted. Rollback The total number of SQL ROLLBACK statements that have been attempted. Static The number of static SQL statements that were attempted. Dynamic The number of dynamic SQL statements that were attempted. Failed The number of SQL statements that were attempted, but failed. Select The number of SQL SELECT statements that were executed. DDL This element indicates the number of SQL Data Definition Language (DDL) statements that were executed. Examples of DDL statements are CREATE TABLE, CREATE VIEW, ALTER TABLE, and DROP INDEX. UID The number of SQL UPDATE, INSERT, and DELETE statements that were executed.
Deleted This is the number of row deletions attempted. Inserted This is the number of row insertions attempted. Selected This is the number of rows that have been selected and returned to the application. Updated This is the number of row updates attempted.
Internal Rows (Unit/s)
Deleted This is the number of rows deleted from the database as a result of internal activity. Inserted The number of rows inserted into the database as a result of internal activity caused by triggers. Updated This is the number of row updates attempted.
Commits The total number of commits initiated internally by the database manager. Rollbacks The total number of rollbacks initiated internally by the database manager. Deadlock The total number of forced rollbacks initiated by the database manager due to a deadlock. A rollback is performed on the current unit of work in an application selected by the database manager to resolve the deadlock.
Cursors Blok (Unit/s)
Rejected The number of times that a request for an I/O block at server was rejected and the request was converted to non-blocked I/O. Accepted The number of times that a request for an I/O block was accepted.
Cursors Open (Unit)
Local Open The number of local cursors currently open for this application, including those cursors counted by Local Blocking. Local Blocking The number of local blocking cursors currently open for this application. Remote Open The number of remote cursors currently open for this application, including those cursors counted by Remote Blocking. Remote Blocking The number of remote blocking cursors currently open for this application.
Copyright © AgileLoad. All rights reserved.