How to check if a backup was executed in specific date
If you want to check if a backup was executed in the last X days, you can use the sysibmadm.snapdb
Perform the command below to check if a backup was executed in the last 5 days:
db2 "select 1 from sysibmadm.SNAPDB where LAST_BACKUP < current timestamp - 5 days"