Query table space:
SELECT SUM(currentperm)/1024/1024/1024 AS GB
FROM dbc.tablesize
WHERE tablename = 'table1' AND databasename = 'db1'
Query database size:
SELECT SUM(currentperm)/1024/1024/1024 AS SpaceUsed, SUM(maxperm)/1024/1024/1024 AS MaxSpace
FROM dbc.diskspace
WHERE databasename = 'db1'
List all tables space in a database:
SELECT tablename, SUM(currentperm)/1024/1024/1024 AS GB
FROM dbc.tablesize
WHERE databasename = 'db1'
GROUP BY 1
ORDER BY 2