Hi all,

I have a problem, we have 120 users connected to the server with HDR on, at peak times nearly everyday i have a server crash with assert failure files, i have a online.log file in a zip format and stune and mtune file as well. I will attach these files,

Can somebody please look into it and tell me what can be done, it would be of great help to me.

Thanks and Regards
Vaidyanathan

Hi,

Evidently you need but fisica memory, please could you to send onconfig file, amount of fisica memory of the server and processors.

Gustavo.

Hi Gustavo,

These are my HW configurations,

Make/Model : Compaq ML570
Processor : 4 x P III Xenon 700 MHz each with 1 MB cache
Memory : 2 GB RAM
Informix Ver : 7.31 UD4
Operating System :- Sco Open Server version 5.0.x

I will send the first part of the asert failure files which contains the onstat -c output.


Hi,

Evidently you need but fisica memory, please could you to send onconfig file, amount of fisica memory of the server and processors.

Gustavo. [/SIZE][/QUOTE]

[/SIZE][/QUOTE]

Hi,

Disculpame, I do not have inlges very clear and it costs to me to
explain everything.
Is dificil to think from outside, without knowing the application and on which language runs, asi that please takes these data like suggestions. Haria I these changes:

NOAGE=0
OPTCOMPIND=0
LOCKS=500000
PHYSDBS= 128 MB.
LOG.LOGS= 100 x 40 MB.
LRU=64
LRU_MAX..=8
LRU_MIN.. =4
STACKSIZE=32

Add another temp dbspaces.
Databse with unbuffered logging.
I see what temporary tables are created on not temporary dbspaces and use only PDQ, for one session not all sessions.
If a SPL generates many thread of a same session it refers to that
they created the SPL with PDQ and in atmosphere OLTP is very heavy.

NOTES:
Sometimes you had one long transaction of 5000000 of locks.

good luck,

Gustavo.