DB2 - Problembeschreibung
Problem IC91989 | Status: Geschlossen |
QUERY WITH TABLESAMPLE SYSTEM() MIGHT HANG IN SMP MODE (INTRA_PARALLEL = YES) | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
A query with TABLESAMPLE SYSTEM() might hang if it runs in parallel mode, i.e. INTRA_PARALLEL = YES. This issue was observed with ADMIN_MOVE_TABLE function which might use such queries starting with DB2 v10.1 Fixpack 1 (see also APAR IC84414). You might see a query like the following when executed with sub agents to hang: SELECT ... FROM <table> TABLESAMPLE SYSTEM() WITH UR; A stack trace against the coordinating agent might show "sqkfChannel::WaitRecvReady" function waiting to receive data from sub agents: ossDumpStackTraceInternal ossDumpStackTrace OSSTrapFile::dumpEx sqlo_trce sqloDumpDiagInfoHandler semtimedop sqloWaitEDUWaitPost sqkfChannel::WaitRecvReady sqkfChannel sqlkqrcv sqlktrcv sqlkt_unpack_tuple sqlktftc sqlritqa sqlriSectInvoke sqlrr_process_fetch_request sqlrr_open sqljs_ddm_opnqry sqljsParseRdbAccessed ... but in application snapshot there are no associated sub agents anymore. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 3. * **************************************************************** | |
Local-Fix: | |
Do not use INTRA_PARALLEL, or turn parallelism off for the query, i.e.: SET CURRENT DEGREE = '1' | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 10.1 Fix Pack 3. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC95295 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 30.04.2013 27.09.2013 27.09.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.3 | |
10.1.0.3 |