long transaction aborted

Hi, It because your logical logs reaches the higher water mark level as specified in the onconfig file LTXHWM 50 Parameter defined your long transaction. So if it sets to 50 , then when the usage of logical log reaches or exceeds 50% for a single transaction, Then it rollbacks the transaction with the following error. so during that time you can use dbload utility( to load the data) which gives the option to commit the transaction when n# rows are loaded. Hope this helps you.. Thanks Vasanth Informix DBA Juan Ignacio Carbajal Rivera To: informix-list@iiug.org <jcarbajal@mail.te cc: lcel.com> Subject: long transaction aborted Sent by: owner-informix-lis t@iiug.org 05/07/2003 05:13 AM Hello All: When trying to load 224888 rows from a plain text file I get this: 458: Long transaction aborted. 847: Error in load file line 18293I try once and I get this: 458: Long transaction aborted. 847: Error in load file line 20293 and so on:ANY IDEA? regards *********************************** ******************************************** This electronic mail message is intended solely for the named recipients and may contain confidential and proprietary business information of eFunds Corporation and all its subsidiaries. If you are not a named recipient, please notify the sender immediately. You may not disclose the contents to any other person; use this electronic mail message or its contents for any other purpose; or further store or copy its contents in any medium. ********************************************