Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
 View Only

  • 1.  DBI1084E error while migrating v11 to v12

    Posted Thu December 05, 2024 09:23 AM

    Hi folks!

    I try to migrate my db2 v11.5.9.0 to the newest Version 12.1. The installation run with success.

    When I try the db2iupgrade command 

    db2iupgrade -u db2fenc1 db2inst1

    the following messages come back:

    DBI1084E  An attempt to create /home/db2inst1/sqllib/ctrl/.fencedID failed.

    Explanation: 

    An error occurred when creating the given file or directory.

    User response: 

    Check that there is enough space in the file system and that you have
    write permission for the required directory. Suggested directory
    permissions are u=rwx,go=rx.


    ERROR: An error occurred while configuring the instance "db2inst1".

    What I found in the www was the following link:

    IBM Support

    Ibm remove preview
    IBM Support
    View this on Ibm >

    any ideas?

    regards 

    Joerg Burdorf



    ------------------------------
    Jörg Burdorf
    ------------------------------


  • 2.  RE: DBI1084E error while migrating v11 to v12

    Posted Thu December 05, 2024 10:13 AM

    Hi Jorg!

    1. As root, execute:
    rm  /home/db2inst1/sqllib/ctrl/.fencedID

    2. As root, execute:
    db2iupgrade -u db2fenc1 db2inst1



    ------------------------------
    Jan Nelken
    ------------------------------



  • 3.  RE: DBI1084E error while migrating v11 to v12

    Posted Thu December 05, 2024 10:36 AM

    Hi Jan!

    Thanks for the hint!

    I have tried this. The same error:

    DBI1084E  An attempt to create /home/db2inst1/sqllib/ctrl/.fencedID failed.

    Explanation: 

    An error occurred when creating the given file or directory.

    User response: 

    Check that there is enough space in the file system and that you have
    write permission for the required directory. Suggested directory
    permissions are u=rwx,go=rx.

    The directory has the following attributes:

    drwxrwsrwx  2 db2inst1 db2iadm1  4096 Dez  5 16:29 ctrl

    regards Joerg



    ------------------------------
    Jörg Burdorf
    ------------------------------

    Original Message


  • 4.  RE: DBI1084E error while migrating v11 to v12

    Posted Thu December 05, 2024 11:12 AM

    Please issue ls -l /opt/ibm/db2



    ------------------------------
    Jan Nelken
    ------------------------------

    Original Message


  • 5.  RE: DBI1084E error while migrating v11 to v12

    Posted Thu December 05, 2024 11:26 AM

    root@JBUbuntu:/opt/ibm/db2/V12.1/instance# ls -l /opt/ibm/db2
    insgesamt 8
    drwxr-xr-x 41 root root 4096 Jul  4 22:25 V11.5
    drwxr-xr-x 40 root root 4096 Dez  4 10:55 V12.1
    root@JBUbuntu:/opt/ibm/db2/V12.1/instance# 



    ------------------------------
    Jörg Burdorf
    ------------------------------

    Original Message


  • 6.  RE: DBI1084E error while migrating v11 to v12

    Posted Thu December 05, 2024 12:29 PM

    You did execute db2iupgrade from new location?

    /opt/ibm/db2/V12.1/instance/db2iupgrade -u db2fenc1 db2inst1



    ------------------------------
    Jan Nelken
    ------------------------------

    Original Message


  • 7.  RE: DBI1084E error while migrating v11 to v12

    Posted Thu December 05, 2024 02:15 PM

    Hi Jörg,

    If you are on Linux and have the "sudo sysctl fs.protected_regular" command output different from 0, then run the following command before the instance upgrade:

    sudo sysctl -w fs.protected_regular=0
    sudo .../db2iupgrade -u db2fenc1 db2inst1

    You may revert back your initial setting of this parameter afterwards like:

    sudo sysctl -w fs.protected_regular=2



    ------------------------------
    Mark Barinstein
    ------------------------------



Related Content