Negative npused bug: When will it be fixed? 
Author Message
 Negative npused bug: When will it be fixed?

: yesterday I upgraded our system from Online/Star 5.05 to 5.07UC1, hoping
: to get rid of the bug with UPDATE STATISTICS generating negative entries
: in the "npused" column in "systables".

: I had already been disappointed by the bug being still there in 5.05,
: but I'm really PISSED that it's still there in 5.07!

Well, there are two bugs which apparently can lead to npused being negative,
one fixed in 5.02, and one fixed in 5.06.  However, you must rebuild your
table in order to repair any npused which is already negative.  UPDATE
STATISTICS gets npused from your tblspace tblspace, and that cannot be
fixed by fixing the bug; the only way to fix your tblspace tblspace is to
rebuild your table.  There is a workaround (a stored procedure to calculate
the correct value of npused and update your systables AFTER you run UPDATE
STATS), if you cannot rebuild your table.

June

----   June Tong                              Informix Software    ----
----   Senior Consultant                      (415) 926-6140       ----

----       Location-du-jour: Oakland                               ----
*
* Standard disclaimers apply
*
- Please do not send me requests/questions by mail.  When I have the knowledge
- and time permits, I try to answer questions on comp.databases.informix, but
- travel schedule, time, and volume make responding to personal requests
- difficult and often slow.  Please call your local Informix Technical Support
- organization for assistance with technical issues.



Wed, 18 Jun 1902 08:00:00 GMT
 Negative npused bug: When will it be fixed?

Don't you have to drop and recreate each table to fix the bug?  Just upgrading
won't cut it.



Wed, 18 Jun 1902 08:00:00 GMT
 Negative npused bug: When will it be fixed?


Quote:
>Well, there are two bugs which apparently can lead to npused being
negative,
>one fixed in 5.02, and one fixed in 5.06.  However, you must rebuild your
>table in order to repair any npused which is already negative.

That appeared to fix the table I noticed it happening with under Informix
7.13.  I am a little curious about how it got there, but we did fairly
recently upgrade from 5.03, so that may have something to do with it.
--



Wed, 18 Jun 1902 08:00:00 GMT
 Negative npused bug: When will it be fixed?


Quote:

>Well, there are two bugs which apparently can lead to npused being negative,
>one fixed in 5.02, and one fixed in 5.06.  However, you must rebuild your
>table in order to repair any npused which is already negative.  UPDATE
>STATISTICS gets npused from your tblspace tblspace, and that cannot be
>fixed by fixing the bug; the only way to fix your tblspace tblspace is to
>rebuild your table.  There is a workaround (a stored procedure to calculate
>the correct value of npused and update your systables AFTER you run UPDATE
>STATS), if you cannot rebuild your table.

>June

Another way to correct the values, is to update the systables.npused field
to 0 then run update statistics. I am told by Informix that this will work
but disclaimer.h belongs here. Informix will not "bless" this method
officially.

Steve Goldberg
Landata RE-Source



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. negative npused

2. npused showing negative values

3. Negative npused values

4. Negative npused bug: When will it be fixed? (not before 7.13)

5. Info about "npused" bug

6. fix ANY negative credit

7. Need patch for bug fix for bug#56085 ref:Q244548

8. fix for BUG#599 & BUG 606

9. BUG??? NOT LIKE double negative

10. HELP ME- I AM IN A FIX!!!!

11. I am in a fix. Please Help Me.

12. Bug in SQL or am I wrong?


 
Powered by phpBB® Forum Software