APPLICATIONS administrative view - Retrieve connected database application information

One of the following authorizations is required:

• SELECT privilege on the APPLICATIONS administrative view
• CONTROL privilege on the APPLICATIONS administrative view
• DATAACCESS authority

In addition, to access snapshot monitor data, one of the following authorities is also required:

• SYSMON
• SYSCTRL
• SYSMAINT
• SYSADM

Example 1: List information for all the active applications in the single-partitioned database SAMPLE.

SELECT AGENT_ID, SUBSTR(APPL_NAME,1,10) AS APPL_NAME, AUTHID, 
   APPL_STATUS FROM SYSIBMADM.APPLICATIONS WHERE DB_NAME = 'SAMPLE'

The following example is a sample output for this query.

AGENT_ID             APPL_NAME  AUTHID    APPL_STATUS
-------------------- ---------- ---------- ---------------------
                  23 db2bp.exe  JESSICAE   UOWEXEC

  1 record(s) selected.

Example 2: List the number of agents per application on database partition 0 for the multi-partition database SAMPLE.

SELECT SUBSTR(APPL_NAME, 1, 10) AS APPL_NAME, COUNT(*) AS NUM 
   FROM SYSIBMADM.APPLICATIONS WHERE DBPARTITIONNUM = 0 
   AND DB_NAME = 'SAMPLE' GROUP BY APPL_NAME

The following example is a sample output for this query.

APPL_NAME  NUM
---------- -----------
db2bp.exe            3
javaw.exe            1

  2 record(s) selected.