DB2 - Problembeschreibung
Problem IC68578 | Status: Geschlossen |
DB2 SERVER MAY TERMINATE ABNORMALLY WHEN CREATNG A VARIABLE OF TYPE DB2SECURITYLABEL WITH A DEFAULT VALUE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
A CREATE VARIABLE statement may cause DB2 to terminate abnormally when the followig conditions are satisfied: - the variable is of type DB2SECURITYLABEL - a default value expression has been specified The Stack Trace may look like: <StackTrace> -------Frame------ ------Function + Offset------ 0x090000003A724B68 insert_after__14sqlnq_baselistFPUcP13sqlnq_memPool + 0x278 0x090000003B9E9A6C sqlnnGenerateDepsForVariable__FP9sqlnq_qtbP17sqlnn_dat_TYPTYPERP UiRUlRiT5P3loc + 0x530 0x090000003B9E8AB8 sqlnq_create_variable_stmt__FPP8stknode_i10actiontypePUcP3loc + 0x64C Example: db2 " create variable v2 db2securitylabel default (seclabel_by_name('PLEVEL','L1'))" DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * A CREATE VARIABLE statement may cause DB2 to terminate * * * * abnormally when the followig conditions are satisfied: * * * * - the variable is of type DB2SECURITYLABEL * * * * - a default value expression has been specified * * * * * * * * The Stack Trace may look like: * * * * * * * * <StackTrace> * * * * -------Frame------ ------Function + Offset------ * * * * 0x090000003A724B68 * * * * insert_after__14sqlnq_baselistFPUcP13sqlnq_memPool + 0x278 * * * * 0x090000003B9E9A6C * * * * sqlnnGenerateDepsForVariable__FP9sqlnq_qtbP17sqlnn_dat_TYPTYPE * UiRUlRiT5P3loc * * * * + * * * * 0x530 * * * * 0x090000003B9E8AB8 * * * * sqlnq_create_variable_stmt__FPP8stknode_i10actiontypePUcP3loc * + * * 0x64C * * * * * * * * Example: * * * * * * * * db2 " create variable v2 db2securitylabel default * * * * (seclabel_by_name('PLEVEL','L1'))" * * * * * * * * DB21034E The command was processed as an SQL statement * * because * * it was not a * * * * valid Command Line Processor command. During SQL processing * * it * * returned: * * * * SQL1224N The database manager is not able to accept new * * * * requests, has * * * * terminated all requests in progress, or has terminated the * * * * specified request * * * * because of an error or a forced interrupt. SQLSTATE=55032 * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fixpack 7 and later. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
Fixed in DB2 Version 9.5 Fixpack 7 and later. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 11.05.2010 15.11.2010 15.11.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP7 | |
Problem behoben lt. FixList in der Version | |
9.1.0.7 | |
9.5.0.7 |