Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007

    Unanswered: Change instance owner id ?


    Running db2 v9.5 on AIX6.1 box.
    I need to change db2 owner id.

    So I asume I must change id and permissions on all db2 files.
    Do I need some aditional actions ?
    Or maybe there are some utilities made for this purpose ?


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 1
    I have changed IDs for DB2 users on Linux several months ago and got no problem at all. I just did
    the following:
    # log in with db2inst1 user and execute the following commands
    db2stop force
    # if you have DB2 admin server running, then log in with dasusr1 and execute the following commands
    db2admin stop
    # log in with root user and execute the following commands
    gawk -F: '{print $3, $1}' /etc/passwd | sort -n   # Check IDs, you have to set new ID to some value that is not already assigned.
    usermod -u 999 db2inst1
    usermod -u 998 dasusr1
    usermod -u 997 db2fenc1
    That is all you have to do! (You also need to start DB2 server and DB2 admin server if required).

    You don't need to change any files permissions because there are not ID dependent, but user_name dependent. Since you haven't change user_name no need of changing file permissions.

    I haven't tested this on Unix, just assume it is the same as on Linux. I suggest you test this on test system before doing some change on production environment.
    Last edited by grofaty; 01-14-10 at 04:45.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts