Db Dumps and Shared Memory Segments - 04-09-2009 , 05:11 AM
I was of impression that if we need to stripe a database dump into say 8
then we need 8 shared memory segments as well. Is it correct?
Is there any link to worker processes and striping?
Thanx in advance
Re: Db Dumps and Shared Memory Segments - 04-09-2009 , 11:01 AM
No. If you dump with 8 stripes, backup will generate 8 sybmultbuf
processes to do the transfer, but this doesn't have anything to do
with ASE's shared memory segments. You can choose an arbitrary number
of stripes for each dump command (within the limits) without having
to reconfigure memory. You can think of sybmultbuf processes as
"backupserver worker processes", but there is no link to ASE worker
Re: Db Dumps and Shared Memory Segments - 04-09-2009 , 11:31 AM
[segments] will be needed by the backupserver and/or sybmultbuf processes.
How much shared memory [segments] needed will depend on the number of concurrent dump/load commands as well as the
number of stripes.
Some solved cases @ sybase.com that touch on this subject:
processes or ASE shared memory requirements.
Re: Db Dumps and Shared Memory Segments - 04-16-2009 , 04:24 AM
Thanks for the inputs.
So to sum up,
1. yes the shared memory segments and stripes have a relation - well
explained in case 11271468
2. worker processes do not come into picture, in case of backup
pls correct if I am wrong.
"Mark A. Parsons" <iron_horse (AT) no_spamola (DOT) compuserve.com> wrote