Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
SELECT node_name,filespace_id,filespace_name,backup_start,backup_end FROM filespaces WHERE node_name NOT LIKE '%\\_REM\\_%' ESCAPE '\\' AND
((node_name NOT LIKE '%YEAR' AND node_name NOT LIKE '%MND') AND backup_end<current_timestamp-10 days) OR
(node_name LIKE '%\\_MND' ESCAPE '\\' AND backup_end<current_timestamp-35 days) OR
(node_name LIKE '%6MND' AND backup_end<current_timestamp-185 days) OR
(node_name LIKE '%YEAR' AND backup_end<current_timestamp-370 days)
Off topic, starting at 8.1.7, you could use Retention Sets to do a single ingest (daily incremental), but still keep monthly and yearly. More info: https://www.ibm.com/support/knowledgecenter/SSEQVQ_8.1.7/srv.common/r_wn_retention_817.htmlAs you can see we end nodes in YEAR/MND/6MND etc to indicate frequency for that backup.