|
Problem IC70026
|
Status: Closed |
AFTER RUNNING DB2UPDV97, THE DB2RBIND COMMAND WITH OPTION ALL RETURNS SQL0551N |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| 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 |
| Problem Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.8 FixPack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.07.2010
26.12.2010
26.12.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.3
|
 |
