SYSHADOOP.APPLICATIONS view

The SYSHADOOP.APPLICATIONS view contains the catalog information about connections that are established to the Db2 server.

Authorization

SELECT privilege is granted to PUBLIC.

Table 1. SYSHADOOP.APPLICATIONS view
Column	Type	Description
APPLICATION_HANDLE	BIGINT	A number that uniquely identifies a specific application connection to the database manager. This number can be used during other operations, such as CANCEL APPLICATIONS, to identify which specific connection is to be canceled.
APPLICATION_NAME	VARCHAR(128)	The name of the application, such as `db2jcc_application`.
APPLICATON_ID	VARCHAR(128)	The application identifier, such as `9.55.153.75.54342.140415203234`.
MEMBER	SMALLINT	Identifies the node to which the client is connected.
SESSION_AUTH_ID	VARCHAR(128)	The current authorization ID for the session that is being used by this application
CLIENT_PID	BIGINT	The client process identifier.
REQUEST_STATE	VARCHAR(32)	UOW Indicates that the query is being executed. UOWWAIT Indicates that the state is in a wait mode, waiting for a request from the client. INTERRUPTED Indicates that the query has been interrupted.

Find all of the current applications that are connected to the Db2 server:

SELECT * FROM SYSHADOOP.APPLICATIONS;