Code:
- SELECT
- Table_Schema AS Table_Schema
- , Table_Name AS Table_Name
- , Number_Rows AS Number_Rows
- , Number_Deleted_Rows AS Number_Deleted_Rows
- , CAST(CASE
- WHEN ( Number_Deleted_Rows = 0 ) THEN 0
- WHEN ( Number_Rows = 0 ) AND ( Number_Deleted_Rows > 0 ) THEN 100.00
- ELSE ( 100.00 * Number_Deleted_Rows / ( Number_Rows + Number_Deleted_Rows ) )
- END
- AS DECIMAL( 5 , 2 )
- ) AS Percent_Deleted
- , Data_Size AS Data_Size
- , COALESCE( CHAR( DATE( Last_Used_Timestamp ) ), ' ' ) AS Last_Used
- , COALESCE( CHAR( DATE( Last_Change_Timestamp ) ), ' ' ) AS Last_Chgd
- , COALESCE( CHAR( DATE( Last_Save_Timestamp ) ), ' ' ) AS Last_Saved
- , COALESCE( CHAR( DATE( Last_Restore_Timestamp ) ), ' ' ) AS Last_Restored
- FROM qsys2.systablestat
- WHERE Table_Schema = 'MyLIB' -- Use your actual schema name here, etc.
-
|
|