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

MISSING OUTPUT IN LIST TABLES AFTER RESTARTING THE DATABASE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When ever a restart db command is issued following db2 
terminate, list tables shows only timestamp. Other 3 fields are 
displayed empty. The problem is seen only for the first time 
"list tables" command is executed  immediately after restarting 
the DB. 
 
The issue exists on linux platform. Same set of commands works 
fine on AIX.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* This problem occurs only on Linux platform. On AIX it is     * 
* working fine. The problem occurs when user executes below    * 
* commands:                                                    * 
* db2 terminate                                                * 
* db2 restart db <dbname>                                      * 
* db2 list tables                                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When ever a restart db command is issued following db2       * 
*                                                              * 
* terminate, list tables shows only timestamp. Other 3 fields  * 
* are                                                          * 
* displayed empty. The problem is seen only for the first time * 
*                                                              * 
* "list tables" command is executed  immediately after         * 
* restarting                                                   * 
* the DB.                                                      * 
*                                                              * 
*                                                              * 
*                                                              * 
* The issue exists on linux platform. Same set of commands     * 
* works                                                        * 
* fine on AIX.                                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to db2_v97fp2 or heigher version.                    * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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
This defect first fixed in db2_v97fp2. After fix of this defect 
the output of "list tables" is correct and it has no missing 
 
data.
Workaround
keiner bekannt / siehe Local-Fix
Kommentar
This issue is fixed by defect wsdbu00561405 in db2_v97fp2. See 
the defect remarks for more any other info.
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.12.2009
18.05.2010
18.05.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.7.0.2 FixList
9.7.0.3 FixList
9.7.0.3 FixList