DB2 - Problembeschreibung
Problem IT06710 | Status: Geschlossen |
-440 WITH SYS_INIT WHEN REOPT ALWAYS OR ONCE IS USED | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
When a PL/SQL package is created with REOPT ALWAYS or REOPT ONCE, and the package includes an initialization section, invoking a routine in the package can fail with the following error: SQL0727N An error occurred during implicit system action type "1". Information returned for the error includes SQLCODE "-440", SQLSTATE "42884" and message tokens "S1.P1.SYS_INIT". SQLSTATE=56098 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5 fix pack 7 * **************************************************************** | |
Local-Fix: | |
One of the following should help workaround the issue: 1. Redeploy the PL/SQL package. 2. Rebind the routine package with REOPT NONE. | |
Lösung | |
First fixed in DB2 version 10.5 fix pack 7 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.01.2015 29.01.2016 29.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |