CODEWITHSUNDEEP
db2aix
mawburn
mawburn

Reputation: 2335

How can you determine how much disk space a DB2 table is using?

Is there a query that I could run on a DB2 instance running on AIX that would show much how much disk space a specific table is using?

DB2/AIX64 10.1.2

Upvotes: 0

Views: 2369

Answers (1)

mustaccio
mustaccio

Reputation: 18945

The simplest approach would be to query the ADMIN_GET_TAB_INFO table function:

SELECT 
 data_object_p_size + 
 index_object_p_size + 
 long_object_p_size + 
 lob_object_p_size + 
 xml_object_p_size 
FROM TABLE (SYSPROC.ADMIN_GET_TAB_INFO('YOURSCHEMA', 'YOURTABLE'))

Upvotes: 1

Related Questions