[IBM Informix Enterprise Replication] Queuer and grouper paging thresholds -- Posted by inturi on Monday, August 10 2009
Run the following onstat command to get thresholds for ER queue spooling activity and grouper paging activity

onstat -g cdr config CDR_QUEUEMEM long

IBM Informix Dynamic Server Version 11.50.UC6 -- On-Line -- Up 1 days 20:15:
21 -- 462408 Kbytes
CDR_QUEUEMEM configuration setting: 4096

CDR_QUEUEMEM derived values for GROUPER:
Grouper Paging Threshold: 838656

CDR_QUEUEMEM derived values for QUEUER:
Queuer Data HWM: 4194304
Queuer Elem HWM: 4194304

CDR_QUEUEMEM derived values for RQM:
Queue trg_send:
Data HWM Base : 4194304
Data HWM Resync : 0
Data LWM : 2936012
Header HWM : 4194304
Header LWM : 2936012
Change request id : 0
Change target value : 2147483647
Change active spoolers: 0

---------------------------------------------------------------------

A transaction qualifies for large transaction when its size exceeds 838656 bytes (this includes before and after image of the row)

Send queue spooling activity begins when in memory queue data size exceeds 4194304 byes.