This is from the 11.5 documentation.
First of all, from Configuring OpenEdge Databases : Viewing the various database configuration properties : Database configuration properties : Advanced database configuration properties
|
Database service communication area size
|
The value (which corresponds to the -pica command-line option) that sets the size of the databaseservice communications area. This area is used for storage of after-image block write notifications intended for OpenEdge Replication.
The minimum value is 4 and the maximum value is 8192; the value is entered in Kb units.
|
From Reference : Database Startup Parameters : Alphabetical listing of database startup parameters : Database Service Communication Area Size (-pica)
|
Use with
|
Maximum value
|
Minimum value
|
Single-user default
|
Multi-user default
|
|
DBS
|
1000000
|
4
|
–
|
16
|
When I try and set this value in OEM I can't set it higher than 8192, but the suggestion is that I should be able to set it as high as 1m. What am I missing?
That sounds like a bug in OEM's validation. Can you put it in other args instead?
Field validation in OE Mgmt has often been out-of-sync with valid values, especially for replication where the numbers continue to change relatively often. This was the case for some of the timeout values too.
Right - will try otherargs then for it. Ours is set to 8192 so could do with a boost.
I'm looking at the Database Service Manager screen in Promon. Is there a guide somewhere with what that's telling me? In other words, what should I look at in terms of working out if -pica is set correctly?
You can tell you have it set correctly when 72 of them make a foot ...
:) Happy thanksgiving Thomas!
You want to monitor the "Free Message Entries" versus the "Total Message Entries".
James, I'll bet you didn't know that I knew about this DBA stuff! :)
[quote user="Paul Koufalis"]
You want to monitor the "Free Message Entries" versus the "Total Message Entries".
[/quote]
Thanks Paul. Is there a VST for this info in 11.5?
Supposedly yes in 11.5 or 11.6 but I haven't checked which table.field yet. I just did a quick scan of the DB Admin Guide and Reference in 11.6 and I did not see it. Perhaps it's in one of the "What's New" docs.
In 11.6:
_DbServiceManager._DbSvcMgr-TotalMsgEntries
_DbServiceManager._DbSvcMgr-FreeMsgEntries
THanks Rob. Still on 11.5 so that will have to wait.
I swear Rob that was my first guess!
What a mouthful.