Informix

 View Only

  • 1.  RESTORE_POINT_DIR - Size

    Posted Thu June 10, 2021 04:29 AM
    Hello

    https://www.ibm.com/docs/en/informix-servers/14.10?topic=pm-configuring-recovery-restore-point-data-in-case-upgrade-fails

    I have the default configuration
    CONVERSION_GUARD 2
    RESTORE_POINT_DIR $INFORMIXDIR/tmp

    Now how I can evaluate the space needed to store the restore point data ?
    The database size is about 800 GB and I have 35 GB available for $INFORMIXDIR/tmp


    Thanks

    ------------------------------
    Samuel
    ------------------------------

    #Informix


  • 2.  RE: RESTORE_POINT_DIR - Size

    Posted Fri June 11, 2021 05:28 AM
    Hi Sh,
    we raised this question to HCL support last year, this is the formula they came with:
    size of all reserved pages
    +     size of all used partition pages in all dbspaces
    +     the size of all system catalog tables in each database
    + in size of all logical logs which are not backed up at the time of the conversion

    HTH

    ------------------------------
    -tz-
    https://www.linkedin.com/in/tomzahr/
    ------------------------------

    Original Message