RE: Error 458: Long transaction aborted.

Posted in 1999

MENESES HERNANDEZ, MARIO ALFREDO — Wed, 23 Jun 1999 06:50:33 -0500 — source: Informix-list mailing list archive (1991-1998)

> Tan Chin Yeow wrote: > > > Hi, > > > > Recently, I've encounter this error 458 when trying to > > - delete all records in a particular table > > - load data from a text file into the same table > > > > Can anybody out there help me?? > > > > Thanks in advance! > > TCY > First of all you must increase the number of logical logs segments and review the size of it. In the other hand check if it is possible descomposite this transaction in two or more transactions instead of only one. Also you must review the range of rows between commit or rollback commands. Saludos... Mario Meneses Database Administrator gedas north america Tel : +52 (22) 23-4408 Fax : +52 (22) 23-4199 Pager : +52 (22) 49-07-33 Code : 34075 mailto:menesem@gedas.com.mx