Get Table Size EDID4 on DB2

[Former Member]

Hi All,

Is there a way that clustered table EDID4 size can be calculated on SAP Level ? If not how is that we can calcualte the size from Database.

We are running on Linux Db2 Environment, Any SQL Query for the same ? Appreciate quick comments on this...

Thanks in Advance

Sudhir

[Former Member]

Try this command

db2 "select tabname,npages*16384/1024/1024 sizeMB from syscat.table"