DB2 - Problembeschreibung
Problem IT03953 | Status: Geschlossen |
INCORRECT STATEMENT TEXT (WRAPPED SQL09076 ...) MIGHT BE CATALOGUED IN TEXT COLUMN OF SYSCAT.ROUTINES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
DB2 might catalog wrapped text for an internally-generated statement, instead of the original PL/SQL statement, like this. select valid, substr(text, 1, 600) text from sysibm.sysroutines where routinename = 'P' VALID TEXT ----- -------------------------------------------------------... Y CREATE PROCEDURE P WRAPPED SQL09074 ablGWmdiWmtqTmdCTm... 1 record(s) selected. This can occur when a previously invalidated non-package PL/SQL routine is referenced from another routine inside a PL/SQL package body. This error does not affect the correct operation of the routine, and it only affects the value of the TEXT column. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to DB2 V10.5 FixPack 5 or later. * **************************************************************** | |
Local-Fix: | |
The original value of the TEXT column can be restored by dropping and recreating the routine. However, without the fix, it might be incorrectly catalogued again. | |
Lösung | |
This problem was first fixed in DB2 V10.1 FixPack 5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.08.2014 13.07.2015 13.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |