Viewing Multiplex Transaction Statistics

Display transaction statistics for all servers in a Sybase IQ multiplex.

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 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:

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
Transactions tab	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 tab	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.

Area

Description

Transactions tab

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 tab

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.