zOs/SQL/ADBCLEAN
select 'ADBCHK ', count(*) from adb.ADBCHK 00010000
union all select 'ADBCHKPT', count(*) from adb.ADBCHKPT 00020000
union all select 'ADBHOLD ', count(*) from adb.ADBHOLD 00030000
union all select 'ADBPART ', count(*) from adb.ADBPART 00040000
; 00050000
delete from adb.ADBCHKPT where timestmp < current timestamp - 10 days 00060001
; 00061001
select 'ADBCHK ', count(*) from adb.ADBCHK 00070001
union all select 'ADBCHKPT', count(*) from adb.ADBCHKPT 00080001
union all select 'ADBHOLD ', count(*) from adb.ADBHOLD 00090001
union all select 'ADBPART ', count(*) from adb.ADBPART 00100001
; 00110001
commit 00120002
; 00130001