Viewing Multiplex Overview Statistics

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

In the Perspective Resources window, select the resource, click the arrow, and select Monitor Multiplex.
In the left pane of the IQ Multiplex Level Monitor view, select Overview.
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.

Area	Description
Multiplex tab > 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
Multiplex tab > 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.
Multiplex tab > IQ Memory	Allocation of the IQ memory between the main cache and temporary cache for each server in the multiplex.
Disk Usage tab	Available and used space for the main store and temporary store on each server in the multiplex.
Version Usage tab > 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.
Version Usage tab > 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.