Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  RSAM memory pool cleanup

    Posted Thu December 12, 2024 11:26 AM

    Hello,

    Our customer is running application which allocates quite a lot of rsam pool, this memory is freed inside the rsam pool  – so at the end it shows from onstat -g mem rsam

    Totalsize is  cca 2gb but almost all free as column freesize shows but pool itself is not decreased.

    Is it expected behavior tha ralloc is only increasing and not freed/squeezed?

     

    Version is 12.10.FC13XAQ.

     

    Obsah obrázku text, klipart Popis byl vytvořen automaticky

    Milan Rafaj

     

    Unless stated otherwise above:
    Kyndryl Česká republika, spol. s r. o.
    Sídlo: V Parku 2308/8, Chodov, 148 00 Praha 4,
    IČ: 096 28 886
    Zapsaná v obchodním rejstříku, vedeném Městským soudem v Praze (oddíl C, vložka 339277)
    Registered address: V Parku 2308/8, Chodov, 148 00 Prague 4
    Company ID: 096 28 886
    Registered in the Commercial Register maintained by the Municipal Court in Prague (Part C, Entry 339277)


  • 2.  RE: RSAM memory pool cleanup

    Posted Thu December 12, 2024 11:49 AM

    Hi Milan,

    afaik, this is expected specifically for the rsam pool (and few other persistent ones), the assumption being that this is going to be used again.

    An occasional "onmode -F", or the LMM (low memory manager), should take care of this; also, I think, the vp memory cache feature, if on, will eventually do an (internal) onmode -F.

    HTH,
     Andreas



    ------------------------------
    Andreas Legner
    Dev Engineer
    HCL Software
    ------------------------------

    Original Message


  • 3.  RE: RSAM memory pool cleanup

    Posted Thu December 12, 2024 01:34 PM
    Hello Andreas, thank you for a tip. I thought if onstat -g seg shows no free memory for a segment that is it  not possible to shrink or eliminated such a segment using onmode -F. 

    Milan Rafaj
    Kyndryl Česká Republika/Czech Republic

    Odesláno z/Sent from  Outlook / iOS



    Original Message


  • 4.  RE: RSAM memory pool cleanup

    Posted Thu December 12, 2024 01:42 PM

    That is still correct, but what onmode -F also does, in order to facilitate returning segments, is draining memory pools. ;-)



    ------------------------------
    Andreas Legner
    Dev Engineer
    HCL Software
    ------------------------------

    Original Message


Related Content