Skip to Content

Auto RLV Merge is not happening for all transacted tables

Hello All,

Using IQ 16.0 SP11 with 20 RLV enabled tables and transactions are very frequent.

When I'm doing manual Merge, almost all the tables are merging considerable amount of records to Main store. But When I'm going through the Auto Merge history (enabled every 60 minutes) , it is happening only for 3 (unfortunately less usage tables) getting merged. Very rarely/once in a week other tables getting merged to Main store.

Since our Server is going Unresponsive often & only way to run again is to restart after a soft kill of services. Few times while bringing up , going through RLV bypassing and couple of lost data also. Can anyone know what s d problem for the below issue.

196vs.png (69.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 26, 2016 at 10:24 AM

    Hello ,

    Is there any restrictions for AUTOMERGE in IQ to happen only for 3 tables (or) is there any DB option to add number of tables to merge,

    I. 10/26 11:02:29. 0000083505 0000000134 AutoMerge:Table 'atble_mane' (804) with 102868 rows was NOT added to Merge list.
    I. 10/26 11:02:29. 0000083505 0000000134 AutoMerge: Opportunistic, but max candidates( 3 ) exceeded.
    I. 10/26 11:02:29. 0000083505 0000000134 AutoMerge: Table 'Table_name' (803) with 37998 rows was NOT added to Merge list.
    I. 10/26 11:02:29. 0000083505 0000000134 AutoMerge: Opportunistic, but max candidates( 3 ) exceeded.
    I. 10/26 11:02:29. 0000083505 0000000134 AutoMerge: Table 'table_name' (802) with 6300 rows was NOT added to Merge list.
    I. 10/26 11:02:29. 0000083505 0000000134 AutoMerge: Opportunistic, but max candidates( 3 ) exceeded.

    Add comment
    10|10000 characters needed characters exceeded