DB2 - Problem description
Problem IT11301 | Status: Closed |
ON PARTICULARLY BUSY SYSTEM, SNAPTAB_REORG MIGHT RARELY RETURN REORG_STATUS OF '0' | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
On particularly busy system, SNAPTAB_REORG administrative view and SNAP_GET_TAB_REORG table function might rarely return REORG_STATUS of '0'. This might happen when the reorg status is collected in a very short window during the initialization of Monitor control block. ... REORG_STATUS ... ... ------------ ... ... 0 ... 1 record(s) selected. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users who use SNAPTAB_REORG administrative view or * * SNAP_GET_TAB_REORG table function. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to DB2 V10.5 FixPack 7 or later. * **************************************************************** | |
Local Fix: | |
Just re-try SNAPTAB_REORG /SNAP_GET_TAB_REORG. | |
Solution | |
This problem was first fixed in DB2 V10.5 FixPack 7. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.09.2015 26.01.2016 26.01.2016 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.7 |