|
Problem IC93855
|
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 / 970 - 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 v9.7 Fixpack 9 or higher *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in v9.7 Fixpack 9 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC93857 IC93858
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.07.2013
23.12.2013
23.12.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
