In Sybase 12.5.0.3 anyway can i stup parallel backup and load using
Sybase backup server?

Chandan

Chandan wrote:
If by 'parallel' backup and load you mean kicking off multiple dumps and/or
loads at the same time with the same backupserver ... yes.

A few caveats come to mind ...

- you can't load a dump file that's still in the process of being dumped

- backupserver requires the dynamic allocation of system resources for each
dump/load command ... so eventually you could run into backupserver
errors/problems if you run out of system resources (typically related to
shared memory)

- if you'll be running a 'lot' of simultaneous dumps/loads (and/or with a
lot of stripes) you'll need to pay attention to some of the command line
parameters for backupserver (eg, -P, -N and possibly -m)

--
Mark A. Parsons

Iron Horse, Inc.
iron_horse (AT) NOSPAM (DOT) compuserve.com

Mark ,
Thx for your reply, Parallel mean i have a 70GB database I did 3
stripes and try to do a parallel dump.
OR I have a 90GB database dump with 10 stripes and try loading all
these stripes in parallel.
This is just for my biggest database to save some time and I have lots
of memory.

I already checked the -m and -p for the backup server, it just set the
shared memory value for upper limite and each stripe

But what will be the parameters to run parallel load or dump
simultaneous?
So that when we start the load command backup server start the
parallel load,
Can it be possible?




Chandan

"Mark A. Parsons" <iron_horse (AT) NOSPAM (DOT) compuserve.com> wrote

Chandan wrote:
This shouldn't be a problem.

Correct. I mentioned these in case you were running several dumps (with
quite a few stripes) all at once ... should you run into problems at that
time you may need to look at those parameters.

The default backupserver configuration should be able to handle your 70GBx3
and/or 90GBx10 dumps/loads without a problem.

If you do run into problems just post back here with your complete
dump/load command, any error messages you receive, and the contents of the
backupserver errorlog for the particular dump/load session in question.

--
Mark A. Parsons

Iron Horse, Inc.
iron_horse (AT) NOSPAM (DOT) compuserve.com