home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList