DB2 - Problembeschreibung
Problem IC62969 | Status: Geschlossen |
DB2CHKUPGRADE MAY RETURN FALSE POSITIVE ORPHAN ROW ERRORS WITH SYSTABLES AND SYSTABLESPACES WHEN USERS HAVE NICKNAMES DEFINED | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
During upgrade from DB2 V8.2 to DB2 v9.7.GA, db2ckupgrade is failing. The following error may be returned: Version of DB2CKUPGRADE being run: VERSION 9.7.0.0 Database: 'SAMPLE' ** ERROR ** SQL1344N Orphan rows found in the system catalogs. Contact your technical service representative prior to attempting a upgrade. . The db2ckupgrade utility may be reporting false positives if the database has nicknames defined with schema beginning with "SYS". These orphan rows won't have any impact during the actual database upgrade, however, db2ckupgrade returns an error when orphan rows are detected and can cause the instance upgrade to fail. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Customers upgrading from V8.2 to DB2 9.7 GA * **************************************************************** * PROBLEM DESCRIPTION: * * db2chkupgrade may return false positive orphan row errors * * with SYSTABLES and SYSTABLESPACES when users have nicknames * * defined with schema beginning with "SYS" * **************************************************************** * RECOMMENDATION: * * Update to DB2 V9.7 FP1 or higher * **************************************************************** | |
Local-Fix: | |
Drop the reported nicknames, proceed with upgrade and recreate the dropped nicknames. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
Problem Fixed in DB2 Version 9.7 Fix Pack 1 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 03.09.2009 17.02.2012 17.02.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP1 | |
Problem behoben lt. FixList in der Version | |
9.7.0.1 |