472,980 Members | 1,836 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,980 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 1635
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: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.