Connecting Tech Pros Worldwide Forums | Help | Site Map

db2 user account deleted accidentally

Newbie
 
Join Date: Sep 2009
Posts: 3
#1: Sep 26 '09
Today we planned to delete some user accounts from an offline server but by mistake I log into the production server and deleted the accounts there, one of those accounts was the db2inst1 account(the /usr/content/db2home/db2inst1 directory was not deleted) so as soon as I notice the mistake I created the user account(AIX) and assigned the /usr/content/db2home/db2inst1 directory as home.
But when I try to execute db2start just keeps telling me this:
# db2start
09-25-2009 18:48:47 0 0 SQL1042C An unexpected system error occurred.
SQL1032N No start database manager command was issued. SQLSTATE=57019
# db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08016"
with level identifier "02070106".
Informational tokens are "DB2 v8.1.1.58", "s040914", "U800265", and FixPak "6".
Product is installed at "/usr/opt/db2_08_01".

I’m terrified because the Tivoli server has been down for 3 months, so we don’t have any recent backups:-S

Any help will be deeply appreciated
Thank’s!

vijay2082's Avatar
Newbie
 
Join Date: Aug 2009
Location: UK
Posts: 22
#2: Sep 26 '09

re: db2 user account deleted accidentally


Hi,

Don't know why you are still at FixPak "6" for V8? Did you try runing db2iupdt on the instance after creating the userid.How about group ownership ? Better go and apply a recent fixpack and it will take care of missing link or privs.

But for the immediate remedy you can create another instance and catalog the database. Better go for a new user and specify all the exact privs and group ownership.

Raise a PMR with IBM if you don't have much control over the stuffs !

Cheers, Vijay
Newbie
 
Join Date: Sep 2009
Posts: 3
#3: Sep 26 '09

re: db2 user account deleted accidentally


I'm not the admin of that server, and I dont really know why is that server so outdated, but I'll try to do the update as you recommend, thanks!! I'll keep you informed!!

Any other ideas will be appreciated!!!;-)
vijay2082's Avatar
Newbie
 
Join Date: Aug 2009
Location: UK
Posts: 22
#4: Sep 27 '09

re: db2 user account deleted accidentally


What about messages in db2diag.log file. Can you share the last couple of messages recorded int the file. db2iupdt will certainly help to build the file permissions etc if its broken while you dropped the user.

Also make sure that you have a complete server backup to make sure that database is intact. Atleast you database is safe :)
Newbie
 
Join Date: Sep 2009
Posts: 3
#5: Sep 30 '09

re: db2 user account deleted accidentally


We installed the most recent fixpack and re-catalog the database and it worked!! Content Manager is up and running!!! THANKS!!!!!!!
Reply

Tags
aix, db2, db2inst1, deleted, user