Help on function "table repack"

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>;

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. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --0016e6d99b830eb7240480598e43

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. >> >> >> > >

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.