Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList