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
- 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.
The meanings of the ATT values are:
- 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
- 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.
- 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.
- 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.