Comprehensive data protection for all workloads
Post Reply
mteamjpy
Enthusiast
Posts: 74
Liked: never
Joined: Aug 10, 2011 12:31 pm
Contact:

DB2 Linux

Post by mteamjpy » Jun 07, 2012 2:20 pm

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
Enthusiast
Posts: 74
Liked: never
Joined: Aug 10, 2011 12:31 pm
Contact:

Re: DB2 Linux

Post by mteamjpy » Jul 11, 2012 12:43 pm

i still need some more info about it ,

do somebody already perform such backup ?

dellock6
Veeam Software
Posts: 5734
Liked: 1625 times
Joined: Jul 26, 2009 3:39 pm
Full Name: Luca Dell'Oca
Location: Varese, Italy
Contact:

Re: DB2 Linux

Post by dellock6 » Jul 11, 2012 3:18 pm 1 person likes this post

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.
Luca Dell'Oca
Principal EMEA Cloud Architect @ Veeam Software

@dellock6
https://www.virtualtothecore.com/
vExpert 2011 -> 2019
Veeam VMCE #1

mteamjpy
Enthusiast
Posts: 74
Liked: never
Joined: Aug 10, 2011 12:31 pm
Contact:

Re: DB2 Linux

Post by mteamjpy » Jul 11, 2012 3:47 pm

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

majority of the production is based on this

Vitaliy S.
Product Manager
Posts: 22999
Liked: 1557 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: DB2 Linux

Post by Vitaliy S. » Jul 11, 2012 3:53 pm 1 person likes this post

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
Enthusiast
Posts: 74
Liked: never
Joined: Aug 10, 2011 12:31 pm
Contact:

Re: DB2 Linux

Post by mteamjpy » Jul 12, 2012 8:43 pm

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
Enthusiast
Posts: 74
Liked: never
Joined: Aug 10, 2011 12:31 pm
Contact:

Re: DB2 Linux

Post by mteamjpy » Jul 19, 2012 8:22 am

hello community ,
any thought ?

Vitaliy S.
Product Manager
Posts: 22999
Liked: 1557 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: DB2 Linux

Post by Vitaliy S. » Jul 19, 2012 11:18 am

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
Enthusiast
Posts: 74
Liked: never
Joined: Aug 10, 2011 12:31 pm
Contact:

Re: DB2 Linux

Post by mteamjpy » Jul 27, 2012 5:37 am

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.
Product Manager
Posts: 22999
Liked: 1557 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: DB2 Linux

Post by Vitaliy S. » Jul 27, 2012 9:47 am 1 person likes this post

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

Post Reply

Who is online

Users browsing this forum: Baidu [Spider], Bing [Bot] and 13 guests