-DISPLAY LOCATION command (Db2)

The Db2 command DISPLAY LOCATION displays various information about the specified remote locations.

When you specify the DETAIL keyword, information about the numbers of connections with partner locations that have particular attributes are shown, and detailed information about connections owned by Db2 system threads that are communicating with the location might also be shown for each partner location.

The information returned by the DISPLAY LOCATION command reflects a dynamic status. By the time the information is displayed, it is possible that the status has changed.

Abbreviation: -DIS LOC

Environment

This command can be issued from a z/OS® console, a DSN session under TSO, a DB2I panel (DB2 COMMANDS), an IMS or CICS® terminal, or a program using the instrumentation facility interface (IFI).

Data sharing scope: Member

Authorization

To execute this command, you must use a privilege set of the process that includes one of the following privileges or authorities:

DISPLAY privilege
System DBADM authority
SYSOPR authority
SYSCTRL authority
SYSADM authority

Db2 commands that are issued from a logged-on z/OS console or TSO SDSF can be checked by Db2 authorization using primary and secondary authorization IDs. Start of change A logged-on z/OS user ID must be defined in RACF or a similar security server. End of change

Syntax

Option descriptions

(*): Displays information for all remote locations.
( location-name ): Lists one or more location names, separated by commas.
Because Db2 does not receive a location name from requesters that are not Db2 for z/OS subsystems, you can enter the LUNAME or IP address of such a requester. Refer to the option descriptions for the < luname > and ( ipaddr ) options for more information about using the LUNAME or IP address to specify a requester that is not a Db2 for z/OS subsystem.
(partial-location*): Selects all location names that begin with the string partial-location and can end with any string, including the empty string. For example, LOCATION(ABC*) selects all location names that begin with the string 'ABC'.
< luname >: Requests information about the remote clients that are connected to DDF through the remote SNA LU that is specified. Enclose the LU name in the less-than (<) and greater-than (>) symbols. For example, DISPLAY LOCATION(<LULA>) displays information about a remote location (that is not Db2 for z/OS) with the LU name of LULA.
You can use an asterisk (*) when specifying an LU name in the same manner as previously described for specifying a partial-location name. For example, DISPLAY LOCATION(<LULA*) selects all remote locations (that are not Db2 for z/OS) with an LU name that begins with the string 'LULA'.
( ipaddr ): Requests information about the clients that are connected to DDF through the remote TCP/IP host. Enter the IP address. For example, DISPLAY LOCATION(::FFFF:124.63.51.17) displays information about clients at the remote TCP/IP host whose dotted decimal IP address is 124.63.51.17.
(partial-ipaddr*): Selects all remote TCP/IP hosts with IP addresses that begin with string partial-ipaddr and end with any string, including the empty string. For example, LOCATION(::FFFF:9.65.*) selects all remote TCP/IP hosts with IP addresses that begin with the string '::FFFF:9.65.'.
DETAIL: Displays additional information about conversation activity for Db2 system threads.
INCOMPLT: Displays only locations that had incomplete connections with Db2, including the total number of connections from each location that were terminated for being incomplete since DDF started. The count for each location is reset only if DDF is stopped and restarted.

Output

Message DSNL200I indicates the beginning of the output of the command.

Examples

Example: Displaying information about threads and conversations with specific remote locations

The following command displays information about threads and conversations with remote locations LUND1, LUND2, and LUND3.

DISPLAY LOCATION(LUND1,LUND2,LUND3)

The output looks similar to this output:

DSNL200I  @ DISPLAY LOCATION REPORT FOLLOWS-     
LOCATION                                       PRDID    T ATT CONNS 
LUND1                                          DSN12015 R          1
LUND2                                          DSN12015 R          1
LUND2                                          DSN12015 S          1
LUND3                                          DSN12015 R          1
LUND3                                          DSN12015 S          3
DISPLAY LOCATION REPORT COMPLETE

Example: Displaying information about conversations and threads with all remote locations

The following command displays detailed information about conversations with all remote locations, and detail conversation information about Db2 system threads that communicate with other locations.

-DISPLAY LOCATION DETAIL

The output looks similar to this output:

DSNL200I  @ DISPLAY LOCATION REPORT FOLLOWS-     
DSNL200I  @ DISPLAY LOCATION REPORT FOLLOWS-     
LOCATION                                       PRDID    T ATT CONNS 
LUND1                                          DSN12015 R          1
LUND2                                          DSN12015 R          1
LUND2                                          DSN12015 S          1
 L203-SYSTASK   SESSID            A ST TIME                          
 L204-RESYNC    E15FDE02D310FB84  N R  0820914411184                 
LUND3                                          DSN12015 R          1
LUND3                                          DSN12015 S          3
 L203-SYSTASK   SESSID            A ST TIME                          
 L204-RESYNC    E15FDE02D310FB87  W R  0820914411187                 
 L204-RESYNC    E15FDE02D310FB88  W R  0820914411188                 
 L204-RESYNC    E15FDE02D310FB89  W R  0820914411189                 

DISPLAY LOCATION REPORT COMPLETE                                       
DISPLAY LOCATION REPORT COMPLETE

