SEO

Hello,

I'm trying to activate the enterprise replication between 2 servers.
When I type on each of the servers

################################################## ##############################

$ cdr list repl
REPLICATE STATE CONFLICT FREQUENCY OPTIONS
----------------------------------------------------------------------------
repl_dwi_coe ACTIVE ignore time 19:0 row
repl_dwi_head ACTIVE ignore time 19:0 row
repl_dwi_item ACTIVE ignore time 19:0 row
repl_dwi_sae ACTIVE ignore time 19:0 row
repl_dwmd_bran ACTIVE ignore time 19:0 row
repl_dwmd_claim ACTIVE ignore time 19:0 row
repl_dwmd_coce ACTIVE ignore time 19:0 row
repl_dwmd_coe ACTIVE ignore time 19:0 row
repl_dwmd_cont ACTIVE ignore time 19:0 row
repl_dwmd_coun ACTIVE ignore time 19:0 row
repl_dwmd_country ACTIVE ignore time 19:0 row
repl_dwmd_kind ACTIVE ignore time 19:0 row
repl_dwmd_partn ACTIVE ignore time 19:0 row
repl_dwmd_product ACTIVE ignore time 19:0 row
repl_dwmd_region ACTIVE ignore time 19:0 row
repl_dwmd_sae ACTIVE ignore time 19:0 row
repl_dwmd_site ACTIVE ignore time 19:0 row
repl_dwmd_staff ACTIVE ignore time 19:0 row
repl_dwmd_waregroup ACTIVE ignore time 19:0 row
repl_dwo_coe ACTIVE ignore time 19:0 row
repl_dwo_head ACTIVE ignore time 19:0 row
repl_dwo_item ACTIVE ignore time 19:0 row
repl_dwo_sae ACTIVE ignore time 19:0 row
repl_mitarb ACTIVE ignore time 19:0 row
repl_yag ACTIVE ignore time 19:0 row
repl_ykag ACTIVE ignore time 19:0 row
repl_yvowg ACTIVE ignore time 19:0 row
repl_yvuwg ACTIVE ignore time 19:0 row
cdr: can't fetch replicate
SQL code -461 :Cannot open file 'csql.iem'.

ISAM 0 :

################################################## ##############################

BUT on the online.log, I receive a lot of messages

05:05:10 CDR GC: cache query failed for repl/coll identifier 6422539.
05:05:10 CDR GC: cache query failed for repl/coll identifier 6422546.
05:05:10 CDR GC: cache query failed for repl/coll identifier 6422545.
05:05:10 CDR GC: cache query failed for repl/coll identifier 6422534.
05:05:10 CDR GC: cache query failed for repl/coll identifier 6422548.
05:05:10 CDR GC: cache query failed for repl/coll identifier 6422550.
05:05:10 CDR GC: cache query failed for repl/coll identifier 6422542.
05:05:10 CDR GC: cache query failed for repl/coll identifier 6422541.
05:05:10 CDR GC: cache query failed for repl/coll identifier 6422544.
05:05:10 CDR GC: cache query failed for repl/coll identifier 6422543.
05:05:10 CDR GC: cache query failed for repl/coll identifier 6422540.
05:05:10 CDR GC: cache query failed for repl/coll identifier 6422538.
05:05:10 CDR GC: cache query failed for repl/coll identifier 6422547.
05:05:10 CDR GC: cache query failed for repl/coll identifier 6422549.

Can someone say me why ?

Regards,
Bj

Version number?

This means that something has happened with the definition of the original
replicate definition.
We had a problem in 7.x product in which the pending states table was not
properly cleaned up when a replicate's state changed that would cause this
message as well. You might be running into that.

M.P.


