backup with multiple targets

[sandeep.iitk@gmail.com]

Hi All,
I was trying to make backup faster so After studying I used this cmd
for backup:-

db2 backup db <dbname to /bkup/dir1, /bkup/dir2 compress without
prompting;


backup went successful and it was faster than previous too.

But need help to understand the procedure to restore from these 2
images. please Help.

Thanks
sandy

[w.l.fischer@googlemail.com]

Re: backup with multiple targets

On Oct 20, 10:39 pm, "sandeep.i...@g mail.com" <sandeep.i...@g mail.com>
wrote:

Hi All,
I was trying to make backup faster so After studying I used this cmd
for backup:-
>
db2 backup db <dbname to /bkup/dir1, /bkup/dir2 compress  without
prompting;
>
backup went successful and it was faster than previous too.
>
But need help to understand the procedure to restore from these 2
images. please Help.
>
Thanks
sandy

What's the problem with

db2 restore db <dbnamefrom /bkup/dir1,/bkup/dir2 without rolling
forward

Consider also that backup may be considerably faster without the
compress option.

[sandeep.iitk@gmail.com]

Re: backup with multiple targets

hi ,
I will try your cmd. i haven't tried it as i was not confirmed that
it will work or not?

as far as command without compress shud take less time but compression
is reducing my backup image size by 10 times.

right now its taking 50 min. can you tell me any disadvantage of using
multiple backup image....Like more time required when
restoring ....plz enlighten me :)

Thanks in advance.
Sandy