Hello:

I need some help, I am having this message on the online.log file

WARNING! Logical log layout may cause Dynamic Server to get into
a locked state. Recommended smallest logical log size
is 2 times maximum concurrent user threads.

What is wrong? do i need to change the configuration?

Thanks

You need to add extra logical logs, you probably have not enough logical log space available. You can add logical logs by doing:
onparams -a -d <dbspace> -s <size_in_kb>
If your version is 9.21 or lower you will have to do this in quiescent mode and create a level-0 backup before the logs are available. In 9.30 and beyond this command can be given online.

Hope this helps,

Rob Prop

Thanks Rob

I have 7.31 , I do not have a dbspace for logical logs , Do I need to added to the rootdbspace?
GB

I always recommend putting the logical logs in a seperate dbspace. I don't know how big your system is, but let's say you need 20MB of logical log space (5 logs of approximately 4 MB). I don't know how familiar you are with IDS but here an example:

Step 0: Check LOGSMAX onconfig parameter, it ust be 5 higher as the numbver of logical logs now available (onstat -l). If this is not the case, raise this parameter and restart engine.

Step 1. Create the file/device
In windows create an empty file
In unix/linux touch an empty file or define a raw device, make it owner and group informix and permissions 660.

Step 2: Create the dbspace throught the dos box in the Informix start group / telnet
onspaces -c -d llogdbs -p <path+filename step1> -o 0 -s 20053

Step 3: Go to quiescent mode
onmode -u

Step 4: Create more logical logs
5x onparams -a -d llogdbs -s 4000

Step 5: Go back to online mode
onmode -m

Step 6: Make level 0 archive
ontaps -s -L 0 or onbar -b <-w>
depending on the used backup tool

Hope this helps,

Rob Prop

Thanks Rob for your help