Command 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:

sysadm
sysctrl
sysmaint

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:

Authorization ID
Application program name
Application handle
Application ID
Database name.

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. For details on how results are aggregated see the System Monitor Guide and Reference.

SHOW DETAIL

Output will include the following additional information:

Sequence #
Application status
Status change time
Database path.

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

Note: For more information about these fields, see the System Monitor Guide and Reference.

Usage Notes

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 GET SNAPSHOT or FORCE APPLICATION 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.

[ Top of Page | Previous Page | Next Page ]