Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Location
    Dubai
    Posts
    5

    Unanswered: Informix engine in live server crashed version 7.31.UD4

    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
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Informix engine in live server crashed version 7.31.UD4

    Originally posted by vaikri
    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.

  3. #3
    Join Date
    Oct 2003
    Location
    Dubai
    Posts
    5

    Re: Informix engine in live server crashed version 7.31.UD4

    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]
    Attached Files Attached Files

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Informix engine in live server crashed version 7.31.UD4

    Originally posted by vaikri
    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]

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •