RE: update statistics
Seems I recall a bug some years back where occasionally
npused (number of pages used) got negative.
It should never happen when things
are working right, so zero rows updated is a good sign.
I suspect the SQL is a legacy of that ancient bug.
> -----Original Message-----
> From: David Kulkarni [SMTP:dnk61@yahoo.com]
> Sent: Wednesday, January 26, 2000 8:48 AM
> To: Informix
> Subject: update statistics
>
> Each night we run update statistics with the following
> sql statement:
>
> update systables set npused = nrows /
> (2020/(rowsize)+4)
> where npused < 0>
> and the result log file give us the following output:
>
> ============================
> Mon Jan 24 22:30:03 EST 2000
>
> 0 row(s) updated.
>
> ============================
>
> I am a UNIX SYS ADMIN and have recently taken on the
> task of DBA, and have realy very little knowledge of
> this. Can anyone tell me by looking at the statements
> above if this is correct and why is the output log
> giving us 0 row(s) updated after it ran for almost 8
> hours. Our database is 26gig strong, this in on
> informix version 5.10uc5 and hp-ux version 10.20. Any
> comments and/or suggestions are welcome.
>
> David Kulkarni
> dnk61@yahoo.com
>
>
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.com