Kbase P136161: How to monitor the message replication queue set with the -pica parameter.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/9/2009 |
|
Status: Verified
GOAL:
How to monitor the message replication queue set with the -pica parameter.
GOAL:
How to monitor the RDBMS IPC queue during replication.
GOAL:
How to know if the value of the parameter -pica is enough.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
FIX:
The -pica sets the size (in Kb) of an internal message queue to be used between the database server and the replication server.
It contains notifications that RDBMS has just written an AI block.
It is important to set the size of ?pica properly, a queue being full causes the source DB to stalled.
This RDBMS IPC queue (-pica) can be monitored using promon (options R&D > 1 > 16).
Example:
Using promon at the source DB
proenv>promon source
________________________
OpenEdge Release 10.1B03 as of Sat Nov 3 00:53:18 EDT 2007
OpenEdge MONITOR Release 10
Database: C:\OpenEdge\WRK\source
1. User Control
2. Locking and Waiting Statistics
3. Block Access
4. Record Locking Table
5. Activity
6. Shared Resources
7. Database Status
8. Shut Down Database
R&D. Advanced options
T. 2PC Transactions Control
L. Resolve 2PC Limbo Transactions
C. 2PC Coordinator Information
J. Resolve JTA Transactions
M. Modify Defaults
Q. Quit
Enter your selection: r&d
________________________
10/18/08 OpenEdge Release 10 Monitor (R&D)
00:20:37 Main (Top) Menu
1. Status Displays ...
2. Activity Displays ...
3. Other Displays ...
4. Administrative Functions ...
5. Adjust Monitor Options
Enter a number, <return>, P, T, or X (? for help): 1
________________________
10/18/08 OpenEdge Release 10 Monitor (R&D)
00:20:40 Status Displays Menu
1. Database
2. Backup
3. Servers
4. Processes/Clients ...
5. Files
6. Lock Table
7. Buffer Cache
8. Logging Summary
&nb.sp; 9. BI Log
10. AI Log
11. Two-Phase Commit
12. Startup Parameters
13. Shared Resources
14. Shared Memory Segments
15. AI Extents
16. Database Service Manager
17. Servers By Broker
Enter a number, <return>, P, T, or X (? for help): 16
________________________
10/18/08 Status: Database Service Manager
00:20:44
Communication Area Size : 65.00 KB
Total Message Entries : 594
Free Message Entries : 25 <- Needs to be greater than 0
Used Message Entries : 569
Registered Database Service Objects
Name Rdy Status Messages Locked by
OpenEdge Replication Server Y RUN 569
OpenEdge RDBMS Y REG 0
Enter <return>, R, P, T, or X (? for help):
________________________
If Free Message Entries in the message queue becomes 0 the source DB will stall. .