Solved

SQLLIB directory was deleted

Posted on 2011-02-10
6
1,273 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 143

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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

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…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

717 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