|
Problem IT06780
|
Status: Geschlossen |
POSSIBLE HANG WHEN RUNNING QUERY ON COLUMN-ORGANIZED TABLE IF NEW SUB-AGENT THREAD CANNOT BE ACQUIRED |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
An error acquiring a subagent thread at the beginning of
execution of a query on a column-organized query can result in a
hang for the application that hit the error. The hang would
involve a single agent in a stack similar to the following:
ibm_cde::services::EventWaitPost::wait
ibm_cde::services::EventWaitPost::wait
ibm_cde::query::deleteSchedulerWhenPossible
cdeInterface::runDestructor
cdeInterface::close
sqlriCdeClose
sqlricjpInfrequent
sqlricjp
sqlricls_complex
sqlricls
sqlriecc
sqlra_close_section
sqlrr_process_close_request
sqlrr_fetch_error
sqlrr_open
where the key aspect is the wait in
ibm_cde::query::deleteSchedulerWhenPossible.
Such an error, it should be noted, is generally a rare
occurrence. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* column-organized tables *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to Version 10.5 fixpack 7 *
**************************************************************** |
| Local-Fix: |
Avoiding errors such as interrupts, and ensuring the instance is
not running in a agent-constrained environment would avoid the
hang |
| Lösung |
Fixed in Version 10.5 fixpack 7 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.01.2015
20.01.2016
28.04.2016 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.7
|
 |
