[progress Communities] [progress Openedge Abl] Forum Post: Re: Setting The -pica Parameter...

[George Potemkin]

Comparing the pica queues on source and target dbs: Source: 09/27/17 Status: Database Service Manager 16:30:53 Communication Area Size : 20500.00 KB Total Message Entries : 187428 Free Message Entries : 103103 Used Message Entries : 84325 Used HighWater Mark : 187428 Area Filled Count : 36203 Service Latch Holder : -1 Access Count : 150708477 Access Collisions : 25833 Registered Database Service Objects Name Rdy Status Messages Locked by OpenEdge Replication Server Y RUN 84325 Target: 09/27/17 Status: Database Service Manager 16:30:49 Communication Area Size : 20500.00 KB Total Message Entries : 187428 Free Message Entries : 187428 Used Message Entries : 0 Used HighWater Mark : 0 Area Filled Count : 0 Service Latch Holder : -1 Access Count : 24717946 Access Collisions : 141 Registered Database Service Objects Name Rdy Status Messages Locked by OpenEdge Replication Agent Y RUN 0 Access count on source db is 6 times larger than the one on target. Large Area Filled Count on source db and zero HWM on target.

Continue reading...