PROMON Status: Database Service Manager Menu was enhanced beyond the Database Service Manager (PICA) Message Entries for additional diagnostics:
In 10.2B05, "Service Latch Holder"
In 10.2B08, 11.2, "Used HighWater Mark", "Area Filled Count","Access Count" and "Access Collisions"
To see this information,
Start a PROMON session against the Replication enabled source database.
From the PROMON main menu, enter R&D, then select 1. Status Displays, then 16. Database Service Manager
Example:
Status: Database Service Manager
Communication Area Size : 257.00 KB
Total Message Entries : 2350
Free Message Entries : 1349
Used Message Entries : 1001
Used HighWater Mark : 2350 # maximum number of PICA messages used for this run of the database
Area Filled Count : 3 # number of times the PICA queue has been filled for this run of the database
Service Latch Holder : -1 # user number of the current holder of the Database Service Manager queue latch (PICA queue); (a value of -1 indicates there is no holder)
Access Count : 1923065 # number of times the PICA queue has been accessed for this run of the database
Access Collisions : 2 # number of times that there has been collision on access to the PICA queue during this run of the database; (AIW and RPLS attempting simultaneous access)
Name Rdy Status Messages Locked by
OpenEdge Replication Server Y BUSYNP 1
OpenEdge RDBMS Y REG 0
