E.R. Replication Issue (Shadow Table Creation ...

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"; 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 delete 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 not 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

Clifton Bean wrote: > 9.21.UC5XF AIX 5.2 > > > Thanks in advance ... any assistance will be appreciated. How about mocking laughter and pointing? Does that work for you? :o) -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com

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. =

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.