« Couples ditch love, marriage | Home | Personal productivity »
DB2 / UDB table rebalancing APAR IY48902
By Martin English | February 17, 2005
DMS rebalancer is active
APAR IY48902 describes a problem which occurs when you issue an ALTER TABLESPACE command which seems to succeed–that is, there are no error messages–but in fact the operation is not performed.
A major symptom that we saw was that the db2rebal process wasn’t running even though the db2 list tablespaces show detail told us DMS rebalancer is active. Secondary symptoms were that the 4th container was not being used – the difference between usable pages and used pages is 49952 which was the size of the 4th container less 48 pages of DB2 control data)
Total pages = 343750 Useable pages = 343648 Used pages = 293696 Free pages = 0 High water mark (pages) = 293696
However, IBM do provide a utility that helped (in our case anyway). The APAR says that you need to be at DB2 V8.1 FixPak 6 – we are at FixPak 5
APAR IY48902
http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=IY48902&uid=swg1IY48902&loc=en_US&cs=utf-8&lang=en+en)
Utility for finding and fixing
http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=IY48902&uid=swg21176205&loc=en_US&cs=utf-8&lang-=en
Once you’ve run the utility in fix mode, shutdown db2 (using db2_kill if necessary) then restart db2. db2 list tablespace containers should only show the containers that existed prior to the ALTER TABLESPACE that caused the problem.
Topics: Database, SAP, Work | 1 Comment »
Share on FriendFeed Tweet This
October 14th, 2005 at 10:10 pm
Thanks a lot. This fixed our problem.