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

DB2 V9.7 INSTANCE CRASHED DURING DATABASE UPGRADING FROM V8.2 TO V9.7

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The DB2 instance may crash with the following callstack when 
the database is upgrading from v8.2 to v9.7. 
 
--1cUsqlnq_create_view_pd 
__1cZsqlnq_ddl_create_view_end 
__1cQsqlnn_regen_view 
__1cQsqlrl_regen_view 
__1cYsqlnq_recreate_view_stmt 
__1cMsqlnp_smactn6 
__1cMsqlnp_parser 
__1cKsqlnp_main 
__1cKsqlnn_cmpl 
__1cKsqlnn_cmpl 
__1cRsqlra_compile_var 
__1cOsqlra_find_var 
__1cNsqlra_get_var
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 fix pack 6                        * 
****************************************************************
Local-Fix:
Drop the problematic view on the old version, upgrade database, 
and then recreate the view in the new version.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

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