|
Problem IC93858
|
Status: Closed |
CALLING SQLSETSTMTATTR WITH THE OPTION SQL_ATTR_CHAINING_END CAN RETURN SQL_ERROR , BUT DOESN'T UPDATE THE ERROR HEADER. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
calling SQLSetStmtAttr with the option SQL_ATTR_CHAINING_END can
return SQL_ERROR , but doesn't update the error header.
eg.
sqlsetstmtattr SQL_ATTR_INSERT_BUFFERING
SQL_ATTR_INSERT_BUFFERING_IGD
sqlsetstmtattr SQL_ATTR_CHAINING_BEGIN
loop
SQLExecute
endloop
sqlsetstmtattr SQL_ATTR_CHAINING_END
db2trc:
6157677 361.124496000 | | | CLI_callbDrdaInput exit [rc =
0x892A0017 = -1993736169 = SQLZ_RC_NEED_DATA]
6157678 361.124496000 | | CLI_sqlExecuteChaining exit
6157679 361.124496000 | SQLExecute2 exit
6157680 361.124496000 |
CLI_execCheckAndPrepareForFailoverRetry entry
6157681 361.124497000 |
CLI_execCheckAndPrepareForFailoverRetry data [probe 10]
6157682 361.124497000 |
CLI_execCheckAndPrepareForFailoverRetry exit
6157683 361.124498000 SQLExecute exit
6157684 361.124499000 SQLSetStmtAttrW entry
6157685 361.124501000 SQLSetStmtAttrW mbt
[Marker:PD_CLI_APP_CTX_PTR ]
6157686 361.124510000 | SQLSetStmtAttr2 entry
6157687 361.124515000 | | CLI_sqlExecuteChaining entry
...
6157692 361.134236000 | | CLI_sqlExecuteChaining exit
6157693 361.134239000 | | CLI_executeStaticDummystmt
entry
6157694 361.134246000 | | | SQLAllocStmt2 entry
..
157707 361.134268000 | | | | CLI_memAlloc exit
6157708 361.134268000 | | | SQLSetParam2 exit
6157709 361.134269000 | | | CLI_sqlExecute entry
6157710 361.134270000 | | | | CLI_sqlSetupInputDD entry
6157711 361.134270000 | | | | | CLI_ddBuildInputDDFromIPD
entry
6157712 361.134273000 | | | | | CLI_ddBuildInputDDFromIPD
exit
real error happening here :
6158090 entry DB2 UDB call level interface
CLI_errStoreNativeError fnc (1.3.42.42.0)
pid 14448 tid 140437435705184 cpid 44149 node -1 sec 365
nsec 587475000
bytes 185
Data1 (PD_DB2_TYPE_SQLCA,136) SQLCA:
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -911 sqlerrml: 1
sqlerrmc: 2
sqlerrp : SQLRI039
sqlerrd : (1) 0x80100002 (2) 0x00000002 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFB85 (6)
0x00000003
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 40001
Data2 (PD_TYPE_STRINGN,5) String with size:
40001
Data3 (PD_CLI_TYPE_ROWNO,8) Row Number:
-2
Data4 (PD_CLI_TYPE_COLNO,4) Column Number:
-2
6158135 365.587548000 | | | | CLI_sqlCompleteCallback
exit [rc = 0x8037006D = -2143879059 = SQLJR_CABLT]
6158136 365.587554000 | | | | CLI_errMoveErrors entry
6158137 365.587554000 | | | | CLI_errMoveErrors exit
6158138 365.587556000 | | | CLI_sqlExecute exit [rc =
0xFFFFFFFF = -1]
6158139 365.587557000 | | | SQLFreeStmt2 entry
...
6158164 365.587571000 | | | | | | CLI_memFree entry
6158165 365.587572000 | | | | | | CLI_memFree exit
6158166 365.587573000 | | | | | CLI_descrFreeArray exit
6158167 365.587573000 | | | | CLI_descrFreeDescr exit
6158168 365.587574000 | | | SQLFreeStmt2 exit
6158169 365.587575000 | | CLI_executeStaticDummystmt exit
[rc = 0xFFFFFFFF = -1]
6158170 365.587576000 | SQLSetStmtAttr2 exit [rc =
0xFFFFFFFF = -1]
6158171 365.587579000 SQLSetStmtAttrW exit [rc =
0xFFFFFFFF = -1]
6158172 365.587586000 SQLGetDiagFieldW entry
6158173 365.587588000 SQLGetDiagFieldW mbt
[Marker:PD_CLI_APP_CTX_PTR ]
6158174 365.587590000 | SQLGetDiagField2 entry
6158175 365.587592000 | SQLGetDiagField2 exit
6158176 365.587593000 SQLGetDiagFieldW exit
CLI_executeStaticDummystmt returns SQL_ERROR but doesn't update
the error header. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW v10.5 Fixpack 4 or Higher *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in DB2 LUW v10.5 Fixpack 4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.07.2013
03.03.2014
03.03.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
| 10.5.0.4
|
|
