Displays to standard output the application program name, authorization ID (user name), application handle, application ID, and database name of all active database applications. This command can also optionally display an application's sequence number, status, status change time, and database path.
This command only returns information for the database partition on which it is issued.
Instance. To list applications for a remote instance, it is necessary to first attach to that instance.
>>-LIST APPLICATIONS--+-----------------------------------+-----> '-FOR--+-DATABASE-+--database-alias-' '-DB-------' >--+----------------------------------------+-------------------> +-AT DBPARTITIONNUM--db-partition-number-+ '-GLOBAL---------------------------------' >--+-------------+--------------------------------------------->< '-SHOW DETAIL-'
If this option is specified, it is recommended that the output be redirected to a file, and that the report be viewed with the help of an editor. The output lines might wrap around when displayed on the screen. When a database is activated by a user other than the database administrator or an user without SYSADM authority the authorization ID will be shown as the non system user.
list applications for database sample show detail
The database administrator can use the output from this command as an aid to problem determination. In addition, this information is required if the database administrator wants to use the GET SNAPSHOT command or the FORCE APPLICATION command in an application.
To list applications at a remote instance (or a different local instance), it is necessary to first attach to that instance. If FOR DATABASE is specified when an attachment exists, and the database resides at an instance which differs from the current attachment, the command will fail.
LIST APPLICATIONS only shows user applications while LIST APPLICATIONS SHOW DETAIL shows all applications including the system applications. Event monitors are an example of system applications. System applications usually appear in snapshot output with application names beginning "db2" (for example, db2stmm, db2taskd). For additional information, see the Related links section about the is_system_appl monitor element.