Re: sysmaster question on blobspaces

Doug McAllister wrote: > > Hi all... > > I am in the middle of creating a formatted report which shows, among > other things, amount of free space in a dbspace. I have noticed that the > numbers that get generated are all correct except for blobspaces. The > cause is that the syschunks table reports "chksize" as system pages but > reports "nfree" as blobpages. I can tell by "is_blobchunk" or > "is_blobspace" whether or not the dbspace is a blobspace or not. > However, I cannot find any column which tells me what the blobspace page > size is. I need the blobpage size to make the calculations work. > Any one know how to get this info? sysdbstab.bpagesize BTW sysdbspaces is a view on sysdbstab > > tnx..... > > Doug McAllister > FPI&BGT Informix Support > Fidelity Investments Vardan -- vaar@geocities.com