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

DATABASE UPGRADE FAILS WITH SQL20481N

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
Though db2ckupgrade  become successful,  a  database  upgrade 
fails with SQL20481N 
 
Messages  similar to following might be visible in db2diag.log 
 
2013-10-07-10.30.46.270534-300 I389948A348          LEVEL: 
Warning 
PID     : 18089                TID : 2199075095856  PROC : db2bp 
INSTANCE: db2inst1             NODE : 000           DB   : 
TESTDB 
APPID   : *LOCAL.db2inst1.131007152115 
HOSTNAME: host1 
FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:556 
MESSAGE : Begin db2spcat 
 
2013-10-07-10.30.49.049785-300 I390297A1914         LEVEL: Error 
PID     : 9709                 TID : 2199421708560  PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000           DB   : 
TESTDB 
APPHDL  : 0-18                 APPID: 
*LOCAL.db2inst1.131007152115 
AUTHID  : DB2INST1             HOSTNAME: host1 
EDUID   : 23                   EDUNAME: db2agent (TESTDB) 0 
FUNCTION: DB2 UDB, base sys utilities, sys_views, probe:1486 
MESSAGE : ZRC=0xFFFFAFFF=-20481 
          SQL20481N  The creation or revalidation of object "" 
would result in 
          an invalid direct or indirect self-reference.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users trying to upgrade database in V10.1                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Please see Error Description to find the details             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Users can upgrade to DB2 Version 10.1 fix pack 4 or higher   * 
* to avoid this defect                                         * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 Version 10.1 fix pack 4
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC99212 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.10.2013
16.06.2014
16.06.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.4 FixList