Enterprise Replication CDR GC c… – Informix Archive

Pravin Kedia — Mon, 3 May 2004 10:02:54 -0500 — source: Usenet: comp.databases.informix

--0__=08BBE41ADFC13DEE8f9e8a93df938690918c08BBE41ADFC13DEE Content-type: multipart/alternative; Boundary="1__=08BBE41ADFC13DEE8f9e8a93df938690918c08BBE41ADFC13DEE" --1__=08BBE41ADFC13DEE8f9e8a93df938690918c08BBE41ADFC13DEE Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Hi Bruxelles, Does the msg/en_us/0333/csql.iem file exists in your INFORMIXDIR. Also on retrying this 'cdr list repl' command do you still get error on= ce that file is present. Thanks, Pravin. = Bruxelles.Jette@c = aramail.com (Bj) = Sent by: = To owner-informix-li informix-list@iiug.org = st@iiug.org = cc = Subj= ect 05/03/2004 05:41 Enterprise Replication CDR GC ca= che AM query failed = = = Please respond to = Bruxelles.Jette = = = Hello, I'm trying to activate the enterprise replication between 2 servers. When I type on each of the servers #######################################################################= ######### $ cdr list replREPLICATE 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 = --1__=08BBE41ADFC13DEE8f9e8a93df938690918c08BBE41ADFC13DEE Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> Hi Bruxelles, Does the msg/en_us/0333/csql.iem file exists in your INFORMIXDIR. Also on retrying this 'cdr list repl' command do you still get error on= ce that file is present. Thanks, Pravin. <img src=3D"cid:10__=3D08BBE41ADFC13DEE8f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for Bruxelles.Jette@car= amail.com (Bj)">Bruxelles.Jette@caramail.com (Bj) <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE41= ADFC13DEE8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul>Bruxelles.Jette@caramail.com (Bj)<fo= nt size=3D"2"> Sent by: owner-informix-list@iiug.org 05/03/2004 05:41 AM <table border=3D"1"> <tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"= center">Please respond to Bruxelles.Jette</div></td></tr> </table> </ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE41ADFC13DEE8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D"">

↪ replying to Pravin Kedia

Bj — 4 May 2004 01:22:05 -0700 — source: Usenet: comp.databases.informix

HELLO, I'm working with two servers installed with SCO OpenServer 5.0.7 I never could find the file csql.iem. Even an INFormix Specialist was unable to say me where I can find it. The Error messages are coming each time that the Server is rebooted. Regards, Bj Pravin Kedia <kedia@us.ibm.com> wrote in message news:<c75p35$q6s$1@terabinaries.xmission.com>... > --0__=08BBE41ADFC13DEE8f9e8a93df938690918c08BBE41ADFC13DEE > Content-type: multipart/alternative; > Boundary="1__=08BBE41ADFC13DEE8f9e8a93df938690918c08BBE41ADFC13DEE" > > --1__=08BBE41ADFC13DEE8f9e8a93df938690918c08BBE41ADFC13DEE > Content-type: text/plain; charset=US-ASCII > Content-transfer-encoding: quoted-printable > > > Hi Bruxelles, > > Does the msg/en_us/0333/csql.iem file exists in your INFORMIXDIR. > Also on retrying this 'cdr list repl' command do you still get error on= > ce > that file is present. > > Thanks, > Pravin. > > > > = > > Bruxelles.Jette@c = > > aramail.com (Bj) = > > Sent by: = > To > owner-informix-li informix-list@iiug.org = > > st@iiug.org = > cc > = > > Subj= > ect > 05/03/2004 05:41 Enterprise Replication CDR GC ca= > che > AM query failed = > > = > > = > > Please respond to = > > Bruxelles.Jette = > > = > > = > > > > > > 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 > > = > > --1__=08BBE41ADFC13DEE8f9e8a93df938690918c08BBE41ADFC13DEE > Content-type: text/html; charset=US-ASCII > Content-Disposition: inline > Content-transfer-encoding: quoted-printable > > <html><body> > Hi Bruxelles, > > Does the msg/en_us/0333/csql.iem file exists in your INFORMIXDIR. > Also on retrying this 'cdr list repl' command do you still get error on= > ce that file is present. > > Thanks, > Pravin. > > <img src=3D"cid:10__=3D08BBE41ADFC13DEE8f9e8a93df938@us.ibm.com" width=3D= > "16" height=3D"16" alt=3D"Inactive hide details for Bruxelles.Jette@car= > amail.com (Bj)">Bruxelles.Jette@caramail.com (Bj) > > > > <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= > > <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE41= > ADFC13DEE8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= > th=3D"40%"> > <ul> > <ul> > <ul> > <ul>Bruxelles.Jette@caramail.com (Bj)<fo= > nt size=3D"2"> > Sent by: owner-informix-list@iiug.org > 05/03/2004 05:41 AM</fon

