提取11424行后，在Source限定符中获取Informatica SQL30081N错误 [英] Getting error in Informatica SQL30081N in a Source qualifier after fetching 11424 rows

问题描述

我们在Informatica工作流程中遇到了错误.同样在试运行环境中无缝运行，问题在生产中.

We are getting below error in an Informatica workflow. The same is running seamlessly in pilot environment, issue is in production.

在选择11424行之后，此错误从z/Os DB2引发.如果单独运行，则此源限定符查询将获取260万行.在Informatica会话属性中将缓冲区设置为自动".

After 11424 rows are selected this error is thrown from z/Os DB2. This source qualifier query if run separately fetches 2.6 million rows. The buffer is set to Auto in the Informatica session properties.

SQL Error [
[IBM][CLI Driver] SQL30081N  A communication error has been detected. 
Communication protocol being used: "TCP/IP".  
Communication API being used: "SOCKETS".  
Location where the error was detected: "<server-ip 11:22:22:22 format>".  
Communication function detecting the error: "send".  
Protocol specific error code(s): "32", "*", "0".  
SQLSTATE=08001
sqlstate = 40003 

Database driver  error...
Function name  Fetch
Native error  code = -30081

由于我们尚未对此工作流程进行任何更改，因此有望成功运行.几周前开始失败.

This is expected to be run successfully as we have not made any changes to this workflow. This started failing a few weeks back.

我对此错误进行了一些阅读，我发现这是由于DB2防火墙阻止了连接.如果是这种情况，为什么在其他源限定符成功运行时，只有一个select语句失败?

I did some reading on this error and what I could find said this is due to connection blocked by DB2 firewall. If this is the case why only one select statement is failing while other source qualifiers are running successfully?

推荐答案

根据下面的Db2手册，它通常在Db2软件之外:

According to the Db2 manual below, it it typically outside the Db2 software:

SQL30081N消息的协议特定的错误代码
https://www.ibm.com/support/knowledgecenter/zh-CN/SSEPGG_11.5.0/com.ibm.db2.luw.messages.doc/doc/r0052008.html

SQL30081N消息的原因通常在Db2软件之外，并且实际的错误代码是特定于协议的.

The cause of the SQL30081N message is typically outside the Db2 software and actual error codes are protocol-specific.

这是错误编号为 32 的文档链接:

And here is a documented link for error number 32 :

TCP/IP错误
https://www.ibm.com/support/knowledgecenter/zh-CN/SSEPGG_11.5.0/com.ibm.db2.luw.messages.doc/doc/r0058740.html

Table 1. UNIX TCP/IP error numbers

errnos  AIX error number    Linux error number  Description

   :

EPIPE   32  32  Broken pipe.

因此，一般而言，建议检查TCP/IP级别.

So generally speaking, it is suggested to check TCP/IP level.

希望这会有所帮助.

这篇关于提取11424行后，在Source限定符中获取Informatica SQL30081N错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！