Using the Syspartitionstat view, we can get the largest files on the system.

 

Sql to get the first 100 largest files on the system.

Select table_schema, table_name, table_partition, number_rows,

number_deleted_rows, data_size, variable_length_size, ‘

number_distinct_indexes

From qsys2.syspartitionstat

Order By data_size desc

Fetch 100 rows only.