Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2013

    Unanswered: Instance privileges issue

    Hello, We have a non-root installed 9.7.6 on Red hat 6.4. The second instance is root installed on the same box but at 9.7.8.
    Redirected restore of db backup from non-root to root install was successful.
    The database has some tablespaces set to automatic storage.

    The restored database connects fine. I can do binds using the instance id.
    With the instance ID, get dbsize fails:

    SQL0443N state=38553.

    When I attempt to grant select on catalog tables using instance id, it throws SQL0551N saying id does not have authorization or privilege to perform GRANT on the object.
    Any ideas ?

  2. #2
    Join Date
    Sep 2013
    you need to transfer ownership of tables from old instance to new instance user using transfer ownership command.

  3. #3
    Join Date
    Apr 2006
    Provided Answers: 11
    "you need to transfer ownership..."
    not because this resolved another problem, that this will resolve all your problems.
    this problem has todo with authorities..
    check in doc how to assign sysadm and getting authorities for user...
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  4. #4
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    After the restore object ownership does not change and remains as it was in the original database. Check out the registry variable DB2_RESTORE_GRANT_ADMIN_AUTHORITIES.
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Nov 2013
    Thanks Everyone. I'll try that and respond back.

  6. #6
    Join Date
    Nov 2013
    After setting registry variable DB2_RESTORE_GRANT_ADMIN_AUTHORITIES, the instance can call the get size procedure and grant privileges.
    Thanks to all for the quick response.

Posting Permissions

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