"Bj" <Bruxelles.Jette@caramail.com> wrote in message
news:89d8947b.0405030241.8bb3f95@posting.google.co m...
> Hello,
>
> I'm trying to activate the enterprise replication between 2 servers.
> When I type on each of the servers
>
>
################################################## ##########################
####
>
> $ cdr list repl
> REPLICATE STATE CONFLICT FREQUENCY OPTIONS
> --------------------------------------------------------------------------
--
> repl_dwi_coe ACTIVE ignore time 19:0 row
> repl_dwi_head ACTIVE ignore time 19:0 row
> repl_dwi_item ACTIVE ignore time 19:0 row
> repl_dwi_sae ACTIVE ignore time 19:0 row
> repl_dwmd_bran ACTIVE ignore time 19:0 row
> repl_dwmd_claim ACTIVE ignore time 19:0 row
> repl_dwmd_coce ACTIVE ignore time 19:0 row
> repl_dwmd_coe ACTIVE ignore time 19:0 row
> repl_dwmd_cont ACTIVE ignore time 19:0 row
> repl_dwmd_coun ACTIVE ignore time 19:0 row
> repl_dwmd_country ACTIVE ignore time 19:0 row
> repl_dwmd_kind ACTIVE ignore time 19:0 row
> repl_dwmd_partn ACTIVE ignore time 19:0 row
> repl_dwmd_product ACTIVE ignore time 19:0 row
> repl_dwmd_region ACTIVE ignore time 19:0 row
> repl_dwmd_sae ACTIVE ignore time 19:0 row
> repl_dwmd_site ACTIVE ignore time 19:0 row
> repl_dwmd_staff ACTIVE ignore time 19:0 row
> repl_dwmd_waregroup ACTIVE ignore time 19:0 row
> repl_dwo_coe ACTIVE ignore time 19:0 row
> repl_dwo_head ACTIVE ignore time 19:0 row
> repl_dwo_item ACTIVE ignore time 19:0 row
> repl_dwo_sae ACTIVE ignore time 19:0 row
> repl_mitarb ACTIVE ignore time 19:0 row
> repl_yag ACTIVE ignore time 19:0 row
> repl_ykag ACTIVE ignore time 19:0 row
> repl_yvowg ACTIVE ignore time 19:0 row
> repl_yvuwg ACTIVE ignore time 19:0 row
> cdr: can't fetch replicate
> SQL code -461 :Cannot open file 'csql.iem'.
>
> ISAM 0 :
>
>
################################################## ##########################
####
>
> BUT on the online.log, I receive a lot of messages
>
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422539.
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422546.
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422545.
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422534.
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422548.
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422550.
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422542.
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422541.
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422544.
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422543.
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422540.
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422538.
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422547.
> 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422549.
>
> Can someone say me why ?
>
> Regards,
> Bj

HELLO,

I'm working with 2 SCO OpenServer 5.0.7.
Each with Informix Dynamic Server Version 7.31.UC2

Here is an example of one of my replicate definition

cdr define repl -C ignore -a "19:00" repl_dwmd_partn
"P alcib_53@g_MRX2:awserv.dwmd_partn"
"select pano,patype from dwmd_partn"
"R alcib_720@g_UGND:informix.dwmd_partn"
"select siteno,pano,patype from dwmd_partn;update dwmd_partn set
siteno=53"

As you can see, I have a primary with only 2 columns and I try to
replicate it on a target with 3 columns where I force the 1st column
"siteno" to still have the integer 53 as value.
Am I wrong when I do like that ?

Regards,
Noreddine

"Madison Pruet" <mpruet@comcast.net> wrote in message news:<qUslc.16546$IG1.572692@attbi_s04>...
> Version number?
>
> This means that something has happened with the definition of the original
> replicate definition.
> We had a problem in 7.x product in which the pending states table was not
> properly cleaned up when a replicate's state changed that would cause this
> message as well. You might be running into that.
>
> M.P.
>
>
> "Bj" <Bruxelles.Jette@caramail.com> wrote in message
> news:89d8947b.0405030241.8bb3f95@posting.google.co m...
> > Hello,
> >
> > I'm trying to activate the enterprise replication between 2 servers.
> > When I type on each of the servers
> >
> >
> ################################################## ##########################
> ####
> >
> > $ cdr list repl
> > REPLICATE STATE CONFLICT FREQUENCY OPTIONS
> > --------------------------------------------------------------------------
> --
> > repl_dwi_coe ACTIVE ignore time 19:0 row
> > repl_dwi_head ACTIVE ignore time 19:0 row
> > repl_dwi_item ACTIVE ignore time 19:0 row
> > repl_dwi_sae ACTIVE ignore time 19:0 row
> > repl_dwmd_bran ACTIVE ignore time 19:0 row
> > repl_dwmd_claim ACTIVE ignore time 19:0 row
> > repl_dwmd_coce ACTIVE ignore time 19:0 row
> > repl_dwmd_coe ACTIVE ignore time 19:0 row
> > repl_dwmd_cont ACTIVE ignore time 19:0 row
> > repl_dwmd_coun ACTIVE ignore time 19:0 row
> > repl_dwmd_country ACTIVE ignore time 19:0 row
> > repl_dwmd_kind ACTIVE ignore time 19:0 row
> > repl_dwmd_partn ACTIVE ignore time 19:0 row
> > repl_dwmd_product ACTIVE ignore time 19:0 row
> > repl_dwmd_region ACTIVE ignore time 19:0 row
> > repl_dwmd_sae ACTIVE ignore time 19:0 row
> > repl_dwmd_site ACTIVE ignore time 19:0 row
> > repl_dwmd_staff ACTIVE ignore time 19:0 row
> > repl_dwmd_waregroup ACTIVE ignore time 19:0 row
> > repl_dwo_coe ACTIVE ignore time 19:0 row
> > repl_dwo_head ACTIVE ignore time 19:0 row
> > repl_dwo_item ACTIVE ignore time 19:0 row
> > repl_dwo_sae ACTIVE ignore time 19:0 row
> > repl_mitarb ACTIVE ignore time 19:0 row
> > repl_yag ACTIVE ignore time 19:0 row
> > repl_ykag ACTIVE ignore time 19:0 row
> > repl_yvowg ACTIVE ignore time 19:0 row
> > repl_yvuwg ACTIVE ignore time 19:0 row
> > cdr: can't fetch replicate
> > SQL code -461 :Cannot open file 'csql.iem'.
> >
> > ISAM 0 :
> >
> >
> ################################################## ##########################
> ####
> >
> > BUT on the online.log, I receive a lot of messages
> >
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422539.
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422546.
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422545.
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422534.
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422548.
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422550.
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422542.
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422541.
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422544.
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422543.
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422540.
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422538.
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422547.
> > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422549.
> >
> > Can someone say me why ?
> >
> > Regards,
> > Bj

7.31 still uses the pending states table. I suspect that is where the error
messages are coming from. There was a problem with the pending states table
not being properly cleaned up when the state changed. It has been fixed with
current releases of 7.31.


