Db2

 View Only
  • 1.  install db2 V12

    Posted Fri March 14, 2025 12:00 PM
    Edited by Guy Przytula Fri March 14, 2025 12:11 PM

    I downloaded db2 v12 1.1 and wanted to upgrade a community edition install v11.5.9

    it complains that it can not create the file sqllib/ctrl/.fencedID

    the file already exists and keeps the name of the fenced userid

    according a doc IBM Support  

    Ibm remove preview
    IBM Support
    View this on Ibm >

    but in this doc the speak about db2iupdt and I use db2iupgrade

    and another doc indicated the file should be fencedid owned ??

    you have to : drop/create the file = this gives same error

    removing the file : upgrade fails - file does not exist

    modify the code in db2iutil to create it conditionally

    so i commented the line where it puts the fencedid in the file - but same error

    any hint how to modify this db2iutil to avoid this problem

    there is also a check of file ownership : if I understand well it should be root owned and it was instanceowner owned = chown did not resolve problem

    still complaining about create of file



    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------



  • 2.  RE: install db2 V12

    Posted Fri March 14, 2025 12:30 PM
    This is because of new protections around files in recent Linux versions.   

    You need to turn this off temporarily while you run the upgrade and then turn it back on.

    As root -
    • sysctl -w fs.protected_regular=0
    • <installpath>/instance/db2iupgrade -u db2fenc1 db2inst1
    • sysctl -w fs.protected_regular=2





  • 3.  RE: install db2 V12

    Posted Sat March 15, 2025 04:30 AM

    many thanks - this resolved my problem



    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------



  • 4.  RE: install db2 V12

    Posted Fri March 14, 2025 12:32 PM

    AFAIK  .fencedID is owned by fenced user:



    ------------------------------
    Jan Nelken
    Persistent Systems Ltd
    Cracow
    +48 783 109 863
    ------------------------------



  • 5.  RE: install db2 V12

    Posted Fri March 14, 2025 01:37 PM
    Many thanks for the answer. I will try and feedback

    Best Regards, Groeten  Guy