DB2 - Problembeschreibung
Problem IC61937 | Status: Geschlossen |
CREATE PROCEDURE AGAINST DB2 FOR Z/OS V8/V9 FAILS WITH SQL0440N NO AUTHORIZED ROUTINE NAMED "GRANT" | |
Produkt: | |
DB2 CONNECT / DB2CONNCT / 970 - DB2 | |
Problembeschreibung: | |
When you try to create SP for zV8 or v9 server using SP wizard, save fails and following error is shown Executing SQL:CREATE PROCEDURE AATEMPSP1WIZ() RESULT SETS 1 LANGUAGE SQL COLLID TEST WLM ENVIRONMENT WLMENV1 RUN OPTIONS '' ---------------------------------------------------------------- ---------- -- DB2 SQL procedure ---------------------------------------------------------------- ---------- P1: BEGIN -- Declare variables -- Declare cursors DECLARE DB2_SP_SQL1 CURSOR WITH RETURN FOR Select NAME, SCHEMA from SYSIBM.SYSROUTINES; -- -- Cursor left open for client application. OPEN DB2_SP_SQL1; -- END P1 SYSPROC.WLM_REFRESH : 0 Executing SQL:GRANT EXECUTE ON PROCEDURE AATEMPSP1WIZ TO PUBLIC Error occurred: ERROR [42884] [IBM][DB2] SQL0440N No authorized routine named "GRANT" of type "" having compatible arguments was found. SQLSTATE=42884 : IBM.Data.DB2: -2147467259 | |
Problem-Zusammenfassung: | |
CREATE PROCEDURE AGAINST DB2 FOR Z/OS V8/V9 FAILS WITH SQL0440N NO AUTHORIZED ROUTINE NAMED "GRANT" | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 LUW v9.7 Fixpak 1 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 08.07.2009 29.12.2009 29.12.2009 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7. | |
Problem behoben lt. FixList in der Version | |
9.7.0.1 |