Unix Technical Forum

ER NotionS - PrimaryTarget & Tables Differents

This is a discussion on ER NotionS - PrimaryTarget & Tables Differents within the Informix forums, part of the Database Server Software category; --> Hello, Thanks again for your help. We'll investigate this method but as you said, maybe, the banwidth will be ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-19-2008, 10:15 PM
Bj
 
Posts: n/a
Default ER NotionS - PrimaryTarget & Tables Differents

Hello,

Thanks again for your help. We'll investigate this method but as you
said, maybe, the banwidth will be the problem. I'll give you the
results when it is done.

I have another question if you still have a little time.

We have a Server on which we want to consolidate datas from Others
Servers

If, Serv_Centr is the Central Server with DataBase Serv_Centr
And, Serv_A and Serv_B are Server linked to manufactories
I have Two Tables to Replicate for instance. TableEq and TableNotEq

On The command "cdr define repl" I have the choice to put the R and
the P to say that it is Read-Only and Primary. But what does it mean ?
Personnaly, I put the ReadOnly for the Serv_A and Serv_B, so, I'm sure
that the Production DB will never be synchronised. But what I'm afraid
is that it mean that I had to put the Primary on the Serv_Centr. Am I
wrong with my philosophy ? In my case, what will be the direction of
the replication ?
From Serv_A and Serv_B TO Serv_Centr ( That what I'm looking for )
OR
From Serv_Centr TO Serv_A and Serv_B ( That is NOT what I'm looking
for )

Other Question :
For the table TableEq, it is easy, it is the same that all databases.
So, I can define a repl with "select * from TableEq"
For the table TableNotEq, how can I do to make understand that the
tables are different.

For instance,
Serv_A has his table with only a Primary Key called "manr"
Serv_B has the same table

I need that those tables have to be replicated on one table called
TableNotEqBIS that will have one column more that will be called
"siteno" and that will contain the name of the Serv_A from which the
datas are coming?
So,

If the table on serv_A has for example
manr 59
date 05102004
name Bj
And on the table on serv_B
manr 59
date 05102004
name Bj

I should have on serv_Centr the table with the column "siteno" added
1rst Row
siteno ServA
manr 59
date 05102004
name Bj
2nd Row
siteno ServB
manr 59
date 05102004
name Bj

Regards,
Bj
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:36 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com