Enterprise Replication pains
Posted in 1998
Hi All,
I have to implement Enterprise Replication with approximately 500
replicates. I'm trying to write an awk script that will basically allow me
to just pass down a list of the tables and define the replicates
dynamically.
I've got 2 servers declared to ER, and now I'm trying to define replicates
using the following piece of awk code.
{
DBSERVER="repltest1"
REPLICATE=$1
DATABASE="stores7"
INFORMIXSERVER="testrep_dsa"DATABASE2="stores7"
INFORMIXSERVER2="recrep_dsa"
printf("define_repl -c %s %s -C \\"ignore\\" -S tran -A -R
\\"%s@%s:informix.%s\\" \\"select * from %s\\" \\"%s@%s:informix.%s\\" \\" select
* from %s
\\"\\n",DBSERVER,REPLICATE,DATABASE,INFORMIXSERVER,$1,$1,DATABASE2,INFORMIXSER
VER2,$1,$1)
}
When I run this script, informix returns the following:
command unsuccessful -- error 37
offending participant stores7@recrep_dsa:informix.call_type ' select * from
call_type '
command unsuccessful -- error 37
offending participant stores7@recrep_dsa:informix.catalog ' select * from
catalog '
command unsuccessful -- error 37
offending participant stores7@recrep_dsa:informix.cust_calls ' select * from
cust_calls '
command unsuccessful -- error 28
command unsuccessful -- error 37
offending participant stores7@recrep_dsa:informix.custview ' select * from
custview '
command unsuccessful -- error 37
offending participant stores7@recrep_dsa:informix.items ' select * from
items '
command unsuccessful -- error 37
offending participant stores7@recrep_dsa:informix.log_record ' select * from
log_record '
command unsuccessful -- error 37
offending participant stores7@recrep_dsa:informix.manufact ' select * from
manufact '
command unsuccessful -- error 37
offending participant stores7@recrep_dsa:informix.orders ' select * from
orders '
command unsuccessful -- error 37
offending participant stores7@recrep_dsa:informix.someorders ' select * from
someorders '
command unsuccessful -- error 37
offending participant stores7@recrep_dsa:informix.state ' select * from
state '
command unsuccessful -- error 37
offending participant stores7@recrep_dsa:informix.stock ' select * from
stock '
(I'm testing my scripts on the demo7 database)
I'm running Informix 7.23UC5 on HP-UX 10.20, any pointers would GREATLY be
appreciated!