DB2 - Problembeschreibung
Problem IC92357 | Status: Geschlossen |
SYSPROC.REORGCHK_IX_STATS STORED PROCEDURE CALL FROM A CLI APPLICATION FAILS WITH SQL0440N | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
SYSPROC.REORGCHK_IX_STATS stored procedure call from a CLI application fails with: "SQL0440N No authorized routine named "GET_INDEX_COLNAMES" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884" It works from Command Line Processor without any issues. Since CURRENT PATH is an updatable special register, the REORGCHK_IX_STATS procedure inherits the user's setting. CLI must qualify all references to built-in SYSIBM, SYSPROC, SYSFUN and SYSIBMADM objects to get consistent behavior. This APAR fixes this problem. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users using CLI driver based applications * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 9.7 Fix Pack 9 or higher * **************************************************************** | |
Local-Fix: | |
Using the CurrentFunctionPath keyword should avoid this problem. For example, modifying the db2dsdriver.cfg as follows should avoid this problem: <configuration> <dsncollection> <dsn alias="SAMPLE" name="SAMPLE" host="ADMINIB-7025GJS" port="50000"> <parameter name="Authentication" value="Server"/> <parameter name="CurrentFunctionPath" value="SYSIBM,SYSPROC,X"/> </dsn> </dsncollection> </configuration> | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 V9.7 Fix Pack 9 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 16.05.2013 16.12.2013 16.12.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP9 | |
Problem behoben lt. FixList in der Version | |
9.7.0.9 | |
9.7.0.9 |