Informix Replication
Hi, I encounter problems when doing replication. I created new tables on 2 databases and I had to define the replicates for those 2 databases. This is the command I ran: cdr define repl -AR -C timestamp -S tran -i A_per_nrwu_grp_part2_C1 \\\\ "my_hq@grp_30_wart:dwafdba.per_nrwu_grp_part2" \\\\ " select * from per_nrwu_grp_part2" \\\\ "my_nc@grp_10_wart:dwafdba.per_nrwu_grp_part2" \\\\ " select * from per_nrwu_grp_part2" \\\\ When I run this script I get the following error message: command failed -- Shadow columns do not exist for table (56) Can anyone please help? I've been trying for 2 weeks now. Thanks. Regards Agnes
ALTER TABLE dwafdba.per_nrwu_grp_part2 ADD CRCOLS;
in both databases.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Thu, Apr 23, 2009 at 11:15 AM, AGNES NWAILA <nwailaa@dwaf.gov.za> wrote:
> Hi,
> I encounter problems when doing replication. I created new tables on
> 2 databases and I had to define the replicates for those 2 databases.
> This is the command I ran:
> cdr define repl -AR -C timestamp -S tran -i A_per_nrwu_grp_part2_C1 \\\\
> "my_hq@grp_30_wart:dwafdba.per_nrwu_grp_part2" \\\\
> " select * from per_nrwu_grp_part2" \\\\
> "my_nc@grp_10_wart:dwafdba.per_nrwu_grp_part2" \\\\
> " select * from per_nrwu_grp_part2" \\\\
>
> When I run this script I get the following error message:
> command failed -- Shadow columns do not exist for table (56)
>
> Can anyone please help?
>
> I've been trying for 2 weeks now.
>
> Thanks.
>
> Regards
> Agnes
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5a84e38bb1a04683afa67
In order to use timestamp conflict resolution (-C timestamp), you must =
add
the Shadow Conflict Resolution columns to the table. This is done by
altering the table as ...
alter table per_nrwu_grp_part2 add CRCOLS;
You will need to do this on both nodes.
=
"AGNES NWAILA" =
<nwailaa@dwaf.gov =
.za> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
Informix Replication [15598] =
04/23/2009 10:15 =
AM =
=
=
Please respond to =
ids@iiug.org =
=
=
Hi,
I encounter problems when doing replication. I created new tables on
2 databases and I had to define the replicates for those 2 databases.
This is the command I ran:
cdr define repl -AR -C timestamp -S tran -i A_per_nrwu_grp_part2_C1 \\\\
"my_hq@grp_30_wart:dwafdba.per_nrwu_grp_part2" \\\\
" select * from per_nrwu_grp_part2" \\\\
"my_nc@grp_10_wart:dwafdba.per_nrwu_grp_part2" \\\\
" select * from per_nrwu_grp_part2" \\\\
When I run this script I get the following error message:
command failed -- Shadow columns do not exist for table (56)
Can anyone please help?
I've been trying for 2 weeks now.
Thanks.
Regards
Agnes
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=