|
Problem IC70026
|
Status: Geschlossen |
AFTER RUNNING DB2UPDV97, THE DB2RBIND COMMAND WITH OPTION ALL RETURNS SQL0551N |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 980 - 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 = xxxxxxxxxxxxxxxx
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: *
* Used db2rbind command with option all *
****************************************************************
* 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. The error will be logged *
* in *
* the db2rbind log file as *
* *
* *
* *
* Package 'SYSIBMADM.P1261193' of database 'DBTEST' did not *
* *
* succeed to rebind. UniqueID = xxxxxxxxxxxxxxxx *
* *
* 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 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to UDB Version 9.8 FixPack 3 *
**************************************************************** |
| 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.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Lösung |
Problem was first fixed in Version 9.8 FixPack 3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 19.07.2010
26.12.2010
26.12.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.8.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.8.0.3
|
 |
