do i need to exclude transaction log while replicate

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

db2group88@yahoo.com - 15 Feb 2005 16:55 GMT

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.

Reply to this Message

Larry - 15 Feb 2005 17:13 GMT

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

> 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.
[quoted text clipped - 11 lines]
> , do I need to replicate them? any log file I need to exclude to
> replicate? Please help.

Reply to this Message

db2group88@yahoo.com - 15 Feb 2005 17:56 GMT

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?

Reply to this Message