DB2 Version 9.7 for Linux, UNIX, and Windows

QUERY CLIENT command

Returns current connection settings for an application process.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagram
>>-QUERY CLIENT------------------------------------------------><

Command parameters

None

Examples

The following is sample output from QUERY CLIENT:

The current connection settings of the application process are:
                          CONNECT   = 1
                       DISCONNECT   = EXPLICIT
          MAX_NETBIOS_CONNECTIONS   = 1
                         SQLRULES   = DB2
                        SYNCPOINT   = ONEPHASE
           CONNECT_DBPARTITIONNUM   = CATALOG_DBPARTITIONNUM
            ATTACH_DBPARTITIONNUM   = -1

If CONNECT_DBPARTITIONNUM and ATTACH_DBPARTITIONNUM are not set using the SET CLIENT command, these parameters have values identical to that of the environment variable DB2NODE. If the displayed value of the CONNECT_DBPARTITIONNUM or the ATTACH_DBPARTITIONNUM parameter is -1, the parameter has not been set; that is, either the environment variable DB2NODE has not been set, or the parameter was not specified in a previously issued SET CLIENT command.

Usage notes

The connection settings for an application process can be queried at any time during execution.