Kbase P119063: Does the -Bp Private Read-only Buffers startup parameter apply when using proutil dbanalys?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/03/2010 |
|
Status: Unverified
GOAL:
Does the -Bp Private Read-only Buffers startup parameter apply when using proutil dbanalys?
GOAL:
Should -Bp be used with proutil -C dbanalysis online ?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
The dbanalys utility performs its task at block level - it reads each database block necessary to do its task. This includes reading each block of each storage area from the database in sequence, then examining the contents of the individual blocks, and also looks at various metadata tables (_file, _field, _index etc.).
The blocks are read through the database buffer pool rather than directly from disk, since reading directly from disk might yield an inaccurate representation of the database when running in multi-user mode.
Since dbanalys reads sequentially through the buffer pool, the -Bp client startup parameter is applicable (cf. the -Bp reference in the Database Administration Guide and Reference), and overall production performance should benefit from its use.