another enterprise replication
1/ Is
it possible to replicate a table to anothet table ? The new table has more
fields and maybe another primary key ?
2/ I have a HDR pair in my EDR replication. This works fine. When I put my
primary (hdr) off, and place my secondary to accept all connections (onmode -d
standard). I try to use the cdr start command to start edr replication with my
secondary(hdr). The secondary are connected(local) but the other servers in
the replication have the status DROPPED. Am I missing something?
Can anyone help me here ?
Thx in advance !!
--0__=07BBE4F2DFCA6F118f9e8a93df938690918c07BBE4F2DFCA6F11
Content-type: multipart/alternative;
Boundary="1__=07BBE4F2DFCA6F118f9e8a93df938690918c07BBE4F2DFCA6F11"
--1__=07BBE4F2DFCA6F118f9e8a93df938690918c07BBE4F2DFCA6F11
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
See below.... I'll have to be really short right now because I have a=
meeting to get to. I'll respond in more detail later...
=
"BART DE TANDT" =
<zwinne_machinne@ To: ids@iiug.org =
pandora.be> cc: =
Sent by: Subject: another enterp=
rise replication [2728]
forum.subscriber@ =
iiug.org =
=
=
03/23/2004 11:55 =
PM =
=
1/ Is it possible to replicate a table to anothet table ? The new table=
has
more fields and maybe another primary key ?
Yes - but I would not advise it. - M.P.
2/ I have a HDR pair in my EDR replication. This works fine. When I put=
my
primary (hdr) off, and place my secondary to accept all connections (on=
mode
-d standard). I try to use the cdr start command to start edr replicati=
on
with my secondary(hdr). The secondary are connected(local) but the othe=
r
servers in the replication have the status DROPPED. Am I missing someth=
ing?
Probably a problem with sqlhosts. Could you enter the sqlhost file? T=
he
HDR pair need to be in the same group and need to be configured immedia=
tly
after the single group card. And all of the servers need to have the s=
ame
sqlhost file layout. - M.P.
Can anyone help me here ?
Thx in advance !!
=
--1__=07BBE4F2DFCA6F118f9e8a93df938690918c07BBE4F2DFCA6F11
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>See below.... I'll have to be really short right now because I hav=
e a meeting to get to. I'll respond in more detail later...<br>
<img src=3D"cid:10__=3D07BBE4F2DFCA6F118f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "BART DE TANDT=
" <zwinne_machinne@pandora.be>">"BART DE TANDT" &l=
t;zwinne_machinne@pandora.be><br>
<br>
<br>
<table V5DOTBL=3Dtrue width=3D"100%" border=3D"0" cellspacing=3D"0" cel=
lpadding=3D"0">
<tr valign=3D"top"><td width=3D"1%"><img src=3D"cid:20__=3D07BBE4F2DFCA=
6F118f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"72" al=
t=3D""><br>
</td><td style=3D"background-image:url(cid:30__=3D07BBE4F2DFCA6F118f9e8=
a93df938@us.ibm.com); background-repeat: no-repeat; " width=3D"1%"><img=
src=3D"cid:20__=3D07BBE4F2DFCA6F118f9e8a93df938@us.ibm.com" border=3D"=
0" height=3D"1" width=3D"225" alt=3D""><br>
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"BART DE TANDT" <zwinne_machinne@p=
andora.be></font></b><br>
<font size=3D"2">Sent by: forum.subscriber@iiug.org</font>
<p><font size=3D"2">03/23/2004 11:55 PM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"100%"><img src=3D"cid:20__=3D07BBE4F2DFCA6F118f9e8a93=
df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"1" face=3D"Arial"> </font><br>
<font size=3D"2"> To: </font><font size=3D"2">ids@iiug.org</font><br>
<font size=3D"2"> cc: </font><br>
<font size=3D"2"> Subject: </font><font size=3D"2">another enterprise r=
eplication [2728]</font></td></tr>
</table>
<br>
<br>
<tt>1/ Is it possible to replicate a table to anothet table ? The new t=
able has more fields and maybe another primary key ? </tt><br>
<br>
<tt>Yes - but I would not advise it. - M.P. <br>
<br>
2/ I have a HDR pair in my EDR replication. This works fine. When I put=
my primary (hdr) off, and place my secondary to accept all connections=
(onmode -d standard). I try to use the cdr start command to start edr =
replication with my secondary(hdr). The secondary are connected(local) =
but the other servers in the replication have the status DROPPED. Am I =
missing something? </tt><br>
<br>
<tt>Probably a problem with sqlhosts. Could you enter the sqlhost=
file? The HDR pair need to be in the same group and need to be c=
onfigured immediatly after the single group card. And all of the =
servers need to have the same sqlhost file layout. - M.P. <br>
<br>
Can anyone help me here ?<br>
<br>
Thx in advance !!<br>
<br>
<br>
</tt>
</body></html>=
--1__=07BBE4F2DFCA6F118f9e8a93df938690918c07BBE4F2DFCA6F11--
--0__=07BBE4F2DFCA6F118f9e8a93df938690918c07BBE4F2DFCA6F11
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=07BBE4F2DFCA6F118f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7
--0__=07BBE4F2DFCA6F118f9e8a93df938690918c07BBE4F2DFCA6F11
Content-type: image/gif;
name="ecblank.gif"
Content-Disposition: inline; filename="ecblank.gif"
Content-ID: <20__=07BBE4F2DFCA6F118f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7
--0__=07BBE4F2DFCA6F118f9e8a93df938690918c07BBE4F2DFCA6F11
Content-type: image/gif;
name="pic02096.gif"
Content-Disposition: inline; filename="pic02096.gif"
Content-ID: <30__=07BBE4F2DFCA6F118f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA
AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR
RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH
LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK
BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI
TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR
M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNUtJOUAVLoUr1+wqDGTE4zk+T6FG
uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO3mpOaKnL0Z2EKvNMSILEThKhCg
zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXpuFKhSYZALd0O5RKa2z9EYKBbpb
qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NENQj2jXjmfNgOZDaXb5glRmXQ33
YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4rwxxINMvpFFAz1KOODHiu+4aEw
NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoCWOOUwgltIwAKRxJgbIkJAQZEq0
2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ6ChjCAH3QlhJcT6VWE6FCkfCco
CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3QxhgohNKXJCWv8JQr/PDdaqd6w
2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iImTHEQyqJ4eIxJJoUBc+3CbBuwZE
V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4