I developed a bit of a problem with DB2 UDB v7.1 (out of support I know) on W2K the past few days. All has been running great until Monday morning. All of our applications that access any databases and tables hang. Sometimes they will get a bit farther than other times, but not very far. This happens even when there is only one instance of a program running. We have no problems accessing the databases with ODBC. And we can run SQL queries from the DB2 Client. I've run db2dart and the report file is clean. Our apps are developed with VisualAge Generator and compiled with C++. They access DB2 natively. Here's what I've tried so far. Restored the Windows directory (I had applied some MS patches over the weekend and thought that
might have caused the problem). Did an offline backup of the database and restored it.
You are going to have to determine where in the applications it is hanging. It may not even be when it is trying to access the DB. Only if you can 100% confirm that it is the DB that is causing the problem, should you consider looking at the DB server. It could be any number of things beside the DB server. Like the network, the application, etc. FIgure out what the application is trying to do when it hangs before you proceed.