473,387 Members | 1,721 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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!
Sep 26 '09 #1
4 3094
vijay2082
112 100+
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
Sep 26 '09 #2
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!!!;-)
Sep 26 '09 #3
vijay2082
112 100+
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 :)
Sep 27 '09 #4
We installed the most recent fixpack and re-catalog the database and it worked!! Content Manager is up and running!!! THANKS!!!!!!!
Sep 29 '09 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Jay | last post by:
ASPNET profile/account was accidentally deleted on NT/2000 platform. Is there anyway to get it back without reinstalling the whole exchange/IIS services???? Sincerely, J
11
by: Marcelo López | last post by:
I need to create a folder in the file system owned by an special user created by my application. The idea is that only my app will have permissions to delete and create files on that folder. My...
8
by: Alphonse Giambrone | last post by:
I have a small asp.net web app running on a shared host. It uses a Jet (Access) database. I included a routine to compact the database when the application_event fires if it has not been compacted...
4
by: Justin | last post by:
Hi All, Can the ASPNET user be deleted on an end user's machine that will run .NET applications? I heard someone say it was only needed on the developers machine. Sounded odd to me but I...
13
by: forbes | last post by:
Hi, I have a user that used the Query Wizard to create a query in Access. Now she claims that her master table is missing all the data that was excluded from the query. Can you create anything...
1
by: Roshan | last post by:
Hi, I wanted a reliable way of detecting if a given NTAccount object represents a user account or group account. I was using SecurityIdentifier.IsAccountSid() method but this doesn't work as I...
3
by: soowei.tan | last post by:
I wasn't looking carefully and accidentally deleted the wrong assemblyinfo.cs! Is there a way to generate the file again, or can I just hand code the entire file?
31
by: zdenko | last post by:
I have a multi user database and users were created by user level security wizzard - as I mentioned in message before. Everything works fine for those users, but now I have another problem. I have...
1
by: =?Utf-8?B?c3NtNDI=?= | last post by:
I accidentally deleted the "deleted" folder in my Outlook (2007) and couldnt' find a way to restore it. I uninstalled and reinstalled outlook and while the deleted folder was restored, it is not...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.