Kbase P134321: What is proutil <dbname> -C increaseto?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/1/2010 |
|
Status: Verified
GOAL:
What is proutil <dbname> -C increaseto?
GOAL:
Can I increase shared-memory online ?
GOAL:
Can I increase the Lock Table entries before I hit error 915 ?
GOAL:
What can I do when performance slows due to bi buffer waits ?
GOAL:
Can I do anything when I see Out of free shared memory. (14394)
GOAL:
How can I modify -B online?
GOAL:
How can I modify -bibufs online?
GOAL:
How can I modify -aibufs online ?
GOAL:
How can I modify -L online?
GOAL:
How can I modify -Mxs online?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1C
OpenEdge 10.2x
FIX:
OpenEdge 10.1C introduced new functionality for the proutil executable which allows online dynamic modification of some critical database parameters:
Number of Database Buffers (-B)
Size of Lock Table (-L)
Number of Before-Image Buffers (-bibufs)
Number of After-Image Buffers (-aibufs)
Excess Shared Memory Size (-Mxs)
The syntax for the function:
$ proutil db-name -C increaseto -B n -L n -bibufs n -aibufs n -Mxs n
Where:
- The parameters can be modified individually or in any combination.
- The parameter must only appear once within the command, if it is entered more than once the last value with a valid increase within the command string will be executed.
- This feature can not be used to decrease values online:
Example:
A 10.1C database is started with a -B of 10000 and needs to be doubled.
Status: Shared Memory Segments
Seg Id Size Used Free
1 12713984 47038992 46538680 500312
$ proutil prog101c -C increaseto -B 20000
Status: Shared Memory Segments
Seg Id Size Used Free
1 12713984 47038992 47038824 168
2 61538304 134217728 43610368 90607360
[prog101c.lg]
[2008/08/18@12:48:14.875-0400] P-4932 T-2832 I Usr 5: (7129) Usr 5 set name to Increase Params.
[2008/08/18@12:48:17.906-0400] P-4932 T-2832 I Usr 5: (13980) Increase Params increasing buffer pools size (-B) from 10000 to 20000.
[2008/08/18@12:48:18.015-0400] P-4932 T-2832 I Usr 5: (453) Logout by Increase Params on CON:.
Note:These changes are for the session. If you wish to have them permanently established, then include them in the database startup. To see the session changes while the database is running, run promon/#6 (Shared resources).