DB2:getConnectedApplications

Retrieves connected database application information.

Type

SYNC, IMPACT_INFO

Arguments

None.

Returns

Name

Type

Description

Database Name

String

Database Name.

Application Name

String

Application Name.

Agent ID

Integer

Application handle (agent ID).

Authorization ID

String

Authorization ID.

Application ID

String

Application ID.

Application Status

String

Application Status is one of: BACKUP, COMMIT_ACT, COMP, CONNECTED, CONNECTPEND, CREATE_DB, DECOUPLED, DISCONNECTPEND, INTR, IOERROR_WAIT, LOAD, LOCKWAIT, QUIESCE_TABLESPACE, RECOMP, REMOTE_RQST, RESTART, RESTORE, ROLLBACK_ACT, ROLLBACK_TO_SAVEPOINT, TEND, THABRT, THCOMT, TPREP, UNLOAD, UOWEXEC, UOWWAIT, WAITFOR_REMOTE.

DB Partition Number

Integer

The database partition from which the data was retrieved for this row.

Usage Notes

Invoking this method displays summarized information about application databases that are currently connected.