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

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Platforms                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 LUW v10.5 Fixpack 4 or Higher                 *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 LUW v10.5 Fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC93858

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-02

  • Closed date

    2014-03-03

  • Last modified date

    2014-03-03

  • APAR is sysrouted FROM one or more of the following:

    IC93855

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA50 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.5

Reference #:

IC93858

Modified date:

2014-03-03

Translate my page

Machine Translation

Content navigation