DB2 Linux

[mteamjpy]

Hi all,

Just need information about how you perform DB2 database deployed on RHEL 6 (5) with veeam ?

script seems to be current solution can you give me some samples ?

thanks in advances

[mteamjpy]

i still need some more info about it ,

do somebody already perform such backup ?

[dellock6]

You have to place scripts here:
/usr/sbin/post-thaw-script
/usr/sbin/pre-freeze-script
make it executable, and inside them place the code you need. Never worked with DB2, so I do not know how to dump a DB2 database via shell.

Luca.

[mteamjpy]

thanks luca ,
indeed me neither so i need to be sure about this

majority of the production is based on this

[Vitaliy S.]

Generally these scripts just stop and start db services at the time when the snapshot takes place. Anyway, for the proper pre-freeze and post-thaw scripts it might be better to refer to IBM (DB2) community forums.

[mteamjpy]

Hi ,
thanks for the info
i would have prefered a non stop database .
I know that linux get VSS also and that DB2 use it
somebody else already write about it
http://forums.veeam.com/viewtopic.php?f=2&t=9815
and there is some explanation here about how stopping write
http://www.ibm.com/developerworks/forum ... D=14611785

what i hope,in maesure that i can close all veeam sceptical argument ,
is to use a kind of uair for DB2 first on windows then Linux
http://www.ibm.com/developerworks/data/ ... lligan.html
and i am quite sure it is possible
and i will not be the only one to love it

[mteamjpy]

hello community ,
any thought ?

[Vitaliy S.]

What does the documentation of DB2 application say about these scripts? Did you find any examples?

BTW - quick search returned me this links, please check it out, might help:
http://publib.boulder.ibm.com/infocente ... 008635.htm

[mteamjpy]

Hi vitaly ,
we are a little deeper into our research ...

my DB2 admin said that article that you mention is now unsuported and stop the database during the process (impossible for our cases)

he recommend me this approach
Http://pic.dhe.ibm.com/infocenter/db2lu ... 06423.html
what he need to be sure of is the process :
what he want is :
pre freeze.
snapshot
un freeze
backup

what he do not want is

pre freeze
snapshot
backup
unfreeze

otherwize we will have disk issues and databases crash (2TB of data)
could you confirm me the normal applicated procedure ?
otherwise could I alternate it ?

thanks in advances ,
once i will finish this , i will try to put a tutorial
thanks

Jean-pol

[Vitaliy S.]

This is how it works, so you should be fine:

(1) Pre-freeze: enable backup mode
(2) Create snapshot
(3) Post-thaw: remove backup mode
(4) Veeam backup