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.  Reserved page size in rootdbs

    Posted 04/10/24 04:17 AM

    Hi

    I'm looking for some information about the Reserved pages size calculation method.

    Our customers upraded/upgrading to 14.10FC9 or 14.10FX9W1 and we want to eliminate the risk of data loss. 

    IT45318: POTENTIAL FOR DATA LOSS OR INDEX PROBLEMS IN TABLES LOCATED IN ROOT DBSPACE WHEN EXTENDED RESERVED PAGES ARE IN USE

    One customers system is currently not meet with the EXTENDED RESERVED PAGES size > 32 criteria, so we think they will safe with upgrading to FC9W1.  (only system databases located in the rootdbs) But our question is when will create the engine bigger then 32 page size RESERVED PAGES in the future?  I didn't found any resource about this.

    The customer with 14.10FC9 has a potential risk because we found some RESERVED PAGES witch bigger then 32 pages and the next pages containing some system database data. We will suggest them to upgrade to 14.10.FC10W2, and until they will upgrade to it we will configure the bufferpools maxdirty parameter to very low value. 5 or less.

    Any good practice or advice to lowering the risk the data lost?



    ------------------------------
    Gábor Fekete
    Software Engineer
    Capital Systems
    Budapest
    ------------------------------



  • 2.  RE: Reserved page size in rootdbs

    Posted 04/10/24 01:41 PM
    Edited by Andreas Legner 05/07/24 06:20 AM

    Hi Gábor,

    what exactly do you mean by "EXTENDED RESERVED PAGES size > 32 criteria" - it seems your reasoning hinges on this, but I don't see it mentioned in the APAR IT45318.

    BR,

     Andreas



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



  • 3.  RE: Reserved page size in rootdbs

    Posted 04/10/24 01:51 PM

    Hi Andreas!

    There was an  IBM notification about this potential data loss almost a month ago and there was a mention about a extented reserved page size criteria. 

    "How to identify the tables or indexes that are at risk

    Examine the output of "oncheck -pe rootdbs" to identify extended reserved page extents that are larger than 32 pages"

    Notification and additional details pertaining to APAR IT45318

    Ibm remove preview
    Notification and additional details pertaining to APAR IT45318
    The purpose of this document is to provide more information about the problem described by APAR IT45318.
    View this on Ibm >



    ------------------------------
    Gábor Fekete
    Software Engineer
    Capital Systems
    Budapest
    ------------------------------

    Original Message


  • 4.  RE: Reserved page size in rootdbs

    Posted 05/07/24 06:37 AM

    Understanding this criterion now, and I'm afraid the list of counter measures and precautions in that extra article is very exhaustive already and I'd not have any idea beyond that.

    Since you mentioned "pages containing some system database data" next to such larger extended reserved pages extent, which system table is it that's got its data there?



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

    Original Message


  • 5.  RE: Reserved page size in rootdbs

    Posted 05/04/24 11:54 AM

    HI,

    Extended reserved pages can be added when you add 

    • chunks
    • dbspaces
    • logical logs

    Regards,
    David.



    ------------------------------
    David Williams
    ------------------------------



Related Content