Morning,

I have been trying to find how get_dbsize_info function calculates db size. Does it read the catalog table and in this case how does it deal with the tables that haven't had runstats collected on? Or does it read file system?

Thank you.

8.2 aix 5.1

Seems it takes information from the TABLESPACE details. Like the USEDPAGES/PAGESIZE.

IIRC, it takes information from some SYSPROC table functions/Procedures ...

What I would suggest is to create a event monitor - write to table and capture the SQL Stmts and package sections when you execute your dbsize_info procedure ... If there are static SQLs in the event monirot output, join the table with SYSCAT.STATEMENTS table to find the statements ..

Apart from the SQL statements, there could be more processing done in the Stored Proc 'ouside SQL'

Cheers
Sathyaram