Informix

nested-group-icon.png

DB2

Expand all | Collapse all

Strange message in online.log

  • 1.  Strange message in online.log

    Posted Wed May 20, 2020 06:17 AM
    Hi.
    I'm upgrading from 12 to 14 on new hardware and I have a SDS setup.
    On the secondaty, I get this in online.log when starting the server:


    05/20/20 10:07:14 DR: Warning: The table minversion DBA feature is enabled on this secondary
    (flag with value 0x400000 of the SQL_DEF_CTRL onconfig parameter).
    Please ensure that this feature is also enabled on the connected
    primary server, otherwise the secondary server may not behave as
    expected when table minversion changes occur!

    This SQL_DEF_CTRL parameter is not present in the onconfig file, and I can't find any mention of it in the docs.
    Does anyone know what's going on?

    Thanks in advance,
    -Snorri

    ------------------------------
    Snorri Bergmann
    ------------------------------


  • 2.  RE: Strange message in online.log

    Posted Wed May 20, 2020 06:31 AM

    Seems to be a cosmetic bug:

    https://www.ibm.com/support/pages/apar/IT30689

    Open a support ticket to be sure.

    Regards



    ------------------------------
    FERNANDO NUNES
    ------------------------------



  • 3.  RE: Strange message in online.log

    Posted Wed May 20, 2020 06:43 AM
    Take a look at

    https://www.cursor-distribution.de/aktuell.12.10.xC1/documentation/ids_adr_bookmap.pdf

    and searchin there  for SQL_DEF_CTRL

    Regards
    Rainer


    ------------------------------
    Rainer von Bongartz
    ------------------------------



  • 4.  RE: Strange message in online.log

    Posted Wed May 20, 2020 08:25 AM
    Hi Snorri,

    this message can safely be ignored. Its main intent is to ensure a certain mini-feature (irrelevant to most) is configured equally on primary and all its secondaries - which it will be if you don't have this (intentionally undocumented) parameter in any of the server's onconfig files.

    HTH,
     Andreas

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



  • 5.  RE: Strange message in online.log

    Posted Fri May 22, 2020 05:18 AM
    Thanks guys for your input.
    I just ignored this and everything seems to be running smoothly. :)

    Regards,
    -Snorri

    ------------------------------
    Snorri Bergmann
    ------------------------------