Viewing Multiplex Transaction Statistics

Display transaction statistics for all servers in an SAP Sybase IQ multiplex.

In the Perspective Resources view, select the resource and select Resource > Monitor Multiplex.
In the left pane of the IQ Multiplex Level Monitor view, select Transactions.
To display a list of transactions, click the arrow beside the server name.
On the Transaction Statistics tab, click the bar chart for a server to display the transaction 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
Transactions	Server – the name of the server. Transaction ID – the unique identification number for the selected transaction. Version ID – the version identification number for the selected transaction. User ID – the user name of the user that started the selected transaction. State – the current state of the selected transaction. Possible states include: ACTIVE – the transaction is being processed. COMMITTED – the transaction has completed processing. Creation time – the date and time when the selected transaction was created.
Transaction Statistics	Displays a chart of the number of transactions for each server in the multiplex. Selecting a server in the chart displays a pie chart of user and internode communications (identified on the chart as INC) transactions.

Tab

Description

Transactions

Server – the name of the server.
Transaction ID – the unique identification number for the selected transaction.
Version ID – the version identification number for the selected transaction.
User ID – the user name of the user that started the selected transaction.
State – the current state of the selected transaction. Possible states include:
- ACTIVE – the transaction is being processed.
- COMMITTED – the transaction has completed processing.
Creation time – the date and time when the selected transaction was created.

Transaction Statistics

Displays a chart of the number of transactions for each server in the multiplex. Selecting a server in the chart displays a pie chart of user and internode communications (identified on the chart as INC) transactions.