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 IT10629 Status: Geschlossen

"CLI0126E OPERATION INVALID AT THIS TIME, SQLSTATE=HY011" ERROR
RETURNED FOR A SQL STATEMENT USING 'BEGIN ATOMIC .. END' CLAUSE

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 FixList