SQL - show count of deleted records in files/library

By kimot, 27 December, 2022
SELECT data_size, system_table_name, system_table_schema, number_rows, number_deleted_rows                                                 
FROM QSYS2.SYSTABLESTAT                                      
WHERE system_table_schema = 'some_library'                     
ORDER BY number_deleted_rows DESC