Viewing RLV Merge History Statistics

Display the RLV merge history statistics for the selected SAP Sybase IQ server.

Prerequisites
Database Version View RLV Merge History Privileges
SAP Sybase IQ 15.3 and 15.4 Not supported.
SAP Sybase IQ 16.0 None.
Note: The RLV Merge History Statistics page does not appear on the IQ Node Level Monitor page for individual multiplex nodes.
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Monitor Node.
  2. In the left pane of the IQ Node Level Monitor view, select RLV Merge History.
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.

Column Description
RLV Merge History  
  Table Name Name of the RLV-enabled table.
  Start Time Time the RLV merge began.
  End Time Time the RLV merge finished.
  Merge Type The cause of the merge trigger. Available types are:
  • AUTOMATIC
  • DML
  • DDL
  • SHUTDOWN
  • USER
  Status Current status of the RLV merge. Available statuses are:
  • STARTED
  • COMPLETED
  • FAILED
RLV Merge History Details  
  Merge ID Unique log entry identifier of the merge.
  Merge mode Current mode of the merge. Available modes are:
  • BLOCKING
  • NON-BLOCKING
  Return code SQL code of the merge once completed.
  Merge detail Additional information, if provided, such as error information.
  Rows inserted Number of rows that were inserted as a result of the merge.
  Rows updated Number of rows that were updated as a result of the merge.
  Rows deleted Number of rows that were deleted as a result of the merge.
  Rows forwarded Number of rows that were uncommitted at the time of the merge.
Related tasks
Viewing Overview Statistics
Viewing All Statistics
Viewing Engine Statistics
Viewing Connection Statistics
Viewing Transaction Statistics
Viewing Dbspaces Statistics
Viewing Store I/O Statistics
Viewing Cache Statistics
Viewing Table Version Statistics
Viewing Operations and Requests Statistics
Viewing Network Statistics
Viewing Table Page Usage Statistics
Viewing Table Lock Statistics
Viewing Deadlock Statistics
Viewing RLV Memory Usage Statistics
Viewing Monitor Settings Details