System Monitor Guide and Reference

LIST APPLICATIONS

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.

Scope

This command only returns information for the node on which it is issued.

Authorization

One of the following:

Required Connection

Instance. To list applications for a remote instance, it is necessary to first attach to that instance.

Command Syntax 

>>-LIST APPLICATIONS----+-------------------------------------+->
                        '-FOR--+-DATABASE-+---database-alias--'
                               '-DB-------'
 
>-----+-------------------+--+-------------+-------------------><
      +-AT NODE--nodenum--+  '-SHOW DETAIL-'
      '-GLOBAL------------'

Command Parameters

FOR DATABASE database-alias
Information for each application that is connected to the specified database is to be displayed. Database name information is not displayed. If this option is not specified, the command displays the information for each application that is currently connected to any database at the node to which the user is currently attached.

The default application information is comprised of the following:

AT NODE nodenum
Specifies the node for which the status of the monitor switches is to be displayed.

GLOBAL
Returns an aggregate result for all nodes in a partition database system.

SHOW DETAIL
Output will include the following additional information:
Note: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 may wrap around when displayed on the screen.

Examples

The following is sample output from LIST APPLICATIONS: 



Auth Id  Application    Appl.      Application Id                 DB       # of
         Name           Handle                                    Name    Agents
-------- -------------- ---------- ------------------------------ -------- -----
smith    db2bp_32       12         *LOCAL.smith.970220191502      TEST     1
smith    db2bp_32       11         *LOCAL.smith.970220191453      SAMPLE   1

Usage Notes

The database administrator can use the output from this command as an aid to problem determination.

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.

[ Top of Page | Previous Page | Next Page ]