DB2 - Problembeschreibung
Problem IC69328 | Status: Geschlossen |
AFTER RUNNING DB2UPDV97, THE DB2RBIND COMMAND WITH OPTION ALL RETURNS SQL0551N | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
After updating database to the new installed fix pack with the db2updv97 utility, running db2rbind command with option all attempts to rebind packages associated with UTL_* system routines and fails with SQL0551N. The error will be logged in the db2rbind log file as Package 'SYSIBMADM.P1261193' of database 'DBTEST' did not succeed to rebind. UniqueID = 414147694D584761 sqlcode = -551; sqlerrmc = SYSIBM; sqlrrp = SQLRA02 SQL0551N "SYSIBM" does not have the required authorization or privilege to perform operation "EXECUTE" on object "SYSIBMADM.UTL_TCP". SQLSTATE=42501 The reason for the failure is that it requires the binder, SYSIBM, to have the necessary privilege to rebind the package. However, SYSIBM is an internal system id so explicit privilege is not required to rebind system packages. Here are the repro steps: create/upgrade database to v9.7 GA or v9.7 FP1 move database to v9.7 FP2 run db2updv97 run db2rbind <dbname> -l db2rbind.log all | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * run db2updv97 and run db2rbind with the all option * **************************************************************** * PROBLEM DESCRIPTION: * * After updating database to the new installed fix pack with * * the db2updv97 utility, running db2rbind command with option * * all attempts to rebind packages associated with UTL_* system * * routines and fails with SQL0551N. * **************************************************************** * RECOMMENDATION: * * Upgrade to UDB V9.7 FP3 * **************************************************************** | |
Local-Fix: | |
Running db2rbind without the -all option should be sufficient to rebind all the invalid packages that require rebinding. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in UDB V9.7 FP3 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC70026 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.06.2010 07.10.2010 07.10.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP3 | |
Problem behoben lt. FixList in der Version | |
9.7.0.3 | |
9.7.0.3 |