Hi

I am using this query for getting the capacity information.

SELECT tablespace.tablespace_id tablespaceid, tablespace.tablespace_name caption , tablespace.tablespace_type tablespacetype,tablespace.tablespace_state tablespacestate,tablespace.bufferpool_id, (tablespace.used_pages * page_size) usedspace,(tablespace.free_pages * page_size) freespace, (tablespace.total_pages * page_size) allocatedspace, page_size, tablespace.num_containers, tbs_contents_type FROM TABLE( SNAPSHOT_TBS_CFG('dwctrldb',-2) ) as tablespace

But the page_size is not getting returned there by the capacity is coming (-)

i am using UDB 8.1 on a windows box.

any idea why the page_size is coming (-)

last modif on this function is fp4
anyhow it does return page_size in higher version
db2admin:/cygdrive/c/workdir: db2 "select page_size from table(SNAPSHOT


PAGE_SIZE
--------------------
4096
4096
4096
32768