DB2 - Problembeschreibung
| Problem IC88641 | Status: Geschlossen |
EXPLAIN_FROM_ACTIVITY() STORED PROC RETURNS STATUS 0 BUT NO ROWS INSERTED INTO EXPLAIN TABLES AND OUTPUT PARAMETERS ARE NULL | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
| Problembeschreibung: | |
After calling the explain_from_activity() stored procedure a few thousand times to explain activities from the activity event monitor, it stops working and silently fails. It returns status 0 (success) but it does not actually insert any rows into the explain tables. It also returns null for all its output parameters. Once this state has been reached, all further explain_from_activity() calls will silently fail the same way. | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All platform * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V101 FP2. * **************************************************************** | |
| Local-Fix: | |
Disconnect the database and reconnect it again. | |
| verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows | |
| Lösung | |
DB2 V101 FP2 will contain the fix. | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 28.11.2012 27.02.2013 27.02.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
| Problem behoben lt. FixList in der Version | |
| 10.1.0.2 |
|
| 10.5.0.2 |
|