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, 9 11877
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
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.c om> wrote in message
news:11******** *************@g 44g2000cwa.goog legroups.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,
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?
Is WSII (personal edition ) available for free download? ib****@yahoo.co m 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?
I found the trial edition..Thanks .
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!
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.c om> wrote in message
news:11******** *************@g 49g2000cwa.goog legroups.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!
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.co m 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Cherrish Vaidiyan |
last post by:
Hello,
I have certain doubts regarding replication of Oracle 9i in Red Hat
Linux 9.
1) I want to implement asynchronous/synchronous multimaster
replication.I have heard about Replication Management Tool in OEM.
What are the steps to be taken initailly for using Replication
Management Tool ?
|
by: Karthik |
last post by:
Hi,
We have setup a publisher and a distributor in SQL 2000 running SP3.
Alongwith this we have setup a merge replication agent and its running
successfully inside the same network. I allow anonymous subscriptions and
the merge publication works successfully for anonymous pull subscriptions
also.
Now i am trying to setup the same scenario to setup replication over the
Internet using FTP. I have created a FTP site and given certain...
|
by: KWilliams |
last post by:
Hello,
We are trying to set up replication between different versions of SQL
Server (7 & 2000).
This is how the 2 servers are now setup:
DB1 - External web-server w/SQL Server 7
DB2 - Internal server w/SQL Server 2000
REPLICATION SETUP
|
by: NickName |
last post by:
Reading an article on replication for sql server 2k, it mentioned about
sp_repladdcolumn/sp_repldropcolumn stored procs, implying that when a
new column is added or dropped from source table, one needs to execute
some sp to ensure that related replication meta data would be in sync.
I'm just thinking loud here, essentially there are two ways to do it
(by design):
* manually making replication meta data match with source table meta
data...
|
by: Andy K |
last post by:
Hi ,
Finally i was able to setup my replication process between two
databases .
For those who were not following my story , i was trying to setup a
replication between two databases on different linux server (RH 7.3)
for UDB 7.x .
I did the capture with a : asnccp mong warm
| |
by: John |
last post by:
Hi
We have an access app (front-end+backend) running on the company network. I
am trying to setup replication for laptop users who go into field and need
the data synched between their laptops and the server upon return to the
office. I am planning it this;
Move all access tables to sql server and then link the tables to access
front-end mdb app (using odbc?). Copy the same setup (access front end + sql
backend) onto each laptop....
|
by: DickChristoph |
last post by:
Hi
I tried posting this query in microsoft.public.sqlserver.programming but got
no response.
I am new to replication but I am trying to setup up a transactional
replication of tables from one database to another in MSSQL 2000 (SP2).
My target tables have primary keys defined. Under publication properties I
go to the snapshot tab and for each table I clear the check box that says
|
by: sat |
last post by:
Hi All!
I have a small doubt in replication.Previously i was working
on replication with the databases under the same instance.So it worked
fine.
Now i'm facing a new problem which is like, now i want the
source db to be under one instance and target db to be under another
instance.
what i have done is i kept the source db(say sample) under
same instance (say db2) as it was before.Now i created a new
|
by: Veeru71 |
last post by:
Is there any tutorial or some kind of simple step-by-step instructions
to setup DB2 Queue Replication ? All I am trying to do is setup
replication on just 1 table from DB1 of Inst1 to DB2 of Inst2 (Linux
platform).
The info in Replication manuals is too overhelming I feel.
- Thanks
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |