|
Problem IC96607
|
Status: Closed |
DB2 GET RECOMMENDATIONS FOR HEALTH INDICATOR DB.TB_REORG_REQ ON DATABASE RETURN WRONG RESULTS |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
DB2 incorrectly produces DB2 script with recommendations when
db2 get recommendations for HEALTH INDICATOR db.tb_reorg_req on
database is issued.
DB2 misses to add semicolon character among with linefeed after
REORG statement in the recommendations output.
An example:
CONNECT to TESTDB;
REORG TABLE "SAMPLE"."TAB"RUNSTATS ON TABLE "SAMPLE"."TAB";
CONNECT RESET;
Instead should be
CONNECT to TESTDB;
REORG TABLE "SAMPLE"."TAB"
RUNSTATS ON TABLE "SAMPLE"."TAB";
CONNECT RESET; |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Customers who use the command GET RECOMMENDATIONS FOR HEALTH *
* INDICATOR. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V10.5FP3 *
**************************************************************** |
| Local Fix: |
Manually add semicolon character before RUNSTATS keyword. |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.10.2013
28.02.2014
28.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
