I support DB2 LUW V9.7 databases.
I used to check last successful backup using "list history" and check for successful one.
One of my colleague shared below SQL which gives result very fast as it makes use of table function
Last successful DB backup
db2 "select SQLM_ELM_LAST_BACKUP from table(SNAPSHOT_DATABASE( cast( null as VARCHAR(255)), cast(null as int))) as ref"
I used to check last successful backup using "list history" and check for successful one.
One of my colleague shared below SQL which gives result very fast as it makes use of table function
Last successful DB backup
db2 "select SQLM_ELM_LAST_BACKUP from table(SNAPSHOT_DATABASE( cast( null as VARCHAR(255)), cast(null as int))) as ref"
No comments:
Post a Comment