Viewing Logical Server Statistics

Display the statistics for logical servers in the SAP Sybase IQ multiplex.
  1. In the Perspective Resources window, select the resource, click the arrow, and select Monitor Logical Server.
  2. In the left pane of the IQ Logical Server Level Monitor view, select Servers.
  3. In the Logical Server Nodes area, select the server to display in the Server Details area.
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.

Area Description

Logical Server Nodes

Server – name of the server.

Host – host name where the server is running.

Port – port number where the server is running.

State – current state of the server. Valid states include:
  • Unknown
  • Stopped
  • Running
Role – role the server plays in the multiplex configuration. Roles include:
  • Coordinator
  • Reader
  • Writer
Status – current status of the server in the multiplex. Valid states include:
  • Included
  • Excluded

Server Details

Server name – name of the server.

State – current state of the server. Valid states include:
  • Unknown
  • Stopped
  • Running

Database – name of the IQ database.

Database path – location of the database file on the server.

Server version – version of the IQ server.

Platform – operating system running on the host of the server.

Related tasks
Viewing Logical Server Overview Statistics
Viewing Logical Server Monitor Settings Details