Displaying information about connections with other locations

The DISPLAY LOCATION command displays summary information about connections with other locations. You can also use this command to display detailed information about the conversations with other locations.

Before you begin

To issue the DISPLAY LOCATION command, you must have SYSOPR authority or higher.

Procedure

Begin general-use programming interface information. To display information about connections with other locations, use the following approaches:

Issue the DISPLAY LOCATION command.
For example:
```
-DISPLAY LOCATION(*)
```
Db2 returns output that is similar to the following example:
```
DSNL200I  @ DISPLAY LOCATION REPORT FOLLOWS-     
LOCATION                                       PRDID    T ATT CONNS 
LUND0                                          DSN10011 R          1
LUND1                                          DSN10011 S          0
::FFFF:124.63.51.17..50000                     SQL09073 R          3
::FFFF:124.63.51.17                            SQL09073 S         15
DISPLAY LOCATION REPORT COMPLETE
```
You can use an asterisk (*) in place of the end characters of a location name. For example, you can use DISPLAY LOCATION(SAN*) to display information about all active connections between your Db2 subsystem and a remote location that begins with SAN. The results include the number of conversations and conversation role, requester, or server.
When Db2 connects with a remote location, information about that location, persists in the report even if no active connections exist, including:
- The physical address of the remote location (LOCATION)
- The product identifier (PRDID)
When you specify the DETAIL option in the DISPLAY LOCATION command, the report might include additional messages lines for each remote location, including:
- Information about the number of conversations in the CONNS column with each remote location that have particular attributes. that are identified by a value in the ATT column. For example, the number of connections that use trusted context are identified by TRS.
- Information about conversations that are owned by Db2 system threads, such as those that are used for resynchronization of indoubt units of work.

You can specify the INCOMPLT option to display location information for clients that had incomplete connections terminated by Db2.

For example, assume that you issue the following command:

-DISPLAY LOCATION INCOMPLT

The following output is displayed:

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

Example

The DISPLAY LOCATION command displays the following types of information for each DBMS that has active connections, except for the local subsystem:

The network address for the location:
- For remote locations accessed through SNA connections, the location name the SNA LU name.
- For remote locations accessed through TCP/IP connections, the location name is the dotted decimal IPv4 or colon hexadecimal IPv6 address. If the T column contains R, the IP address is concatenated with the port value of the remote location.
The PRDID, which identifies the database product at the location.
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. In Db2 12 for z/OS®, the modification level indicates a range of function levels:
- DSN12015 for V12R1M500 or higher.
- DSN12010 for V12R1M100.
For more information, see Product identifier (PRDID) values in Db2 for z/OS.
Whether the local system is requesting data from the remote system, or acting as a server to the remote system. 'R' indicates a requester connection from local subsystem accessing the remote system. 'S' indicates a server connection from remote system accessing the local subsystem.
The number of connections that have a particular attribute from or to the location. The attribute value is blank for the message line that contains the total number of connections for the location. Additional lines for connections with particular attributes are shown only when a detailed report is requested.
The total number of conversations that are in use between the local system and the remote system

For example, suppose two threads are at location USIBMSTODB21. One thread is a database access thread that is related to a non-Db2 requester system, and the other is an allied thread that goes from USIBMSTODb21 to the non-Db2 server system. Both threads use SNA connections. The DISPLAY LOCATION command that is issued at USIBMSTODB21 displays the following output:

DSNL200I  @ DISPLAY LOCATION REPORT FOLLOWS-     
LOCATION                                       PRDID    T ATT CONNS 
LUND1                                                   R          1
LULA                                           DSN09010 S          1
DISPLAY LOCATION REPORT COMPLETE

The following output shows the result of the DISPLAY LOCATION(*) command when Db2 is connected to the following DRDA partners:

TCP/IP for DRDA connections to ::FFFF:124.38.54.16
SNA connections to LULA.

DSNL200I  @ DISPLAY LOCATION REPORT FOLLOWS-     
LOCATION                                       PRDID    T ATT CONNS 
::FFFF:124.38.54.16..446                       DSN10015 R          2
::FFFF:124.38.54.16                            DSN10015 S          1
LULA                                           DSN09010 R          1
LULA                                           DSN09010 S          2
LULA
DISPLAY LOCATION REPORT COMPLETE

The DISPLAY LOCATION command displays information for each remote location that currently is, or once was, in contact with Db2. If a location is displayed with zero conversations, one of the following conditions exists:

Sessions currently exist with the partner location, but no active conversations are allocated to any of the sessions.
Sessions no longer exist with the partner, because contact with the partner has been lost.

End general-use programming interface information.