|
Problem IC65598
|
Status: Closed |
UNDER RARE CONDITIONS, THE OPTIMIZER FAILS TO HANDLE AN OUT OF S TMTHEAP CONDITION, WHICH CAN LEAD TO EITHER A TRAP OR -901 ERROR |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
Under rare circumstances, the query optimizer fails to handle an
out of STMTHEAP condition which can lead to either a trap in
function sqlraFixupSqlDD or a sqlcode -901 error with sqlerrmc
token "unexpected NULL ZValue".
Partial stack often being reported with trap:
sqlraFixupSqlDD
sqlra_fill_var
sqlra_compile_var
sqlra_find_var
sqlra_get_var
sqlrr_prepare |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Under rare circumstances, the query optimizer fails to *
* handle an *
* out of STMTHEAP condition which can lead to either a trap in *
* *
* function sqlraFixupSqlDD or a sqlcode -901 error with *
* sqlerrmc *
* token "unexpected NULL ZValue". *
* *
* *
* *
* Partial stack often being reported with trap: *
* *
* *
* *
* sqlraFixupSqlDD *
* *
* sqlra_fill_var *
* *
* sqlra_compile_var *
* *
* sqlra_find_var *
* *
* sqlra_get_var *
* *
* sqlrr_prepare *
****************************************************************
* RECOMMENDATION: *
* Upgrade to version v9.5 or later using a fixpak that *
* includes the fix. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.01.2010
19.01.2010
19.01.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.
|
| Problem solved according to the fixlist(s) of the following version(s) |
