-DISPLAY LOCATION command (Db2)

The output heading is followed by information about connections with remote locations:

DSNL200I  ) DISPLAY LOCATION REPORT FOLLOWS-                       
LOCATION                                       PRDID    T ATT CONNS
address                                        text     t     number

LOCATION

The identifier for the remote location.

• For TCP/IP requester connections, the location is the IP address concatenated with the port number of the remote location. For TCP/IP server connections, the location is the IP address of the remote location.
• For SNA connections, the location is the LU name of the remote location.

PRDID

An alphanumeric string that identifies the product.

The product identifier (PRDID) value is an 8-byte character value in pppvvrrm format, where: ppp is a 3-letter product code; vv is the version;rr is the release; and m is the modification level. For Db2 13 for z/OS, the modification level (0–9 or A–Z) indicates a specific function level. For example:

• DSN13012 for V13R1M501.
• DSN13011 for V13R1M500.
• DSN13010 for V13R1M100.

For more information, see Product identifier (PRDID) values in Db2 for z/OS.

T

The connection type with the remote location. Expected values are:

R

A requester connection from the local subsystem that is accessing a remote system.

S

A server connection from a remote system that is accessing the local subsystem.

G

A server connection from a remote system that is accessing the local subsystem and has indicated that it is a Db2 Connect server/gateway.

ATT and CONNS

The type and number of connections with the partner location. When the ATT column is blank, the value of CONNS is the total number of connections with the partner location. The ATT column is blank unless the DETAIL option is specified.

The meanings of the ATT values are:

AES

The connection uses AES encryption.

CBF

The connection is a secondary connection for an application that uses package-based continuous block fetch.

IPS

The connection uses Internet Protocol security (IPSec).

TLS

The connection uses a secure sockets layer (SSL) that is provided by Application Transparent-Transport Layer Security (AT-TLS).

TRS

The connection is a trusted connection.

WLB

The connection is from a client that is using Sysplex workload balancing.

XA

The connection is part of a distributed transaction.

When the functional level of the remote location is known, a message line contains that functional level.

L209-FUNCTIONAL LEVEL=functional-level

functional-level

A value that depends on the type of requester:

• If the remote application is running on a Db2 for z/OS subsystem, functional-level is the function level of the remote subsystem. For example, if the function level of the remote subsystem is V12R1M501, functional-level is V12R1M501.
• If the remote application is a client application that uses the IBM® Data Server Driver for JDBC and SQLJ, functional-level is the build number. The driver version is in the form major-version.minor-version.build-number. The build number is the build-number portion of the driver version. For example, if the driver version is 4.22.29, the build level is 29.
• If the remote application is a client application that uses another client or driver, the functional level is the build level for the Db2 for Linux®, UNIX, and Windows client. An example of a build level is S1612011300.

When the DISPLAY LOCATION command is unable to find any locations that are associated with the specified list of locations, a message line indicates that no locations were found.

DISPLAY LOCATION NO LOCATIONS FOUND

If all locations were specified, there is no distributed activity. If a location list was specified, reissue the DISPLAY LOCATION command with the LOCATION(*) parameter to display information for all locations.

If the output was generated in response to a command from an MVS console and more than 254 response messages were generated, the output is truncated. A message line indicates this truncation.

DISPLAY LOCATION TERMINATED WITH MAX LINES

You can reissue the DISPLAY LOCATION command and specify a specific location or list of locations to see complete output for that context.

When a DISPLAY LOCATION command is issued with the DETAIL option, the output might contain additional lines for each remote location.

The output might contain one or more lines that provide information about the number of connections from or to remote systems that have certain attributes:

DSNL200I  ) DISPLAY LOCATION REPORT FOLLOWS-                       
LOCATION                                       PRDID    T ATT CONNS
                                               text     t     number
                                                          txt number
                                                          txt number

LOCATION

The identifier for the remote location.

• For TCP/IP requester connections, the location is the IP address concatenated with the port number of the remote location. For TCP/IP server connections, the location is the IP address of the remote location.
• For SNA connections, the location is the LU name of the remote location.

PRDID

An alphanumeric string that identifies the product.

The product identifier (PRDID) value is an 8-byte character value in pppvvrrm format, where: ppp is a 3-letter product code; vv is the version;rr is the release; and m is the modification level. For Db2 13 for z/OS, the modification level (0–9 or A–Z) indicates a specific function level. For example:

• DSN13012 for V13R1M501.
• DSN13011 for V13R1M500.
• DSN13010 for V13R1M100.

For more information, see Product identifier (PRDID) values in Db2 for z/OS.

T

The connection type with the remote location. Expected values are:

R

A requester connection from the local subsystem that is accessing a remote system.

S

