Consultor Eletrônico



Kbase P119075: Replication source database slows down during heavy database writes.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   25/05/2010
Status: Verified

SYMPTOM(s):

Replication source database slows down during heavy database writes.

Terminating the Replication Server process causes performance to pick back up.

-pica set to maximum value of 256

Using fixed AI Extents

Ai and Bi blocksizes are set to 16.

FACT(s) (Environment):

Progress 9.1E
OpenEdge 10.1A
OpenEdge 10.1B
OpenEdge 10.0B
UNIX
Windows

CAUSE:

Bug# OE00131166

CAUSE:

As the DBService queue fills up, performance drops as Replication is unable to acknowledge notes.

FIX:

In replication enabled environments experiencing this issue, upgrade to 10.1A02, 10.1B01 and later versions then increase the -pica database startup parameter higher.
The new maximum value is 8192.