Kbase P98079: Increasing DB block size causes error: Invalid size of shared memory segment (1135)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/24/2004 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
SYMPTOM(s):
Increasing DB block size causes error: Invalid size of shared memory segment (1135)
Invalid size of shared memory segment (1135)
Database starts in single user mode.
Database is being started using the same -B parameter value.
CHANGE:
DB was dumped and loaded into a structure with a bigger block size.
CAUSE:
The -B parameter value is based on the DB block size units, the bigger the block size, the bigger the memory requirement is for the same -B value.
FIX:
The value of -B needs to be adjusted to use the same amount of memory as follows:
1) Multiply the original value of -B by the original DB block size.
Example:
proserve sports -B 150000
150,000 * 1 KB = 150,000 KB
2) Divide the resulting number of KB of memory by the new DB block size.
150,000 KB / 8 KB = 18750
3) Adjust the -B parameter value
proserve sports -B 18750