Hello,
try this:

select * from sessions where upper(session_type)='NODE'
if (rc_ok) goto reschedule
...
...
...
...
exit
reschedule:
delete schedule BACKUP_SCRIPT_RETRY type=admin

Efim

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

--