Field

Description

Application

PID

Process ID of the database process belonging to a SAP work process

Handle

A system-wide unique ID for the application. On multi-partition database systems, this ID will be the same on every node where the application may make a secondary connection.
Several agent processes (DB2 agent) can be assigned to an application handle.

Connect Start

Start time when the application connected to the database

Platform

Operating system on which the client application is running

Host

Host name of the application server where the application server is running

Name

Name of application running at the client as known to the database manager or DB2 connect

Status

Current status of the application. Possible values are:

-     Database Connect Pending
The application has initiated a database connection but the request has not yet completed.

-     Database Connect Completed
The application has initiated a database connection and the request has completed.

-     Unit of Work Executing
The database manager is executing requests on behalf of the unit of work.

-     Unit of Work Waiting
The database manager is waiting on behalf of the unit of work in the application. This status typically means that the system is executing in the application's code.

-     Lock Wait
The unit of work is waiting for a lock. After the lock is granted, the status is restored to its previous value.

-     Commit Active
The unit of work is committing its database changes.

-     Rollback Active
The unit of work is rolling back its database changes.

-     Recompiling
The database manager is compiling an SQL statement or precompiling a plan on behalf of the application.

-     Request Interrupted
An interrupt of a request is in progress.

-     Database Disconnect Pending
The application has initiated a database disconnect but the command has not yet completed executing. The application may not have explicitly executed the database disconnect command. The database manager will disconnect from a database if the application ends without disconnecting.

-     Transaction prepared
The unit of work is part of a global transaction that has entered the prepared phase of the two-phase commit protocol.

-     Transaction Heuristically Committed
The unit of work is part of a global transaction that has been heuristically committed.

-     Transaction Heuristically Rolled Back
The unit of work is part of a global transaction that has been heuristically rolled-back.

-     Transaction Ended
The unit of work is part of a global transaction that has ended but hast not yet entered the prepared phase of the two-phase commit protocol.

-     Creating Database
The agent has initiated a request to create a database and that request has not yet completed.

-     Restarting Database
The application is restarting a database in order to perform crash recovery.

-     Restoring Database
The application is restoring a backup image to the database.

-     Backing Up Database
The application is performing a "fast load" of data into the database.

-     Data Fast Load
The application is performing a "fast load" of data into the database.

-     Data Fast Unload
The application is performing a "fast unload" of data from the database.

-     Wait to Disable Tablespace
The application has detected an I/O error and is attempting to disable a particular tablespace. The application has to wait for all other active transactions on the tablespace to complete before it can disable the tablespace.

-     Quiescing a Tablespace
The application is performing a QUIESCE TABLESPACE request.

-     Wait for Remote Node
The application is waiting for a response from a remote node in a partitioned database instance.

Agent

PID

Process ID of an SAP work process that made the connection to the database