db2 user account deleted accidentally

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • itopete
    New Member
    • Sep 2009
    • 3
    #1

    db2 user account deleted accidentally

    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!
    Tags: aix, db2, db2inst1, deleted, sql08016, user
    • vijay2082
      New Member
      • Aug 2009
      • 112
      #2
      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

        Comment

        • itopete
          New Member
          • Sep 2009
          • 3
          #3
          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!!!;-)

            Comment

            • vijay2082
              New Member
              • Aug 2009
              • 112
              #4
              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 :)

                Comment

                • itopete
                  New Member
                  • Sep 2009
                  • 3
                  #5
                  We installed the most recent fixpack and re-catalog the database and it worked!! Content Manager is up and running!!! THANKS!!!!!!!

                    Comment

                    Previous template Next
                    Working...