home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC93858 Status: Geschlossen

CALLING SQLSETSTMTATTR WITH THE OPTION SQL_ATTR_CHAINING_END CAN RETURN
SQL_ERROR , BUT DOESN'T UPDATE THE ERROR HEADER.

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v10.5 Fixpack 4 or Higher                 * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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

Lösung
First Fixed in DB2 LUW v10.5 Fixpack 4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.07.2013
03.03.2014
03.03.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.3 FixList
10.5.0.3 FixList
10.5.0.4 FixList