IDS Forum

RES: Help on function "table repack"

Posted By: Celso Cabral Coimbra
Date: Wednesday, 24 February 2010, at 8:06 p.m.

In Response To: Re: Help on function "table repack" (Alexandre Marini)

Alexandre,

I have experienced the same problem,

Try run do oncheck -cI on that table
I agree with Fernando, it could be some in-place update,
Try run the oncheck -pT DATABASE:TABLE and check if there are some rows in the (oldest) version like below you should run a dummy update against the table.
There is a Documented bug fixed in 11.50.xC6. this problem can cause a Index corruption during de compress step. If you meet this problem you must drop and recreate the indexes.
Check this address http://www-01.ibm.com/support/docview.wss?uid=swg1IC62013

TBLspace Usage Report for DATABASE:OWNER.TABLE

Type Pages Empty Semi-Full Full Very-Full

---------------- ---------- ---------- ---------- ---------- ----------

Free 24012

Bit-Map 10

Index 0

Data (Home) 38478

----------

Total Pages 62500

Unused Space Summary

Unused data slots 9

Home Data Page Version Summary

Version Count

0 (oldest) 13384

1 (current) 25094

Celso Cabral Coimbra
Administrador de Banco de Dados
ClearTech Ltda
"Trust at the heart of Communications"
Tel. (11) 3576-4509

-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Alexandre Marini
Enviada em: quarta-feira, 24 de fevereiro de 2010 11:52
Para: ids@iiug.org
Assunto: Re: Help on function "table repack" [19113]

No, Fernando, that are no inplace alter tables on it.

It will be very difficult to execute it offline, since even on dawn
hours the database is acessed (24x7).

But I think I´ll do it after migrating the instance to FC6W1, since
there´s already a demand for it.

Regards for your help!

Alexandre Marini

Tecnologia da Informação - DBA

msn: alexandre_marini@hotmail.com

SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix

See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf

<http://www.iiug.org>

Fernando Nunes escreveu:
> Do you have inplace altered the table?
> Issues like this should be reported.
> Also be aware of the implications of doing repack online...
> Regards.
>
> On Wed, Feb 24, 2010 at 1:53 PM, Alexandre Marini <amarini@fazenda.ms.gov.br
>
>> wrote:
>>
>
>
>> Hello everybody.
>>
>> I´m running IDS 11.50.FC4 on a linux_64 red-hat based machine.
>> Obs: it´s a production system, with several access to the table
>> mentioned here.
>>
>> I´ve already did the step "table compress", slow but it´s completed fine.
>>
>> Now, when I´m trying to exec the repack step, I always receive this
>> error on the output of the script:
>> FAILED: table repack [DATABASE:TABLE]
>>
>> and the following errors on the online log:
>>
>> SCHAPI Repack for [DATABASE:TABLE] started
>> Repack operation failed for [DATABASE:TABLE], iserrno 0
>> SCHAPI ERROR: table repack [DATABASE:TABLE] failed
>>
>> I can´t use the option "repack_offline", because the database is
>> constantly in use.
>>
>> I´ve even tryed to set the IFX_DIRTY_WAIT variable, but it seems the
>> script is not using it to wait for locks running.
>>
>> My doubt is:
>> Is it really an error regarding table locks?
>> Is it some issue regarding the FC4 version???
>> (Mainly because I´m testing on a FC6W1 machine, and it´s running with no
>> errors until now, and I can even run a select query on the table, no
>> problems on it).
>>
>> Is there some other thing I could set to allow the execution of the task
>> "table repack" ???
>>
>> Best Regards!
>>
>> --
>>
>> Alexandre Marini
>>
>> Tecnologia da Informação - DBA
>>
>> SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
>>
>> See you at the 2010 IIUG Informix Conference
>> April 25-28, 2010
>> Overland Park (Kansas City), KS
>> www.iiug.org/conf
>>
>> <http://www.iiug.org>
>>
>>
>>
>>
>>
>
*******************************************************************************
>
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>>
>
>

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Help on function "table repack"
  Alexandre Marini -- Wednesday, 24 February 2010, at 8:53 a.m.
  • Re: Help on function "table repack"
    Fernando Nunes -- Wednesday, 24 February 2010, at 9:34 a.m.
    • Re: Help on function "table repack"
      Alexandre Marini -- Wednesday, 24 February 2010, at 9:51 a.m.
      • RES: Help on function "table repack"
        Celso Cabral Coimbra -- Wednesday, 24 February 2010, at 8:06 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.