天道酬勤,学无止境

After restarting DB2 service, the application server gets ERRORCODE=-4499, SQLSTATE=58009 in database connections

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

and then we get

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

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.

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.

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.

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.

评论

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.

If I got you correctly, you complain on inability of the driver to reestablish the database connections after the DB2 for Z/OS restart. If yes, then have you tried to set the corresponding connection properties described at the following link?

Configuration of Sysplex workload balancing and automatic client reroute for Java clients

受限制的 HTML

  • 允许的HTML标签:<a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • 自动断行和分段。
  • 网页和电子邮件地址自动转换为链接。

相关推荐
  • DB2 jdbc connection error Connection refused. ERRORCODE=-4499, SQLSTATE=08001
    I have a new DB2 server (v10.5.0.3), and I can connect to the database locally just fine. When trying to connect from a remote server using JDBC I am getting the "Connection refused. ERRORCODE=-4499, SQLSTATE=08001" error. Based on information found here https://www-304.ibm.com/support/docview.wss?uid=swg21403644 I have confirmed that [db2inst1@db2 ~]$ db2set -all [i] DB2COMM=TCPIP [i] DB2AUTOSTART=YES [g] DB2SYSTEM=db2.xxxx.com [g] DB2INSTDEF=db2inst1 [g] DB2ADMINSERVER=xxxxxx and [db2inst1@db2 ~]$ db2 get database manager configuration | grep -i svce TCP/IP Service name (SVCENAME) = 50001
  • 我收到“操作超时。 ERRORCODE=-4499,SQLSTATE=08001”连接到远程 DB2(I am getting “ Operation timed out. ERRORCODE=-4499, SQLSTATE=08001” connecting to remote DB2)
    问题 我正在尝试使用 IBM Type 4 JDBC 驱动程序连接到远程 DB2。 这是我的配置: 服务器: Windows 7 专业版 DB2 LUW V10.5 DB2 SVCENAME=50000 TCP/IP 通讯 客户: OS/x V10.10.3 日食火星 IBM DB2 Java Type 4 驱动程序 我的理解是,如果您用 Java 编写客户端应用程序并使用类型 4(纯 Java)驱动程序,则客户端不必安装客户端。 该应用程序将使用 DRDA 直接连接到远程数据库。 这是我尝试访问远程 db2 的一段代码: public class BlobRetrieval { static String databaseDriver; static String dbURL; static String userName; static String password; static Connection passConn; public static void main(String[] args) { databaseDriver = "com.ibm.db2.jcc.DB2Driver"; dbURL = "jdbc:db2://192.168.1.81:50000/LOBDB"; userName = "ace"; password = "ace"; try {
  • I am getting “ Operation timed out. ERRORCODE=-4499, SQLSTATE=08001” connecting to remote DB2
    I am attempting to connect to a remote DB2 using IBM Type 4 JDBC driver. Here is my configuration: Server: Windows 7 professional DB2 LUW V10.5 DB2 SVCENAME=50000 TCP/IP to communicate Client: OS/x V10.10.3 Eclipse Mars IBM DB2 Java Type 4 drivers It is my understanding that if you write the client app in Java and use the type 4—pure Java—drivers, the client doesn't have to have a client installed. The app will use DRDA to connect directly to the remote database. Here is a snippet of code that I tried to access the remote db2: public class BlobRetrieval { static String databaseDriver; static
  • iReport与DB2的连接错误代码= -4499,SQLSTATE = 08001(iReport to DB2 connection ERRORCODE=-4499, SQLSTATE=08001)
    问题 我正在使用Jasper iReport。 当我尝试连接到IBM DB2时出现错误:“权限被拒绝:ERRORCODE = -4499,SQLSTATE = 08001” 我使用的驱动程序与Razor使用的驱动程序相同,因此可以正常运行(相同的设置,用户名,密码等)。 最近开始出现此问题。 有什么建议么? 谢谢 回答1 请确保之间的所有防火墙和/或代理服务器都已配置为允许您的请求通过。 我们有一个类似的错误,结果是在我们的appserver和db2之间的防火墙没有打开所需的端口。
  • iReport to DB2 connection ERRORCODE=-4499, SQLSTATE=08001
    I am using Jasper iReport. When I try to connect to IBM DB2 I get an error: "Permission denied: ERRORCODE=-4499, SQLSTATE=08001" I am using the same driver to connect as Razor which I also use and there it works ok (same settings, username, password, etc). This problem started to occur lately. Any suggestions? Thank you
  • User and Password when Connecting to DB2 via JDBC
    I am trying to connect to a local DB2 10.5 Express-C server. This is a testing environment so I don't care about security. I am able to connect to the Command Line Processor (running on Windows), and I changed the configuration settings for AUTHENTICATION=CLIENT and TRUST_ALLCLNTS=YES. I expected to be able to connect without authentication at that point (I restarted the DB2 service), but I still get an error. When I try to connect without username/password jdbc:db2://localhost:50000/test I get the error: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][10205][11234][4.14.146] Null userid
  • Kubernetes--k8s---滚动更新--零停机不停服发布服务
    滚动更新的定义和目标 滚动更新的含义 一次只更新一小部分副本,成功后,再更新更多的副本,最终完成所有副本的更新。 滚动更新的好处 最大好处是零停机,整个更新过程始终有副本在运行,从而保证了业务的连续性。 根据 yaml 创建资源, apply 可以重复执行,create 不行 kubectl create -f deploy.yml kubectl apply -f deploy.yml --record 注意 当deploy.yml 是上次发布的内容没有更改时,使用kubectl apply无法进行更新发布。比如镜像使用的是latest标签时。 我们在发布deployment时,如果使用了如下的发布方式 或者 参数配置不正确时,会发现 服务会挂掉一会儿,用户会访问不了。 kubectl delete --ignore-not-found=true -f deploy.yml kubectl create -f deploy.yml 原因是 pod被删除或者 容器启动后,到服务真正工作起来,中间会有一段时间无法正常访问,但 k8s 却认为服务是正常就绪状态。 本篇文章主要解决这个问题,实现 平滑的发布,发布更新服务过程中保证服务一直可用,用户零感知。 设置滚动更新 服务准备 我们有一个api服务deploy.yaml如下: apiVersion: apps/v1 kind
  • .NET Core应用由于ErrorCode ='0x80004005:80008083而无法在IIS中启动(.NET Core app unable to start in IIS due to ErrorCode = '0x80004005 : 80008083)
    问题 我有一个.NET Core应用程序。 它与VS2017和Kestrel在本地运行。 它在IIS下本地运行。 但是,在服务器上,它无法以502.5 - Process Failure消息启动。 在事件日志中,我得到了更多详细信息: 具有物理根目录'C:... \ my-app-folder \'的应用程序'...'无法使用命令行'“ dotnet”。\ MyApp.dll'启动进程,ErrorCode ='0x80004005:80008083。 先前版本的应用程序可在同一服务器上正常运行,唯一的区别是它们是与VS2017RC(2&3)一起发布的,这是完全发布的VS2017的第一个版本。 ErrorCode = '0x80004005 : 80008083.是什么意思? 我如何解决它? 回答1 由于VS2017 RC随新版本的.NET Core SDK(.NET Core 1.0.4 SDK 1.0.1)一起提供,因此您还需要更新服务器上的框架。 回答2 目前,有一种简单的方法可以查看实际错误是什么。 从应用程序服务中打开控制台部分,然后尝试运行dotnet应用程序。 从那里我们可能会获得完整的错误消息和跟踪信息: 回答3 0x80004005表示文件丢失或无法访问。 子代码: 80008083似乎是版本冲突。 此错误表示服务器上需要安装其他版本的dotnet。 回答4
  • IBM data studio not connecting to local DB2 databases
    I have installed DB2 10.5 version on my local Ubuntu 12.04 Machine. Now i need a GUI. I already tried squirrel-sql & Db-Visualizer. While Db-Visualizer give me the view-only database structure, squirrel-sql give me some more options to manage. But now I need a DB2 administrator tool, which can handle all this tasks plus backup/restore, import/export etc. I have listen a lot for IBM Data Studio as de-facto tool for DB2. So I installed it. After install completion, I am unable connect to my DB2 databases/schemas. It is surprise As I am easily can connect my Dbs through squirrel-sql & Db
  • IBM 数据工作室未连接到本地 DB2 数据库(IBM data studio not connecting to local DB2 databases)
    问题 我已经在本地 Ubuntu 12.04 机器上安装了 DB2 10.5 版本。 现在我需要一个 GUI。 我已经尝试过 squirrel-sql 和 Db-Visualizer。 虽然 Db-Visualizer 为我提供了仅查看的数据库结构,但 squirrel-sql 为我提供了更多管理选项。 但是现在我需要一个 DB2 管理员工具,它可以处理所有这些任务以及备份/恢复、导入/导出等。 我经常听到 IBM Data Studio 作为 DB2 的实际工具。 所以我安装了它。 安装完成后,我无法连接到我的 DB2 数据库/模式。 令人惊讶的是,我可以轻松地通过 squirrel-sql 和 Db-Visualizer 连接我的数据库,但 IBM Data Studio 拒绝连接。 它在尝试期间出现以下错误。 Full message content: [jcc][t4][2043][11550][4.17.30] Exception java.net.SocketException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Malformed reply from SOCKS server. An attempt was made to access a
  • How to solve management service not starting up in Worklight 6.2
    I have installed Worklight 6.2 on Linux, using Liberty 8.5.5 and DB2 10.5. Created the DB2 databases for WRKLGHT and WLREPORT. Have executed the Server Configuration Tool and successfully created a Worklight Server configuration (did not have any errors in the Console view when running the Ant tasks, tables were created successfully in the database, and configuration shows deployed status in the SCT). Created a runtime environment in the SCT, also seemed to succeed (no errors in Console view, tables created/updated, runtime environment shows deployed in the SCT). Stopped and restarted the
  • 在 Android 中使用网络服务发现的内部错误(Internal error using Network Service Discovery in Android)
    问题 在第一次使用开发者页面上的示例和教程实现 NSDManager 时,应用程序成功启动了发现并找到了设备。 不过现在好像坏了…… 程序启动时,经过一些初始化,代码进入如下方法并成功运行: public void discoverServices() { Log.d(TAG, "Initializing discovery on NSD"); mNsdManager.discoverServices( SERVICE_TYPE, NsdManager.PROTOCOL_DNS_SD, mDiscoveryListener); } 接收到日志消息。 一段时间后(比如大约 5 分钟),这是从程序输出的: 05-21 11:08:32.518: E/NsdCamera(12236): Discovery failed: Error code:0 05-21 11:08:32.518: W/dalvikvm(12236): threadid=12: thread exiting with uncaught exception (group=0x40c9c930) 05-21 11:08:32.518: E/AndroidRuntime(12236): FATAL EXCEPTION: NsdManager 05-21 11:08:32.518: E/AndroidRuntime
  • 用户无法访问数据库(User can't access a database)
    问题 在我的PHP脚本中,我正在访问两个数据库db1和db2 。 我有一个可以访问db1但不能访问db2的用户myuser@localhost 。 从mysql.user表中选择时,有一条记录,该用户的主机为通配符% ,没有localhost主机。 SELECT user, host FROM mysql.user WHERE user = 'myuser'; 给我吗: +------------+------+ | user | host | +------------+------+ | myuser | % | +------------+------+ 1 row in set (0.00 sec) 在查看该用户的GRANTS时,我看到了db1和db2相同的权限 SHOW GRANTS FOR 'myuser'@'%'; +-----------------------------------------------------------------------------------------------------------+ | Grants for myuser@% | +-----------------------------------------------------------------------------------------------
  • 如何解决无法在Worklight 6.2中启动的管理服务(How to solve management service not starting up in Worklight 6.2)
    问题 我已经在Linux上使用Liberty 8.5.5和DB2 10.5安装了Worklight 6.2。 为WRKLGHT和WLREPORT创建了DB2数据库。 已经执行了服务器配置工具并成功创建了Worklight Server配置(运行Ant任务时控制台视图中没有任何错误,在数据库中成功创建了表,并且配置在SCT中显示了部署状态)。 在SCT中创建了一个运行时环境,似乎也成功了(控制台视图中没有错误,创建/更新了表,SCT中部署了运行时环境)。 停止并重新启动Liberty服务器。 可以通过(/ worklightconsole)进入Worklight admin并使用我的演示用户成功登录,但是这表明没有运行时环境。 尝试访问/ worklight / console上的运行时环境(鉴于我使用Worklight项目WAR在SCT中创建运行时配置的方式,它应该是正确的URL),但会出现各种错误:首先“服务不可用,因为初始化尚未完成。 ” 然后重试大约一两分钟后,我得到“ javax.servlet.ServletException:java.lang.RuntimeException:等待管理服务在com.worklight.core.auth.impl.AuthenticationFilter.isWaitingForInitialization
  • 我的Worklight 6.2控制台上没有运行时(No runtime on my Worklight 6.2 Console)
    问题 在Worklight 6.2环境中部署war文件之后,控制台不会显示关联的运行时环境:找不到运行时。 这是Worklight 6.2的基本用法,但我不知道如何解决它! 我所做的: 在WebSphere Liberty 8.5.5.2 + DB2 V10.5上安装Worklight Entreprise 6.2 使用我的设置定制configuration-liberty-db2.xml ant -f myxmlfile admdatabases ant -f myxmlfile adminstall ant -f myxmlfile数据库 ant -f myxmlfile安装 我在〜/ worklightconsole路径中有worklight控制台,但是没有运行时! 并在自由日志中: [6/24/14 15:28:00:978 CEST] 00000021 com.worklight.common.util.jmx.LibertyRuntimeMBeanHandler I Bean'*'不存在。 [6/24/14 15:28:00:979 CEST] 00000021 com.ibm.worklight.admin.services.RuntimeService I未找到mxbeans 这是我的server.xml自由文件的摘录: ant task for context
  • OGG兼容性列表
    OGG兼容性列表 OGG的版本对OS和数据库的版本有严格要求,具体查看:https://www.oracle.com/middleware/technologies/fusion-certification.html 11.2.1+版本的OGG:Installation TypeVersion SupportedProcessor TypeOS VersionOS 32/64 bitSupported Database Versions*Exceptions and Additional InformationOGG Core11.2.1.0.19+x64Windows Server 2008 R264 bitMicrosoft SQL Server 2005Microsoft SQL Server: Capture and Delivery for customers licensed before June 1st, 2016. Delivery for all customers. Only Enterprise Edition supported for SQL ServerOGG Core11.2.1.0.19+x64Windows Server 2008 with SP1+64 bitMicrosoft SQL Server 2005Microsoft SQL
  • Getting “EndPoint Not Found” error with WCF service deployed to SharePoint 2010 site
    I am trying to utilize the autocompleteextender from the ajaxcontroltoolkit in one of my sharepoint solutions (which requires an older version of the library since all of the recent ones require the .NET Framework 4.0) and unfortunately I can't use a page method in a UserControl, only in an actual page. Therefore I am left with only the one option which is to use a method from an actual web service. The problem is that I can't seem to figure out how to correctly deploy the service and configure the web.config. When I try to view the metadata information in the browser I get an error message
  • Lob已关闭。 错误代码= -4470,SQLSTATE =空(Lob is closed. ERRORCODE=-4470, SQLSTATE=null)
    问题 我正在使用IBM Websphere Commerce和db2,具有以下代码 Clob clobVar = null; if (result.elementAt(3) != null) clobVar = (Clob) result.elementAt(3); if (clobVar == null) { infoTable.put("EInfo", ""); } else { stringTemp = clobVar.getSubString(1, (int) clobVar.length()); infoTable.put("EInfo", stringTemp); } 代码工作正常,直到 clobVar = (Clob) result.elementAt(3); 但是一旦执行到 stringTemp = clobVar.getSubString(1, (int) clobVar.length()); 系统抛出异常 [jcc] [10120] [11936] [4.3.111]无效的操作:Lob已关闭。 错误代码= -4470,SQLSTATE =空 我做错了什么? 如何解决这个问题? 回答1 通过添加progressiveStreaming=2;可以解决此问题progressiveStreaming=2; 连接网址的参数 完整指定的连接URL如下所示: jdbc:db2
  • 1+X 云计算运维与开发(中级)案例实战——构建读写分离的数据库集群
    传送门 教育部:职业教育将启动“1+X”证书制度改革 职业教育改革1+X证书制度试点启动 1+X成绩/证书查询入口 文章目录 1. 案例目标2. 案例分析2.1 规划节点2.2 基础准备 3. 案例实施3.1 基础环境配置3.2 部署MariaDB主从数据库集群服务3.3 部署Mycat读写分离中间件服务3.4 验证数据库集群服务读写分离功能持续更新ing!!!要是有用别忘了点个关注哦!!! 1. 案例目标 了解mycat提供的读写分离功能了解mysql数据库的主从架构构建以mycat为中间件的读写分离数据库集群 2. 案例分析 2.1 规划节点 使用Mycat作为数据库中间件服务构建读写分离的数据库集群,节点规划如下 IP主机名节点172.16.51.170mycatMycat中间件服务节点172.16.51.171db1MariaDB数据库集群主节点172.16.51.172db2MariaDB数据库集群从节点 2.2 基础准备 使用CentOS7.2系统,flavor使用2vCPU/4G内存/50G硬盘,创建三台虚拟机进行实验。 其中两台虚拟机db1和db2部署MariaDB数据库服务,搭建主从数据库集群;一台作为主节点,负责写入数据库信息;另一台作为从节点,负责读取数据库信息。 使用一台虚拟机部署Mycat数据库中间件服务,将用户提交的读写操作识别分发给相应的数据库节点
  • DB2无法连接到服务器(DB2 can't connect to the server)
    问题 我正在尝试在Windows 7机器上设置db2服务器,但是我无法从远程(仅从本地)连接到数据库。 我想我可能会错过一些配置。 1)我关闭了防火墙2)我的数据库信息是: 数据库2条目: Database alias = SAMPLE Database name = SAMPLE Local database directory = C: Database release level = f.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = netstat -a命令的部分输出为: TCP [::]:49155 WIN-whatever:0 LISTENING TCP [::]:49164 WIN-whatever:0 LISTENING TCP [::]:49165 WIN-whatever:0 LISTENING TCP [::]:50000 WIN-whatever:0 LISTENING 从客户端,如果我对服务器执行ping操作,则它不会响应另外,如果我使用nmap -sV <server_ip_address>对其进行扫描