[NTLUG:Discuss] Informix help

[kbrannen@gte.net]

Greg Edwards wrote:

> This may be off topic since its Informix.
> 
> Does anyone know Informix well enough to know what configuration
> parameters would affect the threshholds that cause a "Long Transaction
> Aborted" error to be generated when using dbaccess?
> 
> 

Yes, that means that you don't have enough logical logs.  Since you're doing 
transactions, the engine has to have enough log space (below the high water 
mark) to hold all the before values, and sometimes the after values too (like 
if you're doing an update), between commits.

The only solutions are: 1. increase the number (an maybe size too) of your 
logs; 2. make the transactions smaller. :-)  If you want to add logs, run the 
script below, as the user "informix".

HTH,
Kevin

---

#!/bin/ksh
#Add Logical Logs
# usage:  add_llogs number
x=$1
((n = 1))
while ((n <= x))
do
print -n "#$n "
# this makes 1M logs
onparams -a -d llogs -s 2048
((n = n + 1))
done