ADSM-L

Days from Last Backup using filespace header question

2006-10-28 06:58:49
Subject: Days from Last Backup using filespace header question
From: "Lamb, Charles P." <cplamb AT NPPD DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Sat, 28 Oct 2006 05:58:03 -0500
Hi....

We have been running the below script for checking when the server data
is backup for change management process.  We have noticed if the dsmc is
performed on the server via server scheduler everything is OK with the
filespace header information, however, if we schedule an incremental via
the TSM scheduler, the filespace header information is not updated.  Has
anyone run across this opportunity??  Thoughts??

select filespace_name as "Filespace", node_name as "Node Name",
days(current_date)-days(backup_end) as "Days from Last Backup" from
filespaces where (days(backup_end) < (days(current_date)-0)) and
(days(current_date)-9999) < (days(backup_end))