|
Problem IC74414
|
Status: Geschlossen |
AUTO REORG EVALUATION FAILED IN PROBE 280 OF FUNCTION DB2HMONEVALREORG |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 5 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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 |
First fixed in Version 9.7 Fix Pack 5. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 11.02.2011
21.12.2011
21.12.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
