Informix

 View Only

  • 1.  SESSION_LIMIT_MEMORY

    Posted Wed July 17, 2024 05:33 AM
    Hi All,
     
    I have SESSION_LIMIT_MEMORY set and I'm trying to find out what sql the session was running just before the engine terminates it. On occasion, we encounter a session with high memory usage.
    I've tried alarmprogram but seems engine terminates the session prior to hitting this script.
     
    Any ideas ?
     
    Regards
    Steven


  • 2.  RE: SESSION_LIMIT_MEMORY

    IBM Champion
    Posted Wed July 17, 2024 05:50 AM
    Did not use that one, but this setting for sure will generate a specific error code.
    You could trap this error code with onmode -I <errorcode> in order to see what is going on.

    MARCUS HAARMANN



    Original Message


  • 3.  RE: SESSION_LIMIT_MEMORY

    Posted Wed July 17, 2024 06:19 AM
    Thanks, will give that a go, I don't recall if I tried this. Hopefully the session doesn't get terminated prior to the diagnostics getting written.
     



    Original Message


  • 4.  RE: SESSION_LIMIT_MEMORY

    IBM Champion
    Posted Wed July 17, 2024 06:40 AM

    Try trapping errno 25582.

    This should generate an af file capturing the session precisely in the moment of being terminated.



    ------------------------------
    Andreas Legner
    ------------------------------

    Original Message


  • 5.  RE: SESSION_LIMIT_MEMORY

    Posted Wed July 17, 2024 09:32 AM

    Hi,

    To capture the SQL query that a session was running just before it reaches the SESSION_LIMIT_MEMORY and terminates, you can consider using database monitoring tools or querying the database logs directly. These tools can provide insights into the recent queries executed by the session, helping you identify the SQL statement responsible for the high memory usage. Additionally, reviewing database performance monitoring reports or enabling detailed logging can offer further visibility into session activities leading up to the termination.



    ------------------------------
    Kelly Doyle
    ------------------------------

    Original Message