Sysmaster - sysprofile - size of values

I have recently encountered some interesting problems with my remote monitoring software. My software is heavily reliant on the sysmaster database and I have observed that many figures show up as negative in sysmaster because they are in fact >2billion. The reason is quite obvious - sysmaster uses a 4 byte integer whereas the internal values are held as 8 byte integers. Can anyone who has Version 10 runing reassure me that this problem is fixed in IDS version 10? I normally workaround this problem with a periodic onstat -z but on one site I have a bufread rate of > 2billion in an 8 hour period. And that messes up caching rate calculations etc. regards Malcolm

mweallans@panacea.co.uk wrote: > I have recently encountered some interesting problems with my remote > monitoring software. My software is heavily reliant on the sysmaster > database and I have observed that many figures show up as negative in > sysmaster because they are in fact >2billion. The reason is quite > obvious - sysmaster uses a 4 byte integer whereas the internal values > are held as 8 byte integers. > > Can anyone who has Version 10 runing reassure me that this problem is > fixed in IDS version 10? > > I normally workaround this problem with a periodic onstat -z but on one > site I have a bufread rate of > 2billion in an 8 hour period. And that > messes up caching rate calculations etc. > > regards > > Malcolm > Have you tried UPDATE STATISTICS?