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
