Check Connection Status of Directly Connected Query Servers

You can check the connection status of query servers that are directly connected to the LSMS. The connection status for each query server (denoted by hostname and IP address) is displayed as "Connected", "Disconnected" or "Not Reachable."

To check the connection status, use the following procedure:

  1. Log into the active server as the lsmsadm user.

    (For information about logging in, see “Logging In to LSMS Server Command Line”.)

  2. Enter the following command:

    $ lsmsdb -c queryservers

    Output similar to the following displays:

    10.25.60.32 (10.25.60.32) Disconnected
     Failed to connect to 10.25.60.12 database
    
    In this example, two query servers have been configured to directly connect to the LSMS; the first is currently disconnected and the second failed to connect.