corrupted page

Hello everybody. I have an specific table corrupted in one database server. Hardware and softwawe are SunOS d0node0 5.8 Generic_108528-13 sun4u sparc SUNW,Ultra-Enterprise Informix Dynamic Server 2000 Version 9.21.FC5 Sun Cluster 2.0, database spaces on external and redundant boxes and a report from IDS about problems with that table 10:06:58 Results: Cannot use TBLSpace page for TBLSpace 4195700 10:06:58 Action: Run 'oncheck -pt 4195700' 10:06:58 Stack for thread: 50593 oncheck I already run oncheck -pt 4195700 , but the answere is TBLspace Report for sed:informix.b_insacc Error opening TBLspace b_insacc. I've tried to delete that table to dbloadit again but it can't be removed. Any thing I try to do to that table es rejected because of the error status. I wonder if could it be a procedure to get ride of the mencioned table, and mark unusable the space. So I can create again the table and load data on it. thanks in advance --Nestor

dbexport / dbimport ;) ? Una vez nos pasó lo mismo por hacer una barrabasada... (meternos con las tanlas del sistema para desactivar unos constraints)... La tabla quedó inusable sencillamente lo único posible fue cambiar nuestros programas para que usaran una copia de dicha tabla <tmp_la_dichosa_tabla>, luego cuando nos actualizamos (dbexport/dbimport) la cosa se solucionó incluso cuando ya no se necesitaba... hoy en dia la tabla se sigue llamando <tmp_la_dichosa_tabla> jajaja... Tal vez la gente de Informix pueda meterse a tu sistema y hacer alguna magia. J. -----Original Message----- From: "Néstor Gómez Muñoz" <nestorgm@prodigy.net.mx> To: ids@iiug.org Date: Mon, 25 Sep 2006 11:21:56 -0400 (EDT) Subject: corrupted page [7530] Hello everybody. I have an specific table corrupted in one database server. Hardware and softwawe are SunOS d0node0 5.8 Generic_108528-13 sun4u sparc SUNW,Ultra-Enterprise Informix Dynamic Server 2000 Version 9.21.FC5 Sun Cluster 2.0, database spaces on external and redundant boxes and a report from IDS about problems with that table 10:06:58 Results: Cannot use TBLSpace page for TBLSpace 4195700 10:06:58 Action: Run 'oncheck -pt 4195700' 10:06:58 Stack for thread: 50593 oncheck I already run oncheck -pt 4195700 , but the answere is TBLspace Report for sed:informix.b_insacc Error opening TBLspace b_insacc. I've tried to delete that table to dbloadit again but it can't be removed. Any thing I try to do to that table es rejected because of the error status. I wonder if could it be a procedure to get ride of the mencioned table, and mark unusable the space. So I can create again the table and load data on it. thanks in advance --Nestor ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. Jean Sagi jeansagi@myrealbox.com jeansagi@gmail.com

Hi, Por favor, hablar no espagnol. How does sounds your response in english ? So everybody can learn about manipulating corrupted pages ! Yves Ds. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]=20 Sent: 25 September 2006 18:59 To: ids@iiug.org Subject: Re: corrupted page [7531] dbexport / dbimport ;) ?=20 Una vez nos pas=F3 lo mismo por hacer una barrabasada... (meternos con = las=20 tanlas del sistema para desactivar unos constraints)...=20 La tabla qued=F3 inusable sencillamente lo =FAnico posible fue cambiar = nuestros=20 programas para que usaran una copia de dicha tabla = <tmp_la_dichosa_tabla>,=20 luego cuando nos actualizamos (dbexport/dbimport) la cosa se = solucion=F3 incluso=20 cuando ya no se necesitaba... hoy en dia la tabla se sigue llamando=20 <tmp_la_dichosa_tabla> jajaja...=20 Tal vez la gente de Informix pueda meterse a tu sistema y hacer alguna magia.=20 J.=20 -----Original Message-----=20 From: "N=E9stor G=F3mez Mu=F1oz" <nestorgm@prodigy.net.mx>=20 To: ids@iiug.org=20 Date: Mon, 25 Sep 2006 11:21:56 -0400 (EDT)=20 Subject: corrupted page [7530]=20 Hello everybody.=20 I have an specific table corrupted in one database server. Hardware and = softwawe are=20 SunOS d0node0 5.8 Generic_108528-13 sun4u sparc SUNW,Ultra-Enterprise=20 Informix Dynamic Server 2000 Version 9.21.FC5=20 Sun Cluster 2.0, database spaces on external and redundant boxes=20 and a report from IDS about problems with that table=20 10:06:58 Results: Cannot use TBLSpace page for TBLSpace 4195700=20 10:06:58 Action: Run 'oncheck -pt 4195700'=20 10:06:58 Stack for thread: 50593 oncheck=20 I already run oncheck -pt 4195700 , but the answere is=20 TBLspace Report for sed:informix.b_insacc=20 Error opening TBLspace b_insacc.=20 I've tried to delete that table to dbloadit again but it can't be=20 removed. Any thing I try to do to that table es rejected because of the = error status.=20 I wonder if could it be a procedure to get ride of the mencioned table, = and mark unusable the space. So I can create again the table and load=20 data on it.=20 thanks in advance=20 --Nestor=20 ************************************************************************= **** ***=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20 Jean Sagi=20 jeansagi@myrealbox.com=20 jeansagi@gmail.com=20 ************************************************************************= **** ***=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20 *****DISCLAIMER***** Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde en vertrouwelijk. Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en de verzender te verwittigen. Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is niet toegestaan, tenzij anders vermeld. Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan de Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit bericht gewijzigd is. Bezoek onze website: http://www.dofi.fgov.be ---------------------------------------- *****DISCLAIMER***** Ce message et toutes les pieces jointes sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office des Etrangers decline toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. Visiter notre site web: http://www.dofi.fgov.be