473,395 Members | 1,869 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

DB2 8.1 FP 5 Replication Setup - Source to Target Mapping Issues

Hello, all.

I'm having problem creating subcription sets for replication on UDB
DB2 Express Edition 8 fp5 on Windows 2000 Server.
I could not add member to the sets on the Source-To-Target Mapping.
The Capture schema at target server is grayed out. It complained that
"You have not specified the required properties for one or more
members". Thus the OK button is also grayed out. I have been trying to
find out what are the required properties that it needs. I already
read " A practical guide to DB2 UDB Data Replication V8" Redbook. But
I can't find the reason why it does not allow me to add members to
sets.

I created Capture Control tables on the source server and the Apply
Control tables on the target server. I tried to manage the member set
on the Apply Control Server (target server)

Please advise.

Thank you,

Trent
Nov 12 '05 #1
1 1839
In article <7a*************************@posting.google.com> , Trent
(pi****@yahoo.com) says...
Hello, all.

I'm having problem creating subcription sets for replication on UDB
DB2 Express Edition 8 fp5 on Windows 2000 Server.
I could not add member to the sets on the Source-To-Target Mapping.
The Capture schema at target server is grayed out. It complained that
"You have not specified the required properties for one or more
members". Thus the OK button is also grayed out. I have been trying to
find out what are the required properties that it needs. I already
read " A practical guide to DB2 UDB Data Replication V8" Redbook. But
I can't find the reason why it does not allow me to add members to
sets.

I created Capture Control tables on the source server and the Apply
Control tables on the target server. I tried to manage the member set
on the Apply Control Server (target server)

Please advise.

Thank you,

Trent


Did you run the 'alter table ... data capture changes ' command for
your source tables?
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Trent | last post by:
Hello,everyone. I'm setting a db2 replication environment using UDB version 8.1.5 running on Windows 2000 servers. The source server is on a Windows server with the capture program running while...
7
by: Andy K | last post by:
Hi , I have an existing database (on a Linux Red Hat ES3) where the replication function exists but does not work because the target database has been shutdown months ago . My question is...
1
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...
9
by: ibm_97 | last post by:
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...
6
by: RdR | last post by:
Hi, Has anyone encountered infinite looping in Q Replication? This happens when I have a source DB2 table A going to a target DB2 table B, it also happens that the samne target table B is...
2
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...
8
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...
3
by: Veeru71 | last post by:
We have got 2 DB2-UDB databases (DB1 & DB2) running on separate instances( Inst1 & Inst2). DB1 has got Schema1 and DB2 has got Schema2. We would like to setup some kind of replication to...
2
by: agskrishna | last post by:
Hi, Can you any one please help me in setting up the Data Replication between two windows machines. I have the basic setup done in two windows machines. And i have one capture table and two columns...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
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,...
0
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...
0
tracyyun
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...

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.