Force index cleanup after detaching partition?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lennart - 17 Jan 2008 13:07 GMT

DB2 V9.5 LUW, Is there any way that one can force Asynchronous index
cleanup (AIC) after detaching a partition in a range partitioned
table?

Thanx in advance

/Lennart

Reply to this Message

Jeroen van den Broek - 17 Jan 2008 14:05 GMT

> DB2 V9.5 LUW, Is there any way that one can force Asynchronous index
> cleanup (AIC) after detaching a partition in a range partitioned
[quoted text clipped - 3 lines]
>
> /Lennart

Hi Lennart,

I'm not sure if this is going to answer your question, but you might
want to have a look at Scenario-1 on this InformationCentre page:
https://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.d
b2.luw.admin.partition.doc/doc/r0021568.html

HTH

--
Jeroen

Reply to this Message

Lennart - 17 Jan 2008 15:03 GMT

On Jan 17, 3:05 pm, Jeroen van den Broek
<nlt...@baasbovenbaas.demon.nl> wrote:
[...]

> Hi Lennart,
>
> I'm not sure if this is going to answer your question, but you might
> want to have a look at Scenario-1 on this InformationCentre page:https://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic...

Hi Jeroen. Thanks for the link, scenario 1 is the one I'm interested
in. This is the setup I have:

40 miljon rows loaded into table with 4 partitions and separate
tablespaces for data and index
1 partition with ca 15 miljon rows detached to temp table, and temp
table dropped

In the tablespace for the data ca 500000 pages are released which is
fine. In the tablespace for the index however, not a single page is
free'd. I have been waiting for a couple of hours and there is no
change (no one is using the db).

If I drop the index and recreate it I get the space back, but I would
like to find out if AIC is capable of freeing pages

/Lennart

Reply to this Message