Re: Error in Enterprise Replication
On 3 May, 07: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- Hide quoted text -
>
> - Show quoted text -
Do you know what LTXHWM and LTXEHWM do? 120 is not a valid value.
You should never set LTXHWM above 30 and LTXEHWM above 40.
YOu need to add more log space say 100 logs of 50Mb each for 5GB more
log space.