473,324 Members | 2,196 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,324 software developers and data experts.

Replication with Federated DB2UDB Tables

FM
Hello there:

We want to replicate onto the same server (Capture / Apply) tables
into federated DB2 - Tables but we are not able to do it...
I've tried it with Replication Center but don't see the way to do it.

Could someone give me a hint or tip to do it?

Thank ypou very much in advance.

Felix
Jan 2 '08 #1
3 1649
FM wrote:
Hello there:

We want to replicate onto the same server (Capture / Apply) tables
into federated DB2 - Tables but we are not able to do it...
I've tried it with Replication Center but don't see the way to do it.
I have done that in the past through Replication Center and it was a
straight-forward process. Where exactly do you get stuck?

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jan 3 '08 #2
FM
On Jan 3, 12:27*pm, Knut Stolze <sto...@de.ibm.comwrote:
FM wrote:
Hello there:
We want to replicate onto the same server (Capture / Apply) tables
into federated DB2 - Tables but we are not able to do it...
I've tried it with Replication Center but don't see the way to do it.

I have done that in the past through Replication Center and it was a
straight-forward process. *Where exactly do you get stuck?

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Hello Knut:

I have federated tables (wrapper/server/user mapping/nickname).
First I've cataloged remote database (also DB2 UDB on AIX) on my
capture/apply server.
I've registered capture/apply server but when i want to register the
source-table (nickname) it doesn't appear.
Perhaps you could send me a brief resume of what you have done to
compare what i'm doing wrong?

Thank you very much Knut

P.D.: Frohes Neues Jahr
Jan 3 '08 #3
FM
On Jan 3, 1:32*pm, FM <felix_manr...@yahoo.comwrote:
On Jan 3, 12:27*pm, Knut Stolze <sto...@de.ibm.comwrote:
FM wrote:
Hello there:
We want to replicate onto the same server (Capture / Apply) tables
into federated DB2 - Tables but we are not able to do it...
I've tried it with Replication Center but don't see the way to do it.
I have done that in the past through Replication Center and it was a
straight-forward process. *Where exactly do you get stuck?
--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Hello Knut:

I have federated tables (wrapper/server/user mapping/nickname).
First I've cataloged remote database (also DB2 UDB on AIX) on my
capture/apply server.
I've registered capture/apply server but when i want to register the
source-table (nickname) it doesn't appear.
Perhaps you could send me a brief resume of what you have done to
compare what i'm doing wrong?

Thank you very much Knut

P.D.: Frohes Neues Jahr
Hello again:

I've tried once more:
Source-Table T1 at DB_1
Capture/Apply at DB_2
Table T1 federated at DB_2
But no chance to register it with Replication Center....
Jan 3 '08 #4

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

Similar topics

7
by: stabbert | last post by:
I am attempting to join two tables together on two different unix servers. Here is some relevant info about the tables. TABLE 1 Setup ----------------------- DB2 UDB 7.2 EE
3
by: Terry | last post by:
Hi All, Im trying to run db2expln over some sql in order to find out why its so slow. I receive the following error message. LINE MESSAGES FOR DYNEXPLN.sqc ------ ...
0
by: Tek | last post by:
I have the following scenario: Box 1 is running Informix 7.31.UD4 on hpux 11i (Source DB) Box 2 is running IBM DB2 UDB 8.2 on hpux 11i (Apply and Target DB) After creating a new DB2 instance...
1
by: RdR | last post by:
Hi, I have a table in SQL Server with no keys, I point this as a federated table in DB2 but in DB2 I have defined keys against this federated table in SQL. Where will the key constraints be...
4
by: uthuras | last post by:
Greetings all, Is it possible to have federated db feature implemented among DB2 family? I intend to create federated within DB2 databases. I have 2 databases TestA and TestB. I have some base...
5
by: Rafael Faria | last post by:
Hello All, I'm new to DB2, so apologies in advance for any stupid comments I might make on this replication problem. Using Information integrator and DB2 8.2 I managed to create a nickname that...
3
by: Gert van der Kooij | last post by:
Hi, Our SQL Replication is between DB2 databases on Windows servers. I'm searching for the document which tells me how to migrate our SQL Replication environment from V8 to V9 (we also need to...
1
by: paul | last post by:
hi, i have db2 8.2 My problem i need to copy a set of tables (~500 - 40Go) from the production database to the integration database by script every sunday. The name of the database are not the...
0
by: FM | last post by:
Hello: Question's on replication. My replication-scenario: Server A -source-tables and capture-server Server B -destination-tables with CD tables federated in it and apply-server Inert...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.