|
Problem IC74414
|
Status: Closed |
AUTO REORG EVALUATION FAILED IN PROBE 280 OF FUNCTION DB2HMONEVALREORG |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The following error message may be observed in db2diag.log:
2011-02-02-07.48.24.606727-660 I287995A484 LEVEL: Error
PID : 15798 TID : 2199466391888PROC : db2acd
0
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.110201184851
FUNCTION: DB2 UDB, Automatic Table Maintenance,
db2HmonEvalReorg,
probe:515
MESSAGE : Failed to evaluate table "SYSIBM
"."SYSAUDITPOLICIES". Probe
280 .
SQLCODE = 0
DATA #1 : Hexdump, 4 bytes
0x000002001A6993CC : 0000 0000
....
Please note that this issue is different from the one identified
in the other similar APAR IC65943. The MESSAGE reported by this
issue contains "probe 280", while the APAR IC65943 has "probe
265". In fact, the error is caused by the system administrative
routine REORGCHK_TB_STATS not returning a result set due to
uninitialized statement handles. This routine is used by auto
reorg evaluation to get a table's statistics. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 5 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 |
First fixed in Version 9.7 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.02.2011
21.12.2011
21.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
