Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1337
  • Last Modified:

SQLLIB directory was deleted

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
saulpilot439
Asked:
saulpilot439
1 Solution
 
LowfatspreadCommented:
what error messages are you receiving?

0
 
saulpilot439Author Commented:
I don't receive any error mesage, just I don't see the sqllib directory and any db2 command dont work.
0
 
gsprinceCommented:
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
 
saulpilot439Author Commented:
gsprince Thanks very much the second option works fine.

Thanks Experts.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now