Solved

SQLLIB directory was deleted

Posted on 2011-02-10
6
1,235 Views
Last Modified: 2012-05-11
Hi Experts.

Wahat happend if the sqllib directory was deleted by error?
How can I fix this problem.
AIX Administrators don't have any backup of the instance owner.
In this case the instance is corrupted?

thanks.
0
Comment
Question by:saulpilot439
6 Comments
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 34869934
what error messages are you receiving?

0
 

Author Comment

by:saulpilot439
ID: 34871623
I don't receive any error mesage, just I don't see the sqllib directory and any db2 command dont work.
0
 
LVL 2

Accepted Solution

by:
gsprince earned 250 total points
ID: 34881523
As root,

Try "db2iupdt <instance>" from the installation directiory (usually /opt/IBM/db2/Vxx/instance

If the above doesn't work (mostly it wouldn't ), try the following

# cd <DB2DIR>/instance
1, Drop the instance
./db2idrop <instance> -f

2,Create the instance
./db2icrt <instance>

3) Update the DBM CFG with required parameters (such as SVCENAME)

4) re-catalog the database using the db path
Catalog database <dbname> on <path>

As long as the database is not dropped or removed, you can get back your instance easliy. You will have to update the DBM CFGs for any non-default settings and re-catalog the database entries though
0
 

Author Comment

by:saulpilot439
ID: 34888473
gsprince Thanks very much the second option works fine.

Thanks Experts.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 35174509
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now