DB2 - Problembeschreibung
Problem IT02447 | Status: Geschlossen |
DB2PD -REORG MIGHT SHOW INCORRECT REORG END TIME FOR PARTITIONED TABLES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
When reorg is run on one partition of a partitioned table (ON DATA PARTITION clause) the reorg end time is updated for all partitions, including those which were not reorganized. If reorg is run on all partitions, the reorg end time gets updated only when the last partition is finished (hence the end time is the same for all partitions). Reorg end time can be checked by db2pd tool using -reorg switch. Example: # reorg on all partitions $ db2 "reorg table my_partitioned" $ db2pd -reorg -db sample [...] Table Reorg Stats: Address TableName Start End [...] Status 0x0700000044147CA8 MY_PARTITIONED 01/22/2014 05:53:54 01/22/2014 05:53:59 [...] Done 0x0700000044148FA8 MY_PARTITIONED 01/22/2014 05:53:58 01/22/2014 05:53:59 [...] Done 0x07000000441469A8 MY_PARTITIONED 01/22/2014 05:53:54 01/22/2014 05:53:59 [...] Done # reorg on one partition $ db2 "reorg table my_partitioned on data partition PART1" $ db2pd -reorg -db sample [...] Address TableName Start End [...] Status 0x0700000044147CA8 MY_PARTITIONED 01/22/2014 05:56:40 01/22/2014 05:56:43 [...] Done 0x0700000044148FA8 MY_PARTITIONED 01/22/2014 05:53:58 01/22/2014 05:56:43 [...] Done 0x07000000441469A8 MY_PARTITIONED 01/22/2014 05:53:54 01/22/2014 05:56:43 [...] Done As we can see, end time was updated for all partitions despite the fact that reorg was run only on partition 1 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5 Fix Pack 5 or higher. * **************************************************************** | |
Local-Fix: | |
Actual time of REORG end can be verified using LIST HISTORY command: $ db2 LIST HISTORY REORG CONTAINING "<SCHEMA>.<TABLE>" FOR <DB_NAME> | |
Lösung | |
Fixed in DB2 version 10.5 Fix Pack 5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 11.06.2014 13.03.2015 13.03.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.5 |