ids 94 cdr set problem
A user on IDS 9.4 wanted Enterprise Replication to copy table t from database stores_demo on server A to stores_demo on server B, and then on to a second database (demo) residing in the same instance as server A. The first leg worked, but data never reached the demo database. Madison Pruet explained the cause: ER does not support replicating between two databases within the same instance. Suggested alternatives were a synonym/alias (rejected by the poster because the table holds an image/BLOB column) or triggers, but no confirmed working solution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
dear all, i try to define a replicat from A server A database to A server B database and C server C database. could anyone help me how to set the replication? thanks in advance
here is more information... I try to define a replicat from A server A database to A server B database and C server C database. A server B server stores_demo ------> stores_demo table t table t | | A server | demo <----------------- | table t a. SQLHOSTS g_bono group - - i=1 bono onsoctcp 192.168.1.51 11531 g=g_bono g_edge group - - i=2 edge onsoctcp 192.168.1.52 12531 g=g_edge b. define server cdr define server -I g_bono cdr define server -S g_bono -I g_edge c.define replicate cdr define repl -C ignore -R -A r_table \\\\ "P stores_demo@g_bono:informix.t" "select * from t" \\\\ "R stores_demo@g_edge:informix.t" "select * from t" cdr define repl -C ignore -R -A r_table2 \\\\ "P stores_demo@g_edge:informix.t" "select * from t"\\\\ "R demo@g_bono:informix.t" "select * from t" I can update the data from stores_demo database in A server to stores_demo database in B server, but it can't transfer the data to demo database in A server. could anyone give me any idea to slove the problem? ＿＿＿＿＿＿＿＿＿＿ ＿＿＿＿＿＿＿＿＿＿ ＿＿＿＿＿＿＿＿＿＿ ＿＿＿＿＿＿＿＿＿＿ ＿＿ Posted By: FAN YANG <Send E-Mail> Date: Wednesday, 24 March 2010, at 5:48 a.m. dear all, i try to define a replicat from A server A database to A server B database and C server C database. could anyone help me how to set the replication? thanks in advance
ER doesn't support replicating from one database to another in the same= instance. = From: "FAN YANG" <fania.yang@gmail.com> = = To: ids@iiug.org = = Date: 03/24/2010 11:32 PM = = Subject: Re: ids 94 cdr set problem [19408] = = Sent by: ids-bounces@iiug.org = = here is more information... I try to define a replicat from A server A database to A server B datab= ase and C server C database. A server B server stores_demo ------> stores_demo table t table t | | A server | demo <----------------- | table t a. SQLHOSTS g_bono group - - i=3D1 bono onsoctcp 192.168.1.51 11531 g=3Dg_bono g_edge group - - i=3D2 edge onsoctcp 192.168.1.52 12531 g=3Dg_edge b. define server cdr define server -I g_bono cdr define server -S g_bono -I g_edge c.define replicate cdr define repl -C ignore -R -A r_table \\\\ "P stores_demo@g_bono:informix.t" "select * from t" \\\\ "R stores_demo@g_edge:informix.t" "select * from t" cdr define repl -C ignore -R -A r_table2 \\\\ "P stores_demo@g_edge:informix.t" "select * from t"\\\\ "R demo@g_bono:informix.t" "select * from t" I can update the data from stores_demo database in A server to stores_d= emo database in B server, but it can't transfer the data to demo database in A server. could anyone give me any idea to slove the problem? ＿＿＿＿＿＿＿＿＿= ;＿＿＿＿＿＿＿＿ᦆ= 3;＿＿＿＿＿＿＿＿ʍ= 43;＿＿＿＿＿＿＿＿A= 343;＿＿＿＿＿＿ Posted By: FAN YANG <Send E-Mail> Date: Wednesday, 24 March 2010, at 5:48 a.m. dear all, i try to define a replicat from A server A database to A server B datab= ase and C server C database. could anyone help me how to set the replication? thanks in advance ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
thanks~ But if ER doesn't support replicating from one database to another in the same instance, what could I do for this requirement? do you have any suggestion for that? Trigger is one way that I might try it later, but I am not sure if we can create a trigger specifies a column with image. Fan _________________________________________________________________________ ER doesn't support replicating from one database to another in the same= instance. = From: "FAN YANG" <fania.yang@gmail.com> = = To: ids@iiug.org = = Date: 03/24/2010 11:32 PM = = Subject: Re: ids 94 cdr set problem [19408] = = Sent by: ids-bounces@iiug.org = = here is more information... I try to define a replicat from A server A database to A server B datab= ase and C server C database. A server B server stores_demo ------> stores_demo table t table t | | A server | demo <----------------- | table t a. SQLHOSTS g_bono group - - i=3D1 bono onsoctcp 192.168.1.51 11531 g=3Dg_bono g_edge group - - i=3D2 edge onsoctcp 192.168.1.52 12531 g=3Dg_edge b. define server cdr define server -I g_bono cdr define server -S g_bono -I g_edge c.define replicate cdr define repl -C ignore -R -A r_table \\\\ "P stores_demo@g_bono:informix.t" "select * from t" \\\\ "R stores_demo@g_edge:informix.t" "select * from t" cdr define repl -C ignore -R -A r_table2 \\\\ "P stores_demo@g_edge:informix.t" "select * from t"\\\\ "R demo@g_bono:informix.t" "select * from t" I can update the data from stores_demo database in A server to stores_d= emo database in B server, but it can't transfer the data to demo database in A server. could anyone give me any idea to slove the problem? ＿＿＿＿＿＿＿＿＿= ;＿＿＿＿＿＿＿＿ᦆ= 3;＿＿＿＿＿＿＿＿ʍ= 43;＿＿＿＿＿＿＿＿A= 343;＿＿＿＿＿＿ Posted By: FAN YANG <Send E-Mail> Date: Wednesday, 24 March 2010, at 5:48 a.m. dear all, i try to define a replicat from A server A database to A server B datab= ase and C server C database. could anyone help me how to set the replication? thanks in advance ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
If these tables are in different databases of the same instance, Can you just define a link/alias... to get your things done? Replicate within one instance sounds a funny attempt? Frank On Thu, Mar 25, 2010 at 10:13 PM, FAN YANG <fania.yang@gmail.com> wrote: > thanks~ > > But if ER doesn't support replicating from one database to another in the > same > instance, what could I do for this requirement? do you have any suggestion > for > that? > > Trigger is one way that I might try it later, but I am not sure if we can > create a trigger specifies a column with image. > > Fan > > _________________________________________________________________________ > ER doesn't support replicating from one database to another in the same= > > instance. > > = > > From: "FAN YANG" <fania.yang@gmail.com> = > > = > > To: ids@iiug.org = > > = > > Date: 03/24/2010 11:32 PM = > > = > > Subject: Re: ids 94 cdr set problem [19408] = > > = > > Sent by: ids-bounces@iiug.org = > > = > > here is more information... > I try to define a replicat from A server A database to A server B datab= > ase > and > C server C database. > > A server B server > > stores_demo ------> stores_demo > > table t table t > > | > > | > > A server | > > demo <----------------- | > > table t > > a. SQLHOSTS > > g_bono group - - i=3D1 > > bono onsoctcp 192.168.1.51 11531 g=3Dg_bono > > g_edge group - - i=3D2 > > edge onsoctcp 192.168.1.52 12531 g=3Dg_edge > > b. define server > > cdr define server -I g_bono > > cdr define server -S g_bono -I g_edge > > c.define replicate > > cdr define repl -C ignore -R -A r_table \\\\ > > "P stores_demo@g_bono:informix.t" "select * from t" \\\\ > > "R stores_demo@g_edge:informix.t" "select * from t" > > cdr define repl -C ignore -R -A r_table2 \\\\ > > "P stores_demo@g_edge:informix.t" "select * from t"\\\\ > > "R demo@g_bono:informix.t" "select * from t" > > I can update the data from stores_demo database in A server to stores_d= > emo > database in B server, > > but it can't transfer the data to demo database in A server. > > could anyone give me any idea to slove the problem? > > ＿＿＿＿＿＿＿＿＿= > ;＿＿＿＿＿＿＿＿ᦆ= > 3;＿＿＿＿＿＿＿＿ʍ= > 43;＿＿＿＿＿＿＿＿A= > 343;＿＿＿＿＿＿ > > Posted By: FAN YANG <Send E-Mail> > Date: Wednesday, 24 March 2010, at 5:48 a.m. > > dear all, > > i try to define a replicat from A server A database to A server B datab= > ase > and > C server C database. could anyone help me how to set the replication? > > thanks in advance > > ***********************************************************************= > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e0cb4e887963235db00482b8009f
Becasue we have a column with image in the table, we can't use synonym to do this work. any other advise? fan >If these tables are in different databases of the same instance, Can you >just define a link/alias... to get your things done? Replicate within one >instance sounds a funny attempt? >Frank On Thu, Mar 25, 2010 at 10:13 PM, FAN YANG <fania.yang@gmail.com> wrote: > thanks~ > > But if ER doesn't support replicating from one database to another in the > same > instance, what could I do for this requirement? do you have any suggestion > for > that? > > Trigger is one way that I might try it later, but I am not sure if we can > create a trigger specifies a column with image. > > Fan > > _________________________________________________________________________ > ER doesn't support replicating from one database to another in the same= > > instance. > > = > > From: "FAN YANG" <fania.yang@gmail.com> = > > = > > To: ids@iiug.org = > > = > > Date: 03/24/2010 11:32 PM = > > = > > Subject: Re: ids 94 cdr set problem [19408] = > > = > > Sent by: ids-bounces@iiug.org = > > = > > here is more information... > I try to define a replicat from A server A database to A server B datab= > ase > and > C server C database. > > A server B server > > stores_demo ------> stores_demo > > table t table t > > | > > | > > A server | > > demo <----------------- | > > table t > > a. SQLHOSTS > > g_bono group - - i=3D1 > > bono onsoctcp 192.168.1.51 11531 g=3Dg_bono > > g_edge group - - i=3D2 > > edge onsoctcp 192.168.1.52 12531 g=3Dg_edge > > b. define server > > cdr define server -I g_bono > > cdr define server -S g_bono -I g_edge > > c.define replicate > > cdr define repl -C ignore -R -A r_table \\\\ > > "P stores_demo@g_bono:informix.t" "select * from t" \\\\ > > "R stores_demo@g_edge:informix.t" "select * from t" > > cdr define repl -C ignore -R -A r_table2 \\\\ > > "P stores_demo@g_edge:informix.t" "select * from t"\\\\ > > "R demo@g_bono:informix.t" "select * from t" > > I can update the data from stores_demo database in A server to stores_d= > emo > database in B server, > > but it can't transfer the data to demo database in A server. > > could anyone give me any idea to slove the problem? > > ＿＿＿＿＿＿＿＿＿= > ;＿＿＿＿＿＿＿＿ᦆ= > 3;＿＿＿＿＿＿＿＿ʍ= > 43;＿＿＿＿＿＿＿＿A= > 343;＿＿＿＿＿＿ > > Posted By: FAN YANG <Send E-Mail> > Date: Wednesday, 24 March 2010, at 5:48 a.m. > > dear all, > > i try to define a replicat from A server A database to A server B datab= > ase > and > C server C database. could anyone help me how to set the replication? > > thanks in advance > > ***********************************************************************= > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e0cb4e887963235db00482b8009f