"Bj" <Bruxelles.Jette@caramail.com> wrote in message
news:89d8947b.0405040029.2775c357@posting.google.c om...
> HELLO,
>
> I'm working with 2 SCO OpenServer 5.0.7.
> Each with Informix Dynamic Server Version 7.31.UC2
>
> Here is an example of one of my replicate definition
>
> cdr define repl -C ignore -a "19:00" repl_dwmd_partn
> "P alcib_53@g_MRX2:awserv.dwmd_partn"
> "select pano,patype from dwmd_partn"
> "R alcib_720@g_UGND:informix.dwmd_partn"
> "select siteno,pano,patype from dwmd_partn;update dwmd_partn set
> siteno=53"
>
> As you can see, I have a primary with only 2 columns and I try to
> replicate it on a target with 3 columns where I force the 1st column
> "siteno" to still have the integer 53 as value.
> Am I wrong when I do like that ?
>
> Regards,
> Noreddine
>
> "Madison Pruet" <mpruet@comcast.net> wrote in message
news:<qUslc.16546$IG1.572692@attbi_s04>...
> > Version number?
> >
> > This means that something has happened with the definition of the
original
> > replicate definition.
> > We had a problem in 7.x product in which the pending states table was
not
> > properly cleaned up when a replicate's state changed that would cause
this
> > message as well. You might be running into that.
> >
> > M.P.
> >
> >
> > "Bj" <Bruxelles.Jette@caramail.com> wrote in message
> > news:89d8947b.0405030241.8bb3f95@posting.google.co m...
> > > Hello,
> > >
> > > I'm trying to activate the enterprise replication between 2 servers.
> > > When I type on each of the servers
> > >
> > >
> >
################################################## ##########################
> > ####
> > >
> > > $ cdr list repl
> > > REPLICATE STATE CONFLICT FREQUENCY OPTIONS
> >
> --------------------------------------------------------------------------
> > --
> > > repl_dwi_coe ACTIVE ignore time 19:0 row
> > > repl_dwi_head ACTIVE ignore time 19:0 row
> > > repl_dwi_item ACTIVE ignore time 19:0 row
> > > repl_dwi_sae ACTIVE ignore time 19:0 row
> > > repl_dwmd_bran ACTIVE ignore time 19:0 row
> > > repl_dwmd_claim ACTIVE ignore time 19:0 row
> > > repl_dwmd_coce ACTIVE ignore time 19:0 row
> > > repl_dwmd_coe ACTIVE ignore time 19:0 row
> > > repl_dwmd_cont ACTIVE ignore time 19:0 row
> > > repl_dwmd_coun ACTIVE ignore time 19:0 row
> > > repl_dwmd_country ACTIVE ignore time 19:0 row
> > > repl_dwmd_kind ACTIVE ignore time 19:0 row
> > > repl_dwmd_partn ACTIVE ignore time 19:0 row
> > > repl_dwmd_product ACTIVE ignore time 19:0 row
> > > repl_dwmd_region ACTIVE ignore time 19:0 row
> > > repl_dwmd_sae ACTIVE ignore time 19:0 row
> > > repl_dwmd_site ACTIVE ignore time 19:0 row
> > > repl_dwmd_staff ACTIVE ignore time 19:0 row
> > > repl_dwmd_waregroup ACTIVE ignore time 19:0 row
> > > repl_dwo_coe ACTIVE ignore time 19:0 row
> > > repl_dwo_head ACTIVE ignore time 19:0 row
> > > repl_dwo_item ACTIVE ignore time 19:0 row
> > > repl_dwo_sae ACTIVE ignore time 19:0 row
> > > repl_mitarb ACTIVE ignore time 19:0 row
> > > repl_yag ACTIVE ignore time 19:0 row
> > > repl_ykag ACTIVE ignore time 19:0 row
> > > repl_yvowg ACTIVE ignore time 19:0 row
> > > repl_yvuwg ACTIVE ignore time 19:0 row
> > > cdr: can't fetch replicate
> > > SQL code -461 :Cannot open file 'csql.iem'.
> > >
> > > ISAM 0 :
> > >
> > >
> >
################################################## ##########################
> > ####
> > >
> > > BUT on the online.log, I receive a lot of messages
> > >
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422539.
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422546.
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422545.
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422534.
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422548.
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422550.
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422542.
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422541.
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422544.
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422543.
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422540.
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422538.
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422547.
> > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422549.
> > >
> > > Can someone say me why ?
> > >
> > > Regards,
> > > Bj

Hello,

What do you mean by "current releases of 7.31" ?

Other Question :
Is it possible to replicate columns from different table from the
primary to one table on the target ?
I can't find any example.

To be clear,

On Primary, I have table A with column1 and I have table B with
column2
I want to replicate this 2 columns to only one table C on the Target,
so, I should have Table C with column1 and column2.
Is it possible ?
Can you give me the syntax ?
Or a link where it is explained because in the "official" Informix
Replication Enterprise that I found on the IBM site, there is only
simple example using replication between 2 tables that are the same.

Thanks a lot for your help.

Bj

