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 IC88307 Status: Geschlossen

DB2RBIND COMMAND WITH OPTION ALL RETURNS SQL0551N, AFTER RUNNING DB2UPDV97.

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - 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:                                              * 
* 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.
verfügbare FixPacks:
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

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.11.2012
19.07.2013
19.07.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.2 FixList
10.5.0.2 FixList