DB2 - Problembeschreibung
Problem IC84719 | Status: Geschlossen |
DB2RBIND COMMAND WITH OPTION ALL RETURNS SQL0551N, AFTER RUNNING DB2UPDV97. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * 9.7fp6 * **************************************************************** * 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 DB2_97fp7 * **************************************************************** | |
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 7 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC88307 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.06.2012 19.07.2013 19.07.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.0.7FP7 | |
Problem behoben lt. FixList in der Version | |
9.7.0.7 |