重新启动DB2服务后，应用程序服务器在数据库连接中得到ERRORCODE = -4499，SQLSTATE = 58009 [英] After restarting DB2 service, the application server gets ERRORCODE=-4499, SQLSTATE=58009 in database connections

问题描述

我们在IBM WebSphere Application Server 7.x上有一个应用程序，它连接到z/os DB2 10.x上的远程数据库.对于年度操作，DB2关闭并重新启动.启动数据库后，我们首先得到

We have an application on IBM WebSphere Application Server 7.x and it connects to a remote database on z/os DB2 10.x. For annual operation, DB2 shut down and restarted. After starting the database, we first get

com.ibm.websphere.ce.cm.StaleConnectionException

然后我们得到

The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated this particular request due to unexpected error conditions detected at the target system. ERRORCODE=-4499, SQLSTATE=58009

通过WAS数据源中的测试连接"测试的WebSphere和DB2之间的连接.两个系统都已启动并正在运行，但是它们之间没有正确的连接！ DB2，WAS和JDBC驱动程序没有变化.

The connection between WebSphere and DB2 tested by 'test Connection' in WAS datasource. Both systems are up and running but there is no correct connection between them! There was no change in DB2, WAS, and JDBC driver.

更新 :JDBC驱动程序版本为 4.15.134 ，连接属性为IBM WebSphere缺省设置，并且连接直接与DB2.后来的另一个问题表明，尽管连接仍然有问题，但是直接在z/OS的DB2上执行查询会得到相同的错误.该查询包含一个在两个不同表上具有联接的选择，每个表上的选择都可以，但是最终查询不起作用，并得到ERRORCODE = -4499，SQLSTATE = 58009.

Update: The JDBC driver version is 4.15.134, connection properties is IBM WebSphere default setting and the connection is direct to DB2. Another problem later showed that while the connection still has the problem, executing the query directly on z/OS's DB2 gets the same the error. The query consist of a select with a join on two different tables, selecting on each table is ok, but the final query does not work and gets ERRORCODE=-4499, SQLSTATE=58009.

更新2 环境的详细信息是:IBM WebSphere Application Server 7.0.0.45，DB2 10.1，Java版本SR16和z/OS 1.13.

Update 2 The detail of environment is: IBM WebSphere Application Server 7.0.0.45, DB2 10.1, Java version 1.6 SR16 and z/OS 1.13.

此特定查询在所有应用程序服务器，z/os SPUFI，数据库查看器(例如DBeaver)上的 all 环境中获取错误.

This specific query gets the error in all environments, on all application server, z/os SPUFI, database viewer, such as DBeaver.

任何帮助将不胜感激.

Any help is greatly appreciated.

推荐答案

最后，我们找到了解决方案，在两个表及其所有分区上都运行了REORG和RUNSTATS，并且该错误在应用程序和SPUFI上均消失了.我猜在重新启动过程中出了点问题，表已损坏.现在一切正常.

Finally, we found the solution, ran REORG and RUNSTATS on both tables and on all their partitions, and the error vanished both on the application and SPUFI. I guess something went wrong during restart and tables corrupted. Now everything is ok.

这篇关于重新启动DB2服务后，应用程序服务器在数据库连接中得到ERRORCODE = -4499，SQLSTATE = 58009的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！