Is there a way to get table or tablespace size accurately via SQL for Db2 Z/OS? From whatever I can find, there has been information with regards to Db2 LUW but not for z/OS.
I found a article for z/OS, which as I understand cannot be done from SQL side(using Dbeaver or TOAD, etc) and requires going on the mainframe side as well.
Would be great to get some assistance here.
You may take a Look at SYSIBM.SYSTABLESPACE. If Statistics are accurate following Columns will help you: PGSIZE (SMALLINT Size of one Page in KB) NACTIVEF (FLOAT Number of active Pages) STATSTIME (Timestamp Time of RUNSTATS Util)