|
Problem IC69328
|
Status: Closed |
AFTER RUNNING DB2UPDV97, THE DB2RBIND COMMAND WITH OPTION ALL RETURNS SQL0551N |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 = 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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in UDB V9.7 FP3 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC70026
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.06.2010
07.10.2010
07.10.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
