sysmaster question on blobspaces

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? tnx..... Doug McAllister FPI&BGT Informix Support Fidelity Investments

The blob page size is in sysdbstab in column prtpage in bytes so divide by 1024 to get KB. My dbsavail utility uses a stored procedure that runs this query: SELECT d.name, d.is_temp, d.is_blobspace, t.prtpage/1024, sum(chksize) size, sum(nfree) free FROM sysdbspaces d, syschunks c, sysdbstab t WHERE d.dbsnum = c.dbsnum AND c.dbsnum = t.dbsnum group by 1, 2, 3, 4 order by free; BTW my utility dbsavail produces just the report you are building. There are two versions of dbsavail. Dbsavail.sh parses onstat -d output using perl, sort, cut, and tee. Dbsavail.ec uses the stored procedure, which it adds to sysmaster on first execution, and is written in ESQL/C. Both are contained in my package utils_ak which is available from the IIUG Software Repository. Art S. Kagel 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? > > tnx..... > > Doug McAllister > FPI&BGT Informix Support > Fidelity Investments