472,342 Members | 2,556 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,342 software developers and data experts.

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 2130
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Alan | last post by:
Gidday people, I had a bit of a problem this morning. I think I've got it sorted now, but I wonder if anyone can shed some light. I have a...
3
by: Thiko | last post by:
Hi I take one nightly full database backup at 02:00 and backup the transaction log to one backup set every 15mins. The commands to do this are...
3
by: jaekim | last post by:
Hi. I am wondering if it is a good idea to replicate sql server db files using frs. I don't really know how the frs works, so does frs...
6
by: Sri | last post by:
I am inserting records into a table - around 1 million records. I want to do the insert 10000 records at a time using TRAN. My insert statement is...
0
by: Yaro | last post by:
We are running on W2k3, DB2v8 Enterprise Srv, FP8. On our server we have one DB2 instance and 2 databases. On another stations we have .NET...
9
by: Chance Hopkins | last post by:
When using the sqlclient dotnet class and sql server. is it faster when doing a single (not multiple) insert to: 1- just do a simple connection...
1
by: Ken | last post by:
hi I have an Async WS updating my SQLserver DB 80 clients are connecting to the WS all day updating the DB I have only ONE UPDATE instruction in...
1
by: plsullivan63 | last post by:
Question: (SQL Server 2000) Can I arbitrarily delete a transaction log file in either bulk or full with a cron job and still be able to restore a...
3
by: FeelLikeANut | last post by:
I have the code below. First there is a transaction where I select data. I wrapped it in an explicit transaction because in my real program I run a...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.