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

DB2 replication setup step by step

P: n/a
Hi,

Anyone can give me a link which shows how to setup DB2 (v8) replication
step by step? Thanks.

As a non-DB2 person, I find out IBM DB2 doc is not very helpful at all,
espeically compare with Oracle docs.

Regards,

Nov 12 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
There are several excellent "Redbooks" relating to version 8
replication. I would recommend this site: http://www.redbooks.ibm.com/
and a search on "db2 replication". Redbooks are frequently more
accessible and example-driven than the reference manuals and user
guides. Both have their place, but I always look at this site for
guidance on the newer technology offerings from IBM. In particular,
look for "Q Replication Fast Track scenarios" - it's a good one.

Also, publication number GC18-7567-00 is " Introduction to Replication
and Event Publishing" - not a Redbook, but an excellent overview of
replication solutions. HTH

Pete H

Pete H

Nov 12 '05 #2

P: n/a
Thanks a lot!

Nov 12 '05 #3

P: n/a
RdR
I can FTP to you some step by step documents that will setup DB2
replication, you will need WS II and a SQL Server or an Oracle database
though.

Thanks,

RdR

<ib****@yahoo.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...
Hi,

Anyone can give me a link which shows how to setup DB2 (v8) replication
step by step? Thanks.

As a non-DB2 person, I find out IBM DB2 doc is not very helpful at all,
espeically compare with Oracle docs.

Regards,

Nov 12 '05 #4

P: n/a
I can FTP to you some step by step documents that will setup DB2
replication, you will need WS II and a SQL Server or an Oracle database
though.

Thanks!
Do I need Oracle to setup DB2 replication? I have it. Could you email
me those docs instead?

Nov 12 '05 #5

P: n/a
Is WSII (personal edition ) available for free download?

ib****@yahoo.com wrote:
I can FTP to you some step by step documents that will setup DB2
replication, you will need WS II and a SQL Server or an Oracle database
though.

Thanks!
Do I need Oracle to setup DB2 replication? I have it. Could you email
me those docs instead?


Nov 12 '05 #6

P: n/a
I found the trial edition..Thanks.

Nov 12 '05 #7

P: n/a
I tried to setup replication between my 2 testing PCs.

Status of capture looks fine. The status of apply is 'presumed down'.
Don't know why. Here is somthing I don't understand.

1. In the startup capture/apply window from replication center, IBM
asks 'database name', 'instance name', etc. Why does it ask db
directory? If I have one tablespace in /ts1, another on is in /ts2,
system tablespace is in /ts3 which one should I enter (/ts3)?

2. How can I dubug the errors?

3. In my initial setup, PC A (source server) has data, PC B (target
server) has nothing. Now we have all the table definitions created in
PC B, but don't have any data.

4. IBM redbook is better than IBM docs, but still I have to guess in
many cases. Compare with Oracle's doc about RAC, AR, Grid, Steam, IBM
should have done better.

Thanks!

Nov 12 '05 #8

P: n/a
RdR
Hikums,

Maybe you can forward ibm_97 the docs I forwarded you, that will allow him
to setup db2 to sql using the GUI or scripts. I still have that 3 MB
limitation on email attachments.

Thanks,

RdR

<ib****@yahoo.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...
I tried to setup replication between my 2 testing PCs.

Status of capture looks fine. The status of apply is 'presumed down'.
Don't know why. Here is somthing I don't understand.

1. In the startup capture/apply window from replication center, IBM
asks 'database name', 'instance name', etc. Why does it ask db
directory? If I have one tablespace in /ts1, another on is in /ts2,
system tablespace is in /ts3 which one should I enter (/ts3)?

2. How can I dubug the errors?

3. In my initial setup, PC A (source server) has data, PC B (target
server) has nothing. Now we have all the table definitions created in
PC B, but don't have any data.

4. IBM redbook is better than IBM docs, but still I have to guess in
many cases. Compare with Oracle's doc about RAC, AR, Grid, Steam, IBM
should have done better.

Thanks!

Nov 12 '05 #9

P: n/a

1. db directory on windows by default is c:\DB2, but it can be changed when
issuing the CREATE DATABASE statement
this is NOT the directory where your data is located.

2. errors are collected in some system tables, you can also view them using
the replication center. debugging errors depends on what errors you get ...
which errors do you get ?

3. you need to have a point in time to get your 2 databases in synch. options:

- manually move data and start
- full refresh using utilities triggered by your replication

for a quick startup I'd probably choose a full refresh when starting
replication (should be a setting for each subscription), then DB2 takes care
of that.
But: for large tables this obviously is not always the fastest way. For
complete databases a manual solution with a backup is always better, using
apply can avoid maintenance outages

4. the tutorial for replication is not that bad
If you do know which steps you have to do (a full refresh to synch data is
certainly same everywhere) you can find the information on how-to do. It
takes some time to get used to the way the documentation is structured, but
then it is ok.

Once you set it up with SQL, ever considered MQ replication ? really cute and
fast way to replicate

Juliane

ib****@yahoo.com wrote:
I tried to setup replication between my 2 testing PCs.

Status of capture looks fine. The status of apply is 'presumed down'.
Don't know why. Here is somthing I don't understand.

1. In the startup capture/apply window from replication center, IBM
asks 'database name', 'instance name', etc. Why does it ask db
directory? If I have one tablespace in /ts1, another on is in /ts2,
system tablespace is in /ts3 which one should I enter (/ts3)?

2. How can I dubug the errors?

3. In my initial setup, PC A (source server) has data, PC B (target
server) has nothing. Now we have all the table definitions created in
PC B, but don't have any data.

4. IBM redbook is better than IBM docs, but still I have to guess in
many cases. Compare with Oracle's doc about RAC, AR, Grid, Steam, IBM
should have done better.

Thanks!

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200507/1
Nov 12 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.