"Madison Pruet" <mpruet@comcast.net> wrote in message news:<CaOlc.31591$I%1.1980122@attbi_s51>...
> 7.31 still uses the pending states table. I suspect that is where the error
> messages are coming from. There was a problem with the pending states table
> not being properly cleaned up when the state changed. It has been fixed with
> current releases of 7.31.
>
>
> "Bj" <Bruxelles.Jette@caramail.com> wrote in message
> news:89d8947b.0405040029.2775c357@posting.google.c om...
> > HELLO,
> >
> > I'm working with 2 SCO OpenServer 5.0.7.
> > Each with Informix Dynamic Server Version 7.31.UC2
> >
> > Here is an example of one of my replicate definition
> >
> > cdr define repl -C ignore -a "19:00" repl_dwmd_partn
> > "P alcib_53@g_MRX2:awserv.dwmd_partn"
> > "select pano,patype from dwmd_partn"
> > "R alcib_720@g_UGND:informix.dwmd_partn"
> > "select siteno,pano,patype from dwmd_partn;update dwmd_partn set
> > siteno=53"
> >
> > As you can see, I have a primary with only 2 columns and I try to
> > replicate it on a target with 3 columns where I force the 1st column
> > "siteno" to still have the integer 53 as value.
> > Am I wrong when I do like that ?
> >
> > Regards,
> > Noreddine
> >
> > "Madison Pruet" <mpruet@comcast.net> wrote in message
> news:<qUslc.16546$IG1.572692@attbi_s04>...
> > > Version number?
> > >
> > > This means that something has happened with the definition of the
> original
> > > replicate definition.
> > > We had a problem in 7.x product in which the pending states table was
> not
> > > properly cleaned up when a replicate's state changed that would cause
> this
> > > message as well. You might be running into that.
> > >
> > > M.P.
> > >
> > >
> > > "Bj" <Bruxelles.Jette@caramail.com> wrote in message
> > > news:89d8947b.0405030241.8bb3f95@posting.google.co m...
> > > > Hello,
> > > >
> > > > I'm trying to activate the enterprise replication between 2 servers.
> > > > When I type on each of the servers
> > > >
> > > >
> > >
> ################################################## ##########################
> > > ####
> > > >
> > > > $ cdr list repl
> > > > REPLICATE STATE CONFLICT FREQUENCY OPTIONS
> > >
> --------------------------------------------------------------------------
> > > --
> > > > repl_dwi_coe ACTIVE ignore time 19:0 row
> > > > repl_dwi_head ACTIVE ignore time 19:0 row
> > > > repl_dwi_item ACTIVE ignore time 19:0 row
> > > > repl_dwi_sae ACTIVE ignore time 19:0 row
> > > > repl_dwmd_bran ACTIVE ignore time 19:0 row
> > > > repl_dwmd_claim ACTIVE ignore time 19:0 row
> > > > repl_dwmd_coce ACTIVE ignore time 19:0 row
> > > > repl_dwmd_coe ACTIVE ignore time 19:0 row
> > > > repl_dwmd_cont ACTIVE ignore time 19:0 row
> > > > repl_dwmd_coun ACTIVE ignore time 19:0 row
> > > > repl_dwmd_country ACTIVE ignore time 19:0 row
> > > > repl_dwmd_kind ACTIVE ignore time 19:0 row
> > > > repl_dwmd_partn ACTIVE ignore time 19:0 row
> > > > repl_dwmd_product ACTIVE ignore time 19:0 row
> > > > repl_dwmd_region ACTIVE ignore time 19:0 row
> > > > repl_dwmd_sae ACTIVE ignore time 19:0 row
> > > > repl_dwmd_site ACTIVE ignore time 19:0 row
> > > > repl_dwmd_staff ACTIVE ignore time 19:0 row
> > > > repl_dwmd_waregroup ACTIVE ignore time 19:0 row
> > > > repl_dwo_coe ACTIVE ignore time 19:0 row
> > > > repl_dwo_head ACTIVE ignore time 19:0 row
> > > > repl_dwo_item ACTIVE ignore time 19:0 row
> > > > repl_dwo_sae ACTIVE ignore time 19:0 row
> > > > repl_mitarb ACTIVE ignore time 19:0 row
> > > > repl_yag ACTIVE ignore time 19:0 row
> > > > repl_ykag ACTIVE ignore time 19:0 row
> > > > repl_yvowg ACTIVE ignore time 19:0 row
> > > > repl_yvuwg ACTIVE ignore time 19:0 row
> > > > cdr: can't fetch replicate
> > > > SQL code -461 :Cannot open file 'csql.iem'.
> > > >
> > > > ISAM 0 :
> > > >
> > > >
> > >
> ################################################## ##########################
> > > ####
> > > >
> > > > BUT on the online.log, I receive a lot of messages
> > > >
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422539.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422546.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422545.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422534.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422548.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422550.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422542.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422541.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422544.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422543.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422540.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422538.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422547.
> > > > 05:05:10 CDR GC: cache query failed for repl/coll identifier 6422549.
> > > >
> > > > Can someone say me why ?
> > > >
> > > > Regards,
> > > > Bj