APPLICATIONS

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

Authorization

A SELECT privilege is granted to PUBLIC.

Table 1. SYSHADOOP.APPLICATIONS
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.

Examples

Find all of the current applications that are connected to the Db2 Big SQL server:
SELECT * FROM SYSHADOOP.APPLICATIONS;