Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: Restoring a database w/o sysadm in DB2 v5

    Hi.

    I'm having problems to restore a database. Looks like the former db administrator didn't leave all passwords documented. Thogh I'm not the DB admin, I must restore a DB I recently backed up (from that same machine). When restoring, I get error 28000, invalid authorization id.

    Some technical details: IBM DB2 v5. I assume no FixPacks applied.
    OS: Windows NT 4. Most SP's applied.

    The performed backup was an offline backup. I'm currently logging in as a user name ADM which can do anything to the database, but apparently is not SYSADM.

    I have administrator privileges on the computer, so I think I could work around it in some way.

    I tried creating a new group with all privileges. I set sysadm_group to that group and set the ADM user to that group under NT with no luck.

    Since I don't really know DB2, I don't know what other info could be helpful to you.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You might try db2admin or db2adm as authorization id's. You will have to guess on the password.

  3. #3
    Join Date
    Oct 2003
    Posts
    2
    Thanks. I tried it with no luck.

    Since I have physical access to the computer with Administrator privileges, do you know if there is any way to bypass DB2's security?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    It is likely that one of the Wndows id's with administrator privledge is the same as used for DB2 sysadm. Unless of course, the id's and passwords were changed.

    I don't know of anyway to bypass DB2 security, but maybe someone else does. If version 5 was still supported by IBM, you could have called them, but it is no longer supported.

Posting Permissions

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