IDS Forum

RE: E.R. Replication Issue (Shadow Table Creat....

Posted By: Clifton Bean
Date: Thursday, 23 October 2008, at 10:13 a.m.

In Response To: Re: E.R. Replication Issue (Shadow Table Creation (Madison Pruet)

Thanks for responding, Madison.

The root server is the xxx_server. I forgot to mention that we had received this message ... on both servers within seconds of each:
CDR CDRDS: transaction aborted (Error in retrieving the replicate's attributes)

This morning, the replicate was created successfully ... AFTER changing the -c yyy_serv to -c xxx_serv within the replicate definition. The replicate was defined as INACTIVE on both servers. A cdr start command was then issued and was successful and record inserted demostrate that replication is indeed active.

Any ideas as to why the "switch"? I do not see any messages in either of the log files that are out of the norm.

Are we "safe"?

Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
1431 Greenway Drive #700
Irving, Texas 75038
Main (972) 812-1411 x244
Toll Free (800) 834-8807 x244
Fax (469) 417-0665

________________________________

From: ids-bounces@iiug.org on behalf of Madison Pruet
Sent: Wed 10/22/2008 5:45 PM
To: ids@iiug.org
Subject: Re: E.R. Replication Issue (Shadow Table Creat.... [13764]

See below.

-------------------------------------
Madison Pruet, STSM
IDS Replication Architect

=

"Clifton Bean" =

<Clifton.Bean@ctm =

..com> =
To

Sent by: ids@iiug.org =

ids-bounces@iiug. =
cc

org =

Subj=
ect

E.R. Replication Issue (Shadow =

10/22/2008 05:28 Table Creation .... [13762] =

PM =

=

=

Please respond to =

ids@iiug.org =

=

=

9.21.UC5XF AIX 5.2

(Yes, we are trying to get our customer upgraded to 10.00.UC8 by EOQ1
2009.)

We are experiencing an issue where we attempt to create the following
replicate on the root server:

cdr def repl -c yyy_serv -C timestamp -S row -R -A misc_mut_calc \

"miscdb@yyy_serv:root.mut_calc" "select * from mut_calc" \

"miscdb@xxx_serv:root.mut_calc" "select * from mut_calc";

Check the message log file on xxx_serv. Another option is to delete th=
e
replicate and then try to recreate it on the xxx_serv. That way you mi=
ght
get an error message describing the reason that the replicate could not=
be
created on that node.

Another possibility is that the network connection between yyy_serv and=

xxx_serv is currently down and the create replicate control message is
still sitting in the queue on node yyy_serv.

The replicate is created on the yyy_serv as INACTIVE but is not created=

on the xxx_serv. The shadow table is not on the xxx_serv but is on the
yyy_serv. Though the cdr error command does not list this particular
table, it does list prior issues with the inability to create the delet=
e
table. There is quite a bit of space within the dbspace so it should
have been able to create the table. I looked for the shadow table of
the INACTIVE replicate on the root server and could not find it there.

Can anyone suggest anything for me to look at to resolve the inability
to create a shadow (cdr_deltab) table within the root server - as I am
guessing that is why I see the replicate created on the yyy_serv but no=
t
on the xxx_serv?

Thanks in advance ... any assistance will be appreciated.

Take care.

Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
1431 Greenway Drive #700
Irving, Texas 75038

Main (972) 812-1411 x244

Toll Free (800) 834-8807 x244

Fax (469) 417-0665

***********************************************************************=
********

Forum Note: Use "Reply" to post a response in the discussion forum.

=

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• E.R. Replication Issue (Shadow Table Creation ...
  Clifton Bean -- Wednesday, 22 October 2008, at 6:28 p.m.
  • Re: E.R. Replication Issue (Shadow Table Creation
    Obnoxio The Clown -- Wednesday, 22 October 2008, at 6:31 p.m.
  • Re: E.R. Replication Issue (Shadow Table Creation
    Madison Pruet -- Wednesday, 22 October 2008, at 6:45 p.m.
    • RE: E.R. Replication Issue (Shadow Table Creat....
      Clifton Bean -- Thursday, 23 October 2008, at 10:13 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.