重启后，IBM DB2无法从PHP访问数据库

Question

System: Windows 8

I have been working on a project for school using IBM DB2 Express-C, Xampp, and PHP to access the database.

Everything has been working perfectly. Then one day I rebooted my computer.

IBM Database Manager returned the following error at startup:

SQL5005C The operation failed because the database manager failed to access either the database manager configuration file or the database configuration file.

I have tried running db2stop and db2start.

I am still able to access my database via the db2 command line terminal as if nothing is wrong.

However, when I try to access my database from PHP I now get the following error from my PHP file:

58031 [IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 SQLCODE=-1031

Answer 1

You might want to double check the db2diag.log to find the reason for SQL5005C. In the better case there was a temporary problem accessing the configuration files. However, in the worse case one of the DBM or DB configuration files may have become corrupt. In the case of a corrupt DBM CFG, I usually use db2idrop/db2icrt. A corrupt DB CFG can be "fixed" (as in "reset", you will lose all custom changes) by RESET DB CFG.

The subsequent SQL1031N tells me the database you are trying to access has been uncataloged. This is also odd, especially since you are telling me you are able to access the database from the DB2 command line. You might want to do LIST DB DIRECTORY from your command line to show your database entries, and also LIST NODE DIRECTORY to see which nodes the databases reside on.