A server connection from a remote system that is accessing the local subsystem.

G

A server connection from a remote system that is accessing the local subsystem and has indicated that it is a Db2 Connect server/gateway.

ATT and CONNS

The number of connections that are associated with the remote location and that have the attribute that is identified by the ATT column. Because more than one attribute might apply to the same connection, the total number of connections is not the sum of the numbers for the different attributes. The expected values for ATT are:

AES

Using security credentials with AES encryption.

IPS

Using IPSec.

TLS

SSL using Application Transparent-Transport Layer Security (AT-TLS).

TRS

Using trusted context.

WLB

Using workload balancing connections.

XA

Using XA transaction manager processing.

The output might also include lines that contain detailed information about the connections that are associated with the Db2 system thread. A line that is identified by the partial message number L203 provides descriptive headings. The lines that follow are identified by the partial message number L204.

  L203-SYSTASK   SESSID            A  ST  TIME                     
  L204-text        session-id        a  s   yydddhhmmssth            
  L204-text        session-id        a  s   yydddhhmmssth            

SYSTASK

Describes the Db2 system threads. The expected values are:

SYSPLX-x

Indicates SNA-related SYSPLEX processing where Db2 systems periodically create connections to a remote data sharing group to obtain WLM balancing information that is related to all members of the group.

The expected values of x are:

O

The local Db2 system is contacting a remote member of a data sharing group to request WLM balancing information.

I

The local Db2 system is receiving a connection that requests WLM balancing information.

RESYNC

A connection that is used to resynchronize a unit of work that encountered a previous thread or communication error. One line is displayed for each thread that needs resynchronization with the remote site.

SESSID

The identifier of the session:

• For SNA network connections, the VTAM®-defined session instance identifier of the session on which the conversation is executing. If the session identifier is not applicable, this field contains zeros.

  You can use the VTAM DISPLAY NET,ID=db2-luname,SCOPE=ACT command to obtain the full session ID. The DISPLAY NET command lists all sessions (SID) for the Db2 logical unit. Scan the DISPLAY NET output for the complete SID.

• For Internet Protocol network connections, a string in the format local:remote, where:

  local

  Specifies the local Db2 system's TCP/IP port number.

  remote

  Specifies the remote partner's TCP/IP port number.

A

The connection activity:

N

The connection is active in the network.

W

The connection is suspended in Db2 and is waiting for VTAM or TCP/IP notification that the function is complete.

blank

No specific activity condition exists.

ST

The status of the connection:

A

The connection is in allocation.

C

Session limits are being negotiated (CNOS) with the SNA partner before connection allocation.

D

The connection is in deallocation.

R

Receiving.

S

Sending.

blank

No specific status condition exists.

TIME

The timestamp of the last message that is sent or received on the connection, in the format yydddhhmmssth, where

yy

The last two digits of the year.

ddd

The number of the day in the year. For example, February 1 is represented as 032.

hhmmssth

The time of day in 24-hour format, to hundredths of the second.

When the DISPLAY LOCATION command is issued with the INCOMPLT option, the output contains information about locations with incomplete connections that Db2 terminated.

LOCATION

The IP address of a client that had incomplete connections terminated by Db2.

CONNS

The number of incomplete connections from the client that were terminated by Db2 since DDF started.

For example, assume you issue the following command at the server:

-DISPLAY LOCATION INCOMPLT

The output is similar to the following example:

DSNL200I -DB2A DISPLAY LOCATION REPORT FOLLOWS- 
       LOCATION                    CONNS   
       ::10.1.43.29                    47  
       ::10.1.24.149                   60  
       ::10.1.28.42                     2  
       ::10.1.54.128                   62  
       ::10.1.54.132                   30  
       ::10.1.54.237                    1  
       ::10.1.54.242                  108  
       ::10.1.54.244                  575  
       ::10.1.54.250                  884  
       ::10.1.57.136                    3  
       ::10.1.58.43                    21  
       ::10.1.64.26                     1  
       ::10.1.67.185                    1  
       ::192.168.1.219                  1  
       ::192.168.1.25                   1  
       ::192.168.1.77                   1  
       ::192.168.1.57                   1  
 DISPLAY LOCATION REPORT COMPLETE     

The DISPLAY LOCATION command could not obtain storage for additional messages. This situation occurs only for long display requests, such as DISPLAY LOCATION(*) DETAIL on systems with a large numbers of connections.

DISPLAY TERMINATED DUE TO INSUFFICIENT MESSAGE SPACE

The display is truncated.

Reissue the DISPLAY LOCATION command, and specify a smaller number locations, instead of using the default (*). To reduce the amount of message space that is needed, do not specify the DETAIL option unless you need the additional information that it provides.

DISPLAY LOCATION REPORT COMPLETE