DB2 - Problem description
Problem IT19501 | Status: Closed |
SQLP_NOTA FROM REMOTE NODE MAY CAUSE CLIENT TO TERMINATE THE APPLICATION. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
The APAR is applicable to application using two phase protocol and server with DPF setup. In certain high-CPU scenarios, DB2 may receive SQLP_NOTA message from a remote node which may lead to in-doubt transactions on DB2 server and termination of the connection by DB2 client. The issue is caused by the incorrect reply from server on the error condition, causing client to terminate the connection instead of issue a rollback. DB2 logs the error and warning in db2diag.log reporting the error. 2015-04-03-14.53.09.352439-240 I77906470E555 LEVEL: Error PID : 22102 TID : 140723617785600 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : xxxxxxxx APPHDL : 0-41637 APPID: AUTHID : test HOSTNAME: EDUID : 194284 EDUNAME: db2agent (xxxxxx) 0 FUNCTION: DB2 UDB, relation data serv, sqlrkprp, probe:850 RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT "SQLCA has already been built" 2015-04-03-14.53.09.355478-240 I77907026E640 LEVEL: Error PID : 22102 TID : 140723617785600 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : APPHDL : 0-41637 APPID: AUTHID : test HOSTNAME: EDUID : 194284 EDUNAME: db2agent ( ) 0 FUNCTION: DB2 UDB, relation data serv, sqlrrcom_dps, probe:100 DATA #1 : String, 49 bytes Rollback due to failed prepare to commit. RC = DATA #2 : Hexdump, 4 bytes 0x00007FFCC53FCE24 : 6D00 1280 2015-04-03-14.53.09.360313-240 I77908901E653 LEVEL: Warning PID : 22102 TID : 140723617785600 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : APPHDL : 0-41637 APPID: AUTHID : test HOSTNAME: EDUID : 194284 EDUNAME: db2agent ( ) 0 FUNCTION: DB2 UDB, DRDA Application Server, sqljsGenPrcCnvRm, probe:10 MESSAGE : DIA5000C A DRDA AS token "PROTOCAL CONVERSION ERROR " was detected. The diagnostic data returned is (SRVDGN): "SQLERRP:SQLRR034 SQLCODE:-903". | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 10.5 Fix Pack 9 or higher * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
First fixed in Db2 10.5 Fix Pack 9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.03.2017 29.09.2017 29.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |