System Monitor Guide and Reference

LIST DCS APPLICATIONS

Displays to standard output information about applications that are connected to host databases via DB2 Connect Enterprise Edition.

Authorization

One of the following:

• sysadm
• sysctrl
• sysmaint

Required Connection

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

Command Syntax

>>-LIST DCS APPLICATIONS----+-------------+--------------------><
                            +-SHOW DETAIL-+
                            '-EXTENDED----'
 

Command Parameters

LIST DCS APPLICATIONS

The default application information includes:

• Host authorization ID (username)
• Application program name
• Application handle
• Outbound application ID (luwid).

SHOW DETAIL

Specifies that output include the following additional information:

• Client application ID
• Client sequence number
• Client database alias
• Client node name (nname)
• Client release level
• Client code page
• Outbound sequence number
• Host database name
• Host release level.

EXTENDED

Generates an extended report. This report includes all of the fields that are listed when the SHOW DETAIL option is specified, plus the following additional fields:

• DCS application status
• Status change time
• Client platform
• Client protocol
• Client code page
• Process ID of the client application
• Host coded character set ID (CCSID).

Examples

The following is sample output from LIST DCS APPLICATIONS:

Auth Id Application Name Appl. Outbound Application Id Handle -------- -------------------- ---------- -------------------------------- DDCSUS1 db2bp_s 2 0915155C.139D.971205184245

The following is sample output from LIST DCS APPLICATIONS EXTENDED:

List of DCS Applications - Extended Report Client application ID = 09151251.0AD1.980529194106 Sequence number = 0001 Authorization ID = SMITH Application name = db2bp Application handle = 0 Application status = waiting for reply Status change time = Not Collected Client DB alias = MVSDB Client node = antman Client release level = SQL05020 Client platform = AIX Client protocol = TCP/IP Client codepage = 819 Process ID of client application = 38340 Client login ID = user1 Host application ID = G9151251.GAD2.980529194108 Sequence number = 0000 Host DB name = GILROY Host release level = DSN05011 Host CCSID = 500

Notes:

1. The application status field contains one of the following values:

   connect pending - outbound

   Denotes that the request to connect to a host database has been issued, and that DB2 Connect is waiting for the connection to be established.

   waiting for request

   Denotes that the connection to the host database has been established, and that DB2 Connect is waiting for an SQL statement from the client application.

   waiting for reply

   Denotes that the SQL statement has been sent to the host database.

2. The status change time is shown only if the System Monitor UOW switch was turned on during processing. Otherwise, Not Collected is shown.

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

Usage Notes

The database administrator can use this command to match client application connections to the gateway with corresponding host connections from the gateway.

The database administrator can also use agent ID information to force specified applications off a DB2 Connect server.