Example: Displaying information about a connection with DRDA partner sites:

Suppose that a Db2 system is connected with the following DRDA partners:

A non-z/OS server via TCP/IP IPv4.
Several TCP/IP clients from the same TCP/IP host as the server.
A Db2 for z/OS server via SNA.
A Db2 for z/OS client via TCP/IP IPv6.

The output from the following command shows information about those DRDA partners:

-DISPLAY LOCATION(*)

The output is similar to the following output:

DSNL200I  @ DISPLAY LOCATION REPORT FOLLOWS-                        
LOCATION                                       PRDID    T ATT CONNS 
::FFFF:124.63.51.17..50000                     SQL09073 R          3
::FFFF:124.63.51.17                            SQL09073 S         15
LULA                                           DSN12015 S          1
2002:91E:610:1::5                              DSN12015 S          1

Example: Display information about a trusted connection:

Suppose that there is trusted connection to location ::FFFF:9.30.115.135. You issue the following command:

-DIS LOC DET

A value of TRS in the ATT field indicates that a connection is trusted, as shown in the following example:

DSNL200I  @ DISPLAY LOCATION REPORT FOLLOWS-                        
LOCATION                                       PRDID    T ATT CONNS 
::FFFF:9.30.115.135                            DSN12015 R          1
                                                          TRS      1
::FFFF:9.30.115.135                            DSN12015 S          1
                                                          TRS      1
DISPLAY LOCATION REPORT COMPLETE

Example: Display information for a location that has secondary connections to a server:

Suppose that a distributed application is using enhanced continuous block fetch to access data on a server. The requester has opened a secondary connection for each cursor in the application. You issue the following command at the server:

-DB2A DIS LOC DET

The following output is displayed:

DSNL200I  -DB2A DISPLAY LOCATION REPORT FOLLOWS-
LOCATION                                       PRDID    T ATT CONNS
::FFFF:127.0.0.1                               DSN12015 S          1
                                                          CBF      1
DISPLAY LOCATION REPORT COMPLETE

A value of CBF in the ATT field indicates that the thread from location ::FFFF:127.0.0.1 is associated with a secondary connection.

If you enter the same command at the requester, the following output is displayed:

DSNL200I  -DB2B DISPLAY LOCATION REPORT FOLLOWS-
LOCATION                                       PRDID    T ATT CONNS
::FFFF:127.0.0.1..446                          DSN12015 R          1
                                                          CBF      1
DISPLAY LOCATION REPORT COMPLETE

A value of CBF in the ATT field indicates that the thread to location ::FFFF:127.0.0.1..446 is associated with a secondary connection.

Example: Display location information. The remote location is a Db2 Connect server gateway:

You issue the following command at the server:

-DB2A DIS LOC

The following output is displayed:

DSNL200I  -DB2A DISPLAY LOCATION REPORT FOLLOWS-
LOCATION                                       PRDID    T ATT CONNS
::FFFF:9.23.2.248                              SQL09019 G         1
                                                                
DISPLAY LOCATION REPORT COMPLETE

The location in the report has a G value in the T column when the PRDID value begins with "SQL" and the client has indicated to Db2 for z/OS that it is a Db2 Connect server gateway.

Example: Display location information. The remote location is a Db2 for z/OS subsystem that reports a functional level:

You issue the following command at the server:

-DB2A DIS LOC

The following output is displayed:

DSNL200I  -DB2A DISPLAY LOCATION REPORT FOLLOWS- 
LOCATION                                       PRDID    T ATT CONNS 
SYEC1B                                         DSN12015 S          1
 L209-FUNCTIONAL LEVEL=V12R1M500                                    
DISPLAY LOCATION REPORT COMPLETE

The functional level is the same as the application compatibility level of the requester, in the format V12R1Mnnn.

Example: Display location information. The remote location uses an IBM® Data Server Driver for JDBC and SQLJ that reports a functional level:

You issue the following command at the server:

-DB2A DIS LOC

The following output is displayed:

DSNL200I  -DB2A DISPLAY LOCATION REPORT FOLLOWS-
LOCATION                                       PRDID    T ATT CONNS
::FFFF:9.30.222.67                             JCC04220 S          1
 L209-FUNCTIONAL LEVEL=29                                                                
DISPLAY LOCATION REPORT COMPLETE

The IBM Data Server Driver for JDBC and SQLJ version is in the form major-version.minor-version.build-number. The functional level is build-number. In this example, the driver version is 4.22.29, so the functional level is 29.

Example: Display location information. The remote location uses an IBM Data Server Driver for CLI and ODBC that reports a functional level:

You issue the following command at the server:

-DB2A DIS LOC

The following output is displayed:

DSNL200I  -DB2A DISPLAY LOCATION REPORT FOLLOWS-
LOCATION                                       PRDID    T ATT CONNS
::FFFF:9.30.222.67                             SQL11010 S          1
 L209-FUNCTIONAL LEVEL=S1612011300                                                                
DISPLAY LOCATION REPORT COMPLETE

The functional level is the build level for the Db2 for Linux®, UNIX, and Windows client.

Example: Display locations with incomplete connections to Db2

You issue the following command at the server:

-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