Re: Error in Enterprise Replication

Dear All, I am already using following setting. Should I increase LTXHWM and LTXEHWM to some higher value like 100 or 120 ? Actually at source side of Replication environment, We are using a vendor application which is not using dbload or other utility and I cannot force my vendor to use that. Is there any other around like increasing the size of logs and if YES, which parameter will be changed ? DYNAMIC_LOGS 2 LTXHWM 70 LTXEHWM 80I really appreciate your efforts. Regards, Navaid Arif ----- Original Message ----- From: Navaid Arif To: admin-tools@iiug.org ; informix-list@iiug.org ; peoplemix@iiug.org ; classics@iiug.org ; ids@iiug.org Sent: Wednesday, May 02, 2007 11:36 AM Subject: Error in Enterprise Replication Hi All, I am using IDS 10 UC5 and during testing of Enterprise Replication facing following problem: Anyone have any idea about it? SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit Modify the current SQL statements using the SQL editor. ----------------------- dbname@srvtest -------- Press CTRL-W for Help -------- load from loghisttbl.dmp insert into loghisttbl 458: Long transaction aborted. 12204: RSAM error: Long transaction detected. 847: Error in load file line 5825. Regards, Navaid Arif

NOPE. have a look at onparams -a ( -d......) Superboer. On 3 mei, 08:49, "Navaid Arif" <navaid.a...@access.net.pk> wrote: > Dear All, > I am already using following setting. Should I increase LTXHWM and LTXEHWM to some higher value like 100 or 120 ? > Actually at source side of Replication environment, We are using a vendor application which is not using dbload or other utility and I cannot force my vendor to use that. Is there any other around like increasing the size of logs and if YES, which parameter will be changed ? > DYNAMIC_LOGS 2 > LTXHWM 70 > LTXEHWM 80> I really appreciate your efforts. > > Regards, > Navaid Arif > > ----- Original Message ----- > From: Navaid Arif > To: admin-to...@iiug.org ; informix-l...@iiug.org ; people...@iiug.org ; class...@iiug.org ; i...@iiug.org > Sent: Wednesday, May 02, 2007 11:36 AM > Subject: Error in Enterprise Replication > > Hi All, > I am using IDS 10 UC5 and during testing of Enterprise Replication facing following problem: Anyone have any idea about it? > > SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit > Modify the current SQL statements using the SQL editor. > > ----------------------- dbname@srvtest -------- Press CTRL-W for Help -------- > > load from loghisttbl.dmp insert into loghisttbl> > 458: Long transaction aborted. 12204: RSAM error: Long transaction detected. > 847: Error in load file line 5825.> > Regards, > Navaid Arif