↪ replying to Bj

Jack — 4 May 2004 07:16:05 -0700 — source: Usenet: comp.databases.informix

Bruxelles.Jette@caramail.com (Bj) wrote in message news:<89d8947b.0405040022.7adc3248@posting.google.com>... > HELLO, > > I'm working with two servers installed with SCO OpenServer 5.0.7 > I never could find the file csql.iem. Even an INFormix Specialist was > unable to say me where I can find it. you should install client sdk with ids. csdk 2.81 should be available for SCO Openserver. regards, > > The Error messages are coming each time that the Server is rebooted. > > Regards, > Bj > > Pravin Kedia <kedia@us.ibm.com> wrote in message news:<c75p35$q6s$1@terabinaries.xmission.com>... > > --0__=08BBE41ADFC13DEE8f9e8a93df938690918c08BBE41ADFC13DEE > > Content-type: multipart/alternative; > > Boundary="1__=08BBE41ADFC13DEE8f9e8a93df938690918c08BBE41ADFC13DEE" > > > > --1__=08BBE41ADFC13DEE8f9e8a93df938690918c08BBE41ADFC13DEE > > Content-type: text/plain; charset=US-ASCII > > Content-transfer-encoding: quoted-printable > > > > > > Hi Bruxelles, > > > > Does the msg/en_us/0333/csql.iem file exists in your INFORMIXDIR. > > Also on retrying this 'cdr list repl' command do you still get error on= > > ce > > that file is present. > > > > Thanks, > > Pravin. > > > > > > > > = > > > > Bruxelles.Jette@c = > > > > aramail.com (Bj) = > > > > Sent by: = > > To > > owner-informix-li informix-list@iiug.org = > > > > st@iiug.org = > > cc > > = > > > > Subj= > > ect > > 05/03/2004 05:41 Enterprise Replication CDR GC ca= > > che > > AM query failed = > > > > = > > > > = > > > > Please respond to = > > > > Bruxelles.Jette = > > > > = > > > > = > > > > > > > > > > > > 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 > > > > = > > > > --1__=08BBE41ADFC13DEE8f9e8a93df938690918c08BBE41ADFC13DEE > > Content-type: text/html; charset=US-ASCII > > Content-Disposition: inline > > Content-transfer-encoding: quoted-printable > > > > <html><body> > > Hi Bruxelles, > > > > Does the msg/en_us/0333/csql.iem file exists in your INFORMIXDIR. > > Also on retrying this 'cdr list repl' command do you still get error on= > > ce that file is present. > > > > Thanks, > > Pravin. > > > > <img src=3D"cid:10__=3D08BBE41ADFC13DEE8f9e8a93df938@us.ibm.com" width=3D= > > "16" height=3D"16" alt=3D"Inactive hide details for Bruxelles.Jette@car= > > amail.com (Bj)">Bruxelles.Jette@caramail.com (Bj) > > > > > > > > <table width=3D"100%" border=3D"0" cellspacing=3D@@

Re: Enterprise Replication CDR GC cache query failed

Glossary

Your privacy choices