Database Configuration Parameter: dsi_max_xacts_in_group

Use the dsi_max_xacts_in_group to specify the maximum number of transactions in a group.

Larger numbers may reduce commit processing at the replicate database, and thereby improve throughput.

Use dsi_max_xacts_in_group to control group size. Set dsi_xact_group_size to the maximum value of 2,147,483,647 and do not change it. Contention among parallel transactions may be reduced by reducing the value of dsi_max_cacts_in_group to 1, which indicates no grouping.

Monitor the average number of transactions placed in a group per DSI-E thread by reviewing counter 57001 – UnGroupedTransSched.

Monitor the average number of transactions per group for the total DSI connection by reviewing these counters:

  • 5000 – DSIReadTranGroups

  • 5002 – DSIReadTransUngrouped

Monitor why groups are being closed by reviewing these counters:

  • 5042 – GroupsClosedBytes

  • 5043 – GroupsClosedNoneOrig

  • 5044 – GroupsClosedMixedUser

  • 5045 – GroupsClosedMixedMode

  • 5049 – GroupsClosedTranPartRule

  • 5051 – UserRuleMatchGroup

  • 5053 – TimeRuleMatchGroup

  • 5055 – NameRuleMatchGroup

  • 5063 – GroupsClosedTrans

  • 5068 – GroupsClosedLarge

  • 5069 – GroupsClosedWSBSpec

  • 5070 – GroupsClosedResume

  • 5071 – GroupsClosedSpecial

  • 5072 – OriginRuleMatchGroup

  • 5074 – OSessIDRuleMatchGroup

  • 5076 – IgOrigRuleMarchGroup

Parent topic: Specify the Number of Transactions in a Group