DB2 - Problembeschreibung
Problem IT01225 | Status: Geschlossen |
DB2CKUPGRADE MIGHT REPORT: "SQL1344N ORPHAN ROWS FOUND" IF THERE ARE INVALID OBJECTS IN THE DATABASE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
db2ckupgrade utility might report false positive error related to orphan rows found in system catalog: DBT5529N The db2ckupgrade utility did not complete successfully. The database cannot be upgraded. The output log file is named "upgrade.log". following error will be logged to upgrade.log file: Version of DB2CKUPGRADE being run: VERSION "10.5" Database: "<DB_NAME>" SQL1344N Orphan rows found in the system catalogs. Contact your technical service representative prior to attempting a database upgrade. that will prevent database from being upgraded. This might happen if there are invalid objects in the database and object on which they depend, do not exist (which could have been the reason for invalidation). In order to verify that, you can use SYSCAT.INVALIDOBJECTS view: $ db2 "SELECT SUBSTR(OBJECTNAME,1,20) OBJECTNAME, SUBSTR(ROUTINENAME, 1,20) ROUTINENAME, OBJECTTYPE FROM SYSCAT.INVALIDOBJECTS" and see if such objects are found in the database. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5 and Fix Pack 4 or higher. * **************************************************************** | |
Local-Fix: | |
If invalid object exist in the database, fix the problem by either dropping them or fixing dependencies and re-validating using SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 version 10.5 and Fix Pack 4. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.04.2014 08.09.2014 08.09.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |