Skip to Content

How to clean the free list blocks on an offline dbspace?

Jan 04 at 06:41 AM


avatar image

Dear All,

Here's a problem on free list blocks cleaning --

1. Customer's IQ storage got issue and some bad blocks found on iqfile which can't be corrected.

2. Customer is using "flash copy LUN" to make IQ backups. So they decide to start IQ server on the backup site. the IQ can startup, but that dbspace is offline.

3. Customer wants to drop this ill dbspace, but failed as it always report -- some object on it -- even after customer force_drop all the tabes on this dbspace and run "dropleaks" against this dbspace.

4. sp_iqdbspace shows -- there are some blocks of "Global free list" left on this offline dbspace. Then we tried -- Start the IQ with -iqmpx_reclaimwriterfreelist -- but still fail to clean it. So we still can't free those blocks. -- and then -- we can't drop this ill dbspace on the new site.

Is there any ideas? Please kind help. Thanks in advance.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers