Start of change

DSNL200I   DISPLAY LOCATION REPORT FOLLOWS-

Explanation

This message displays output from the DISPLAY LOCATION command.

Output heading

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 format of product identifier values is pppvvrrm, where ppp is a 3-letter product code (such as DSN for DB2®), vv is the version, rr is the release, and m is the modification level. For example, DSN10015 identifies DB2 10 in new-function mode, the value is ‘DSN10015'. The product code (ppp) is one of the following values:
  • AQT for IBM® DB2 Analytics Accelerator for z/OS®
  • ARI for DB2 Server for VSE & VM
  • DSN for DB2 for z/OS
  • JCC for IBM Data Server Driver for JDBC and SQLJ
  • QSQ for DB2 for i
  • SQL for DB2 for Linux, UNIX, and Windows
Modification (m) values have the following meanings:
0 - 1
Modification levels in conversion and enabling-new-function mode from DB2 Version 8 (CM8, CM8*, ENFM8, and ENFM8*)
2 - 3
Modification levels in conversion and enabling-new-function mode from DB2 9 (CM9, CM9*, ENFM9, and ENFM9*)
4
Not used.
5 - 9
Modification levels in new-function mode.
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.
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.

Start of changeThe meanings of the ATT values are:End of change

AES
The connection uses AES encryption.
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.

No locations found

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.

Truncated output

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.

Detail output

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 format of product identifier values is pppvvrrm, where ppp is a 3-letter product code (such as DSN for DB2), vv is the version, rr is the release, and m is the modification level. For example, DSN10015 identifies DB2 10 in new-function mode, the value is ‘DSN10015'. The product code (ppp) is one of the following values:
  • AQT for IBM DB2 Analytics Accelerator for z/OS
  • ARI for DB2 Server for VSE & VM
  • DSN for DB2 for z/OS
  • JCC for IBM Data Server Driver for JDBC and SQLJ
  • QSQ for DB2 for i
  • SQL for DB2 for Linux, UNIX, and Windows
Modification (m) values have the following meanings:
0 - 1
Modification levels in conversion and enabling-new-function mode from DB2 Version 8 (CM8, CM8*, ENFM8, and ENFM8*)
2 - 3
Modification levels in conversion and enabling-new-function mode from DB2 9 (CM9, CM9*, ENFM9, and ENFM9*)
4
Not used.
5 - 9
Modification levels in new-function mode.
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.
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.

Output conclusion

The following line identifies the end of the output of the DISPLAY LOCATION command:
DISPLAY LOCATION REPORT COMPLETE

System action

Processing continues.

User response

No action is required.
End of change