The system table SYSINFO.SCHEMASIZE contains size information about schemas.
SYSINFO.SCHEMASIZE
SCHEMANAME
CHAR(32)
Name of the schema
USEDSIZE
FIXED(20)
Space used for tables and indexes that belong to the schema (KB)
SCHEMAS
INDEXSIZE
TABLESIZE
