The database server ran out of log space in which to record this transaction. A transaction that is not fully recorded cannot be rolled back. To preserve database integrity, the operating system ended the transaction and rolled it back automatically. All changes made since the start of the transaction have been removed. Terminate the application, and replan it so that it modifies fewer rows per transaction. Alternatively, contact the database server administrator to discuss increasing the number or the size of the logical logs. Be prepared to talk about the number of rows being updated or inserted and the size of each row.
Thanks, -Jim
You will need to increase physical log
- or reduce one-time update,
add some logical logs (to hold three times physical size)
- check if this error is present database log too
you need to edit $INFORMIXDIR/etc/??config
or run $INFORMIXDIR/bin/??params
or onmonitor
you will need to reboot informix in either way, first is least possible to work at all
onmonitor is the frontend interface to the Online engine. Many of the informix commands used to access the engine such as oninit, onstat, etc are available thru onmonitor.
I am new to Tek-tips . recently joined. I posted a new thread on the same question and then noticed this.Its quite informative . I have just started woking on Informix Dynamic Server . Will come back with more questions as and whenever i get stuck .
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.