Kbase P6758: Do I need to recalculate Blocks in Database Buffers (-B) when migrating my database ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/08/2006 |
|
Status: Unverified
GOAL:
Do I need to recalculate Blocks in Database Buffers (-B) post migration?
GOAL:
Considerations when I change the database blocksize
FIX:
It is only necessary to recalculate Blocks in Database Buffers (-B) startup parameter, IF the database blocksize was changed for the migration.
For example:
If the "pre-migration" database used a -B 100000 with a 1KB blocksize, it was addressing approximately 98 MB of shared-memory.
If the "post-migration" database still uses a -B 100000 with an 8KB blocksize, it is now addressing approximately 781 MB of shared-memory.
So, for the "post-migration" database to still use 98MB of shared-memory (as before), the -B now needs to be 12500 (*8KB database blocksize =~ 98MB)