Viewing Multiplex Connection Statistics

Display the connection statistics for all servers in an SAP Sybase IQ multiplex.
  1. In the Perspective Resources view, select the resource and select Resource > Monitor Multiplex.
  2. In the left pane of the IQ Multiplex Level Monitor view, select Connections.
  3. To display a list of connections in the Multiplex Connections area, click the arrow beside the server name.
  4. On the Active Connections tab, click the bar chart for a server to display the active connection details in a pie chart.
Note:

  • Click a column header to sort the data by that column.

  • To display the information in a chart or table in the full window, select the Maximize icon in the top right of the area.

  • Hover the mouse pointer over any line or bar graph to display information for that graph.

Tab Description
Connections  
  Multiplex Connections Displays all users currently connected to each server, including:
  • Server – the name of the server.
  • User ID – the ID of the connected user.
  • Connection ID – the ID of the connection.
  • State – the current state of the selected connection. Possible states include:
    • ACTIVE – the connection is live.
    • SUSPENDED – the connection and its corresponding transaction are suspended, probably due to hardware or communication failure.
  • Name – the name of the connection.
  • Connection create time – the date and time the connection was established.
  • Client IP address – the IP address of the client that made the connection.
  • Connection or cursor – indicates a connection or an active cursor
  User Connections/Disconnections Per Minute Displays the number of user connections and disconnections per minute for each server.
Active Connections Displays a chart of the number of user, internode incoming, and other connections to the selected server.
Parent topic: Monitor Multiplex Servers
Related tasks
Viewing Multiplex Overview Statistics
Viewing Multiplex Topology Statistics
Viewing Multiplex Server Statistics
Viewing Multiplex Transaction Statistics
Viewing Multiplex Dbspace Statistics
Viewing Multiplex Cache Statistics
Viewing Multiplex Monitor Settings Details
Viewing Connection Statistics