DB2 FOR LUW / DB2FORLUW / A50 - DB2

CLI Application received  error 'CLI0126E  Operation invalid at 
this time. SQLSTATE=HY011' when trying to execute SQL statement 
under BEGIN ATOMIC .. END clause. 
 
Reproducible with this CLI script: 
======================= 
sqlallocstmt 1 1 
sqlsetstmtoption 1 SQL_ATTR_ROW_ARRAY_SIZE 100 
sqlsetstmtattr 1 SQL_ATTR_PARAMSET_SIZE 2 
SQLPrepare 1 "BEGIN ATOMIC insert into t1(name) values (?); END" 
-3 
getmemarray 1 1 10 sql_c_char 30 
sqlbindparameter 1 1 sql_param_input sql_c_char sql_varchar 30 0 
1 memarray 
updateelem 1 0 value -3 "one1" 
updateelem 1 1 value -3 "tow2" 
 
SQLExecute 1 
sqltransact 1 1 SQL_COMMIT 
killenv 1 
======================================= 
 
Trace shows: 
 
[1438772038.415119 - 08/05/2015 16:23:58.415119] SQLExecute( 
hStmt=1:1 ) 
[1438772038.415220 - 08/05/2015 16:23:58.415220]     ---> Time 
elapsed - +7.050000E-004 seconds 
 
[1438772038.415299 - 08/05/2015 16:23:58.415299] SQLExecute( ) 
[1438772038.415352 - 08/05/2015 16:23:58.415352]     <--- 
SQL_ERROR   Time elapsed - +2.330000E-004 seconds 
 
[1438772038.419210 - 08/05/2015 16:23:58.419210] SQLGetDiagRecW( 
pszSqlState="HY011", pfNativeError=-99999, 
pszErrorMsg="[IBM][CLI Driver] CLI0126E  Operation invalid at 
this time. SQLSTATE=HY011", pcbErrorMsg=74 ) 
[1438772038.419438 - 08/05/2015 16:23:58.419438]     <--- 
SQL_SUCCESS   Time elapsed - +1.073000E-003 seconds

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 Users                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.5 Fix Pack 7 or higher.                   * 
****************************************************************

Fixed in DB2 V10.5 Fix Pack 7.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

11.08.2015
21.01.2016
21.01.2016