home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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