07-17-06, 14:16 #1Registered User
- Join Date
- Jul 2006
Unanswered: Need help correcting the following error!
Hello everyone ...
While I was away from the office for the past 8 weeks, our network engineer had uninstalled some software from the server where our DB/2 exists. When attemopting to use some of the DB/2 tools such as the journal, we get the following error:
DBA1177N A database connection to the Tools Catalog Database "TOOLSDB" cannot be made. SQLCODE"42724" ICM00001N An Sql error occurred while connecting to the database. Database="TOOLS1", Catalog="CC". [IBM][CLI Driver][DB2/NT] SQL0444. Routine "SYSIBM SQLTABLES"(specific name "TABLES") is implemented with code in library or path "\db2schema", function "sqltables" which cannnot be accessed. Reason code:"4". SQLSTATE=42724
Unfortunately, he also did not save any back ups of the registry with path for my return and my back up was unable to restore/correct the path while I was off.
Thanks in Advance,
07-18-06, 01:51 #2Registered User
- Join Date
- Jun 2006
seems like some external sp are missing. is sqllib/function still present and accessible ? try to reinstall them
db2updv8 -d xxx and bind db2schema.bnd againBest Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8