DB2 - Problembeschreibung
Problem IC63386 | Status: Geschlossen |
IF INSTANCE IS UP WHEN DB2IUPGRADE IS ISSUED, INCORRECT MESSAGE ABOUT DB2CKUPGRADE IS DISPLAYED | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
If db2iupgrade is issued while the instance is still up running, the below incorrect message will be returned. Database Manager cannot be started. DBI1126W Instance upgrade failed because one or more views defined in the database might impact database upgrade. Explanation: The db2iupgrade command calls the db2ckupgrade command. The instance upgrade fails if the db2ckupgrade command returns any errors. The db2ckupgrade command has identified one or more views that are dependent on database entities that have changed. This might cause the UPGRADE DATABASE command to fail. The identified views are listed in the db2ckupgrade log file. User response: Resolve the issue with the identified views or drop the views and then re-issue the re-issue the db2iupgrade command. After database upgrade, re-create the views that you dropped. Whereas the correct message that should get displayed is DBI1124E Instance inst-name cannot be upgraded. Explanation: An attempt was made to upgrade an instance. This instance cannot be upgraded because: The instance is still active. Upgrading this instance is not supported. This version of the db2iupgrade command cannot be used to upgrade this instance. User response: Ensure that the instance is ready for upgrading and you are using the correct version of the db2iupgrade command. For more information on upgrading an instance, refer to the DB2 Information Center. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All DB2 Version 9.7 GA servers on Linux, Unix, and * * Windowsplatforms running db2ckupgrade tool. * **************************************************************** * PROBLEM DESCRIPTION: * * If db2iupgrade is issued while the instance is still * * uprunning,the below incorrect message will be * * returned.Database Manager cannot be started.DBI1126W * * Instance upgrade failed because one or more viewsdefined in * * the database might impact database upgrade. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW Version 9.7 Fix Pack 1 or refer to * * "LocalFix". * **************************************************************** | |
Local-Fix: | |
Issue db2stop and retry db2iupgrade. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
The complete fix for this problem first appears in DB2 LUW Version 9.7 Fix Pack 1. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.09.2009 07.04.2010 07.04.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP1 | |
Problem behoben lt. FixList in der Version | |
9.7.0.1 |