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

Anyone?

Surely this must be somewhere in sysmaster?

andykent.bristol1095@virgin.net (Andy Kent) wrote in message news:<ac5fb36.0404080228.6b1dbe59@posting.google.c om>...
> 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

Anyone?

Surely this must be somewhere in sysmaster?


andykent.bristol1095@virgin.net (Andy Kent) wrote in message news:<ac5fb36.0404080228.6b1dbe59@posting.google.c om>...
> 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

Anyone?

Surely this must be somewhere in sysmaster?


andykent.bristol1095@virgin.net (Andy Kent) wrote in message news:<ac5fb36.0404080228.6b1dbe59@posting.google.c om>...
> 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

Andy Kent wrote:

> andykent.bristol1095@virgin.net (Andy Kent) wrote in message
> news:<ac5fb36.0404080228.6b1dbe59@posting.google.c om>...
>> 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.

Am thinking that repeap problem is repeating. But am scared to say in case
Litel is shoutiong at me.

--
Enor

"Andy Kent" <andykent.bristol1095@virgin.net> wrote in message
news:ac5fb36.0404140154.70423510@posting.google.co m...
> 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.c om>...
> > 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

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.co m...
> > Anyone?
> >
> > Surely this must be somewhere in sysmaster?
> >
>
> Nope..you would need to read each blob to get this kind of info.