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 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
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a 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
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 FixList
9.7.0.3 FixList