Re: How to summarise blobpage stats?

Posted in 2004

David Williams — Mon, 19 Apr 2004 20:03:08 +0100 — source: Usenet: comp.databases.informix

"Andy Kent" <andykent.bristol1095@virgin.net> wrote in message news:ac5fb36.0404140154.70423510@posting.google.com... > Anyone? > > Surely this must be somewhere in sysmaster? > Nope..you would need to read each blob to get this kind of info. Look in $INFORMIXDIR/etc/sysmaster.sql for all the sysmaster stuff. > > andykent.bristol1095@virgin.net (Andy Kent) wrote in message news:<ac5fb36.0404080228.6b1dbe59@posting.google.com>... > > Is there some way I can get blob stats from sysmaster? We've got far > > too many blobs for oncheck -pB to produce anything short of a > > dangerously large output file. Basically I just want to see median, > > average and maximum sizes / fullness. > > > > REAL, LIVE email address. > > > > Andy Kent > > Bristol, UK

↪ replying to David Williams

Andy Kent — 20 Apr 2004 00:53:26 -0700 — source: Usenet: comp.databases.informix

A kind soul round these parts mailed me the suggestion to use length(blobcol). It's so blindingly simple it's brilliant ;-) Perhaps that's why they didn't feel any need to put this info in sysmaster. Andy "David Williams" <djw@smooth1.fsnet.co.uk> wrote in message news:<c617p1$f77$1@newsg1.svr.pol.co.uk>... > "Andy Kent" <andykent.bristol1095@virgin.net> wrote in message > news:ac5fb36.0404140154.70423510@posting.google.com... > > Anyone? > > > > Surely this must be somewhere in sysmaster? > > > > Nope..you would need to read each blob to get this kind of info.