Replication (CDR) with Informix IDS 7.30 UC2
Posted in 1999
Topics: High Availability & Replication, Stored Procedures & SPL, Versions, Editions & End-of-Life
Hi, there.
I am using Informix Dynamic Server Version 7.30.UC2 on IRIX system.
And I need to on-line backup a part of the data in central machine to other
systems.
So, I defined cdr server(sync server) and other participants on center
system for replication.
It seemed to be good and it worked well.
And there was no problem until I defined replicates for the 8th cdr server.
When I defined the replicates for 8th CDR server(its id was 3), it displayed
error message like this in online.log.
00:36:13 CDR GC peer processing failed: message 1, error 37, CDR server 3
And when I started the replicates, it also displayed like this,
00:43:19 CDR GC peer processing failed: message 3, error 31, CDR server 3
finderr said that the error 37 and 31 are operating system errors.
I don't know how can I resolve this problem.
I have more systems to be backed up the center. and I can't make it because
of the above errors.
If you have an experience with CDR and Replicates using Informix,
pls, send me e-mail or list it on this board and I appriciate you very much.
Thanks.
First of all - Please consider moving to 7.31 or 9.2. ER stability is much
better in those levels than in prior levels.
For the GC (Global Catalogue) you need to check
$INFORMIXDIR/incl/esql/cdrerr.h. In there you will find that error 37 is an
undefined server and that error 30 is an undefined replicate.
You can also get this information by using "cdr error".
±èÀμ÷ wrote:
> Hi, there.
> I am using Informix Dynamic Server Version 7.30.UC2 on IRIX system.
> And I need to on-line backup a part of the data in central machine to other
> systems.
> So, I defined cdr server(sync server) and other participants on center
> system for replication.
> It seemed to be good and it worked well.
> And there was no problem until I defined replicates for the 8th cdr server.
>
> When I defined the replicates for 8th CDR server(its id was 3), it displayed
> error message like this in online.log.
>
> 00:36:13 CDR GC peer processing failed: message 1, error 37, CDR server 3>
> And when I started the replicates, it also displayed like this,
>
> 00:43:19 CDR GC peer processing failed: message 3, error 31, CDR server 3>
> finderr said that the error 37 and 31 are operating system errors.
> I don't know how can I resolve this problem.
> I have more systems to be backed up the center. and I can't make it because
> of the above errors.
>
> If you have an experience with CDR and Replicates using Informix,
> pls, send me e-mail or list it on this board and I appriciate you very much.
>
> Thanks.
--
Madison Pruet
===========================================
Enterprise Replication Product Developement
Dallas, Texas
Informix Software
===========================================