|
Problem IC81765
|
Status: Closed |
"DMS REBALANCER IS ACTIVE" STATE LOST AFTER ONLINE TABLE SPACE ROLLFORWARD |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Assume the state of a DMS table space shows
"Offline" (SQLB_OFFLINE)
"Roll forward pending" (SQLB_ROLLFORWARD_PENDING)
"DMS rebalancer is active" (SQLB_REBAL_IN_PROGRESS)
The table space is offline for example due to a problem
accessing one of its containers. The user corrects this problem,
and the table space is brought online during the next table
space start. The "Offline" state will be removed. Then an online
table space rollforward is issued against the table space. The
"Roll forward pending" state will be removed, which is correct.
However, the "DMS rebalancer is active" state will disappear,
too, which is incorrect. No rebalancing will take place.
The fix is to ensure that the "DMS rebalancer is active" state
persists even after a successful rollforward, and the rebalancer
is started automatically after the rollforward finishes. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* see APAR description *
****************************************************************
* PROBLEM DESCRIPTION: *
* see APAR description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to IBM DB2 Database for Linux, Unix, and Windows 9.7 *
* Fix Pack 6. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 |
Problem first fixed in IBM DB2 Database for Linux, Unix, and
Windows 9.7 Fix Pack 6. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC81864
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.03.2012
04.06.2012
04.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
