Hello,



I was starting my TSM maintenance script (TSM server 5.3.2 on AIX 5.3) with
the following sql query to make sure that the backups were finished. If the
backups are still running, the script is rescheduled 15 minutes later.



/* Maintenance script*/

select * from processes where process='Backup'
if(rc_ok) goto reschedule



/* Start maintenance if backups are finished */

...

exit



/* Reschedule the script if the backups are not yet finished */

reschedule:
delete schedule maitenance t=a
define schedule maintenance t=a cmd='run maintenance' startt=now+0:15 dur=15
duru=m per=1 peru=h
active=yes

One night, a large backup took place (a few TB) over the SAN and the
maintenance script started however. So the sql query did not detect the
running backups.

What sql query should be used to verify that no backups (LAN or SAN) are
currently running? Is there a better query on another table (sessions, ...)?


Thanks in advance for any suggestions!

best regards,

Kurt