|
Problem IT10629
|
Status: Closed |
"CLI0126E OPERATION INVALID AT THIS TIME, SQLSTATE=HY011" ERROR RETURNED FOR A SQL STATEMENT USING 'BEGIN ATOMIC .. END' CLAUSE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* All DB2 Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V10.5 Fix Pack 7 or higher. *
**************************************************************** |
| Local Fix: |
|
| Solution |
Fixed in DB2 V10.5 Fix Pack 7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.08.2015
21.01.2016
21.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
