SQL

DELETE FROM log WHERE timestamp < (current date - 1 DAYS);

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  

SELECT object_schema, system_object_name, member_lock_type,
       lock_state, lock_scope, job_name
FROM QSYS2.OBJECT_LOCK_INFO
WHERE system_object_schema = 'some_library' ;

SELECT * 
FROM QSYS2.AUTOSTART_JOB_INFO;

WITH objs AS (SELECT path_name 
   FROM TABLE (QSYS2.IFS_OBJECT_STATISTICS(START_PATH_NAME => '/usr'))) 
SELECT * FROM objs, TABLE(QSYS2.IFS_OBJECT_PRIVILEGES(PATH_NAME)) WHERE authorization_name = 'user';

SELECT * FROM qsys2.sysschemas;

SELECT OBJNAME, OBJLIB, OBJTYPE, OBJCREATED, CREATED_SYSTEM, OBJTEXT  
FROM TABLE (QSYS2.OBJECT_STATISTICS('QGPL ','*FILE' ) ) AS X
WHERE DAYS(CURRENT DATE) - DAYS(OBJCREATED) > 1;