Unanswered: Restoring a database w/o sysadm in DB2 v5
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.