Viewing Multiplex Overview Statistics

Display the overall health of the SAP Sybase IQ multiplex environment.

  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 Overview.
  3. Select the tab for the required information.
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
Multiplex  
  Servers
  • 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
  CPU History Percentage of total CPU usage over a period of time for each server. The legend below the chart identifies the colored line associated with each server.
  IQ Memory Allocation of the IQ memory between the main cache and temporary cache for each server in the multiplex.
Disk Usage Available and used space for the main store and temporary store on each server in the multiplex.
Version Usage  
  Statistics
  • Number of committed versions – the number of table versions in the servers.
  • Total version space used (MB) – total space consumed by all the table versions.
  • Oldest version ID – the oldest table version identifier on the server.
  • Number of active versions – total number of active write table versions on the servers.
  • Total active version space created (MB) – amount of data created by active write transactions.
  • Total active version space to be destroyed (MB) – amount of data destroyed by active write transactions. If these transactions commit, the destroyed data becomes an old version and is eventually dropped. If the transactions roll back, the created data is released.
  Multiplex Version Usage
  • Version ID – the table version identifier.
  • Server name – the name of the server where the table version exists.
  • Connection ID – the connection ID using this table version.
  • WasReported – indicates whether the server has received usage information for this table version.
  • MinKBRelease – the minimum amount of space returned once this table version is no longer in use.
  • MaxKBRelease – the maximum amount of space returned once this table version is no longer in use.
Alerts Any alerts for the selected multiplex. While the monitor is open, alerts are displayed as they are created.
Parent topic: Monitor Multiplex Servers
Related tasks
Viewing Multiplex Topology Statistics
Viewing Multiplex Server Statistics
Viewing Multiplex Connection Statistics
Viewing Multiplex Transaction Statistics
Viewing Multiplex Dbspace Statistics
Viewing Multiplex Cache Statistics
Viewing Multiplex Monitor Settings Details
Viewing Overview Statistics