468,277 Members | 1,460 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,277 developers. It's quick & easy.

do i need to exclude transaction log while replicate

we are using db2 udb v8.2 Express edition on windows 2003,we use third
party vendor software to help replicate one server to another.

Production server has three instances, each instances has one database
under it. So we would see three folders on D drive: DB2 folder, TEST
folder and EDU folder, each database has 5 tablespaces and they exist
on F drive. So I told the client to replicate the three instance
folders on D and the data folder on F, that way the backup sever has
the same structure. So once the backup server start, it should
recognize the databases on the server and the data location, right?

There are SQL transaction log (e. g D:\DB2\NODE0000\SQL00003\SQLOGDIR)
and instance log file under D:\Program Files\IBM\SQLLIB\DB2\db2diag.log
, do I need to replicate them? any log file I need to exclude to
replicate? Please help.

Nov 12 '05 #1
2 2005
I don't think you can simply copy instance folders. YOu need to create
separate instances using the db2icrt command. You need to create the
databases using DB2 also I believe.

Larry Edelstein

db********@yahoo.com wrote:
we are using db2 udb v8.2 Express edition on windows 2003,we use third
party vendor software to help replicate one server to another.

Production server has three instances, each instances has one database
under it. So we would see three folders on D drive: DB2 folder, TEST
folder and EDU folder, each database has 5 tablespaces and they exist
on F drive. So I told the client to replicate the three instance
folders on D and the data folder on F, that way the backup sever has
the same structure. So once the backup server start, it should
recognize the databases on the server and the data location, right?

There are SQL transaction log (e. g D:\DB2\NODE0000\SQL00003\SQLOGDIR)
and instance log file under D:\Program Files\IBM\SQLLIB\DB2\db2diag.log
, do I need to replicate them? any log file I need to exclude to
replicate? Please help.


Nov 12 '05 #2
yes, i do db2icrt to create according instance on the backup server,
but they don't have any database exist, because we want to replicate
the instance folder to the backup server, does it still recognize it?

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Thiko | last post: by
reply views Thread by Yaro | last post: by
9 posts views Thread by Chance Hopkins | last post: by
1 post views Thread by Ken | last post: by
1 post views Thread by plsullivan63 | last post: by
3 posts views Thread by FeelLikeANut | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
1 post views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.