DB2 - Problembeschreibung
Problem IC91293 | Status: Geschlossen |
DB2 MIGHT ABEND WHILE EXECUTING A COMPOUND SQL STATEMENT | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
DB2 provides support for compound SQL (compiled) statements aka Anonymous Blocks. Such blocks do not allow any DDL statements to be present inside and are expected to return a SQL0104N error message. However, under rare scenarios, the execution of such a block containing the DDL statement might cause DB2 to abend if the following conditions are satisfied: 1. The anonymous blocks declares one or more DDL statements 2. The block also contains one or more statements which has an isolation level set on them. ============================ The crash was with signal 11 as below ============================ 0x00002AAAABA6BB18 _ZNK17sqlnq_qtbqunchild2ppEv + 0x0000 (/db2home/dwpinst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAACF57920 _Z30sqlnq_push_sub_select_iso_lockP9sqlnq_qun20sqlnq_isolationLe vel14sqlnq_lockModei 0x0056 (/db2home/dwpinst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAABE12317 _Z15sqlnq_postParseP9sqlnq_qurP3loc + 0x05a7 (/db2home/dwpinst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAABD32F5D _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl _enviiPP9sqlnq_qur + 0x0bcb (/db2home/dwpinst1/sqllib/lib64/libdb2e.so.1) 0x00002AAAABD3238D_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn _compileModesP14sqlrr_cmpl _env + 0x0021 (/db2home/dwpinst1/sqllib/lib64/libdb2e.so.1) | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 101 fix pack 3 * **************************************************************** | |
Local-Fix: | |
Remove the DDL statements from the block. | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
The problem has been fixed in DB2 version 101 fix pack 3 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 03.04.2013 01.10.2013 01.10.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.3 | |
10.1.0.3 |