DB2 - Problembeschreibung
Problem IC67820 | Status: Geschlossen |
THE SQL TEXT FOR FAILED STATEMENTS (EG SQL0270N) DOES NOT APPEAR IN THE EVENT MONITOR , INSTEAD THERE IS ONLY A " - " | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
If a sql statement fails with sqlcode its text may not appear in event monitor output for example: db2 "create table t1 (id int)" db2 "alter table t1 alter column id set generated always as identity" this will trigger -270 error with reason 72, "A nullable column cannot be changed to become an identity column" db2 "alter table t1 alter column id set generated always as identity" DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0270N Function not supported (Reason code = "72"). SQLSTATE=42997 However dynamic sql snapshot contains this statement text db2pd -db dbname -dynamic Dynamic SQL Statements: Address AnchID StmtUID NumEnv NumVar NumRef NumExe Text 0x0000002AC93CD760 124 1 1 1 1 1 alter table t1 alter column id set generated always as identity | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users prior to DB2V95 FP6 * **************************************************************** * PROBLEM DESCRIPTION: * * THE SQL TEXT FOR FAILED STATEMENTS (EG SQL0270N) DOES * * NOTAPPEARIN THE EVENT MONITOR , INSTEAD THERE IS ONLY A " - * * " * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V95 FP6 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
Problem First fixed in DB2 V95 FP6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.04.2010 22.06.2010 22.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |