By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,189 Members | 1,559 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,189 IT Pros & Developers. It's quick & easy.

do i need to exclude transaction log while replicate

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.