Re: dbexport and different rows number

You didn't post your version but I've seen this on older versions, especially on SE. Make sure you 'update statistics' before the dbexport, that usually helps. Brian Grellinger I.S. Manager Doosan Infracore America Corp Information Systems >>> "ph" <piotr_h@tlen.pl> 06/30/06 06:08AM >>> Hi, I exported informix database using dbexport buildin tool. I have many tables and in same cases there are difference between row number reported in sql exported file and real number of rows in unl file: eg. { TABLE test row size = 8 number of columns = 2 index size = 24 } { unload file name = test101.unl number of rows = 91425 } but real number of rows is 91320 While is this? ph _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

> { unload file name = test101.unl number of rows = 91425 } > > but real number of rows is 91320 this is called corruption; run bcheck, secheck for standard engine on that table or tbcheck; oncheck for online/ids; Superboer Brian Grellinger schreef: > You didn't post your version but I've seen this on older versions, > especially on SE. > Make sure you 'update statistics' before the dbexport, that usually > helps. > > > Brian Grellinger > I.S. Manager > Doosan Infracore America Corp > Information Systems > > >>> "ph" <piotr_h@tlen.pl> 06/30/06 06:08AM >>> > Hi, I exported informix database using dbexport buildin tool. > I have many tables and in same cases there are difference between row > number reported in sql exported file and real number of rows in unl > file: > > eg. > > { TABLE test row size = 8 number of columns = 2 index size = 24 } > { unload file name = test101.unl number of rows = 91425 } > > but real number of rows is 91320 > While is this? > > ph > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > > > --=_DCF9307A.F392F80E > Content-Type: text/html; charset=ISO-8859-1 > Content-Transfer-Encoding: quoted-printable > Content-Description: HTML > X-Google-AttachSize: 1442 > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-= > 1"> > <META content=3D"MSHTML 6.00.2900.2912" name=3DGENERATOR></HEAD> > <BODY style=3D"MARGIN-TOP: 2px; FONT: 12pt Courier New; MARGIN-LEFT: 2px"= > > > <DIV>You didn't post your version but I've seen this on older versions,=20 > especially on SE.</DIV> > <DIV>Make sure you 'update statistics' before the dbexport, that usually=20 > helps.</DIV> > <DIV>&nbsp;</DIV> > <DIV>&nbsp;</DIV> > <DIV>Brian Grellinger<BR>I.S. Manager<BR>Doosan Infracore America=20 > Corp<BR>Information Systems<BR><BR>&gt;&gt;&gt; "ph" &lt;piotr_h@tlen.pl&= > gt;=20 > 06/30/06 06:08AM &gt;&gt;&gt;<BR>Hi, I exported informix database using d= > bexport=20 > buildin tool.<BR>I have many tables and in same cases there are differenc= > e=20 > between row<BR>number reported in sql exported file and real number of ro= > ws in=20 > unl<BR>file:<BR><BR>eg.<BR><BR>{ TABLE test row size =3D 8 number of colu= > mns =3D 2=20 > index size =3D 24 }<BR>{ unload file name =3D test101.unl number of rows = > =3D 91425=20 > }<BR><BR>but real number of rows is 91320<BR>While is=20 > this?<BR><BR>ph<BR><BR>_______________________________________________<BR= > >Informix-list=20 > mailing list<BR>Informix-list@iiug.org<BR><A=20 > href=3D"http://www.iiug.org/mailman/listinfo/informix-list">http://www.ii= > ug.org/mailman/listinfo/informix-list</A><BR><BR></DIV></BODY></HTML> > > --=_DCF9307A.F392F80E--