|
Problem IC65320
|
Status: Closed |
MISSING OUTPUT IN LIST TABLES AFTER RESTARTING THE DATABASE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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. |
| Problem Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
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 |
not known / see Local fix |
| Comment |
This issue is fixed by defect wsdbu00561405 in db2_v97fp2. See
the defect remarks for more any other info. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.12.2009
18.05.2010
18.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
| 9.7.0.3
|
|
| 9.7.0.3
|
|
