DB2 - Problembeschreibung
Problem IT10629 | Status: Geschlossen |
"CLI0126E OPERATION INVALID AT THIS TIME, SQLSTATE=HY011" ERROR | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All DB2 Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V10.5 Fix Pack 7 or higher. * **************************************************************** | |
Local-Fix: | |
Lösung | |
Fixed in DB2 V10.5 Fix Pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 11.08.2015 21.01.2016 21.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |