|
Problem IC88307
|
Status: Closed |
DB2RBIND COMMAND WITH OPTION ALL RETURNS SQL0551N, AFTER RUNNING DB2UPDV97. |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
After updating database to the new installed fix pack with the
db2updv97 utility, if the user attempts to run db2rbind with
option 'all', one package may fail to rebind with sqlcode
SQL0551N. The error will be logged in the db2rbind log file as
Package 'SYSIBMADM.P6180218' of database 'DBTEST' did not
succeed to rebind. UniqueID = 32413261474F4763
sqlcode = -551; sqlerrmc = SYSIBMﾘE; sqlrrp =
SQLNQ25ESYSIBMﾘE
SQL0551N "SYSIBM" does not have the required authorization
or privilege to perform operation "EX
In db2daig.log with diaglevel 4:
2012-06-14-13.47.27.068480-240 I49969E742 LEVEL: Info
PID : 2961 TID : 46912572404624PROC :
db2rbind
INSTANCE: INST1 NODE : 000
APPID : *LOCAL.INST1.120614173142
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -551 sqlerrml: 53
sqlerrmc: SYSIBM EXECUTE SYSIBMADM.MONREPORT.MON_GET_CONNECTION
sqlerrp : SQLNQ25E
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000001 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 42501 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 V10.1 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Running db2rbind without the -all option should be *
* sufficient to *
* rebind all the invalid packages that require rebinding. *
* Or upgrade to V10.2 *
**************************************************************** |
| 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 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.11.2012
19.07.2013
19.07.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
