select  t.TABSCHEMA, t.TABNAME, t.CARD, t.FPAGES, t.NPAGES, ts.PAGESIZE, i.NLEAF
    ,st.DATA_OBJECT_PAGES, st.INDEX_OBJECT_PAGES, st.LOB_OBJECT_PAGES, st.LONG_OBJECT_PAGES, st.XDA_OBJECT_PAGES
    ,  sts.tbsp_page_size
    ,coalesce(st.DATA_OBJECT_PAGES, 0 )+coalesce(st.INDEX_OBJECT_PAGES, 0 )+coalesce(st.LOB_OBJECT_PAGES, 0 ) + coalesce(st.LONG_OBJECT_PAGES, 0 ) + coalesce(st.XDA_OBJECT_PAGES, 0 ) total
FROM syscat.tables t full outer join sysibmadm.snaptab st
	on t.tabschema = st.tabschema and t.tabname = st.tabname
	full outer join sysibmadm.snaptbsp sts
	on st.dbpartitionnum = sts.dbpartitionnum
	and  st.tbsp_id  =  sts.tbsp_id
	left join syscat.tablespaces ts on t.TBSPACEID = ts.TBSPACEID
    left join syscat.indexes i on i.TABNAME = t.TABNAME and i.TABSCHEMA = t.TABSCHEMA
	where t.tabschema = 'моя схема'
	and t.TABNAME =   'моя таблица'