Can a backup be stopped if not completed by a certain time?

2003-01-21 Thread David Browne
I run a pre and post command to stop and then restart applications on an NT
server in order to back it up.
The applications have to be brought up by a certain time in the morning.
Is there any way I can do a time check during  the backups or set a time
for the applications be restarted even if the backup has not completed?



Re: Can a backup be stopped if not completed by a certain time?

2003-01-21 Thread Cook, Dwight E
You can look into two server options that can cancel a session if is isn't
getting X amount of data transfered after Y period of time.
THROUGHPUTDATA- THRESHOLD Specifies a throughput threshold that a client
session must reach to prevent
being cancelled after the time threshold is reached.
THROUGHPUTTIME- THRESHOLD Specifies the time threshold for a session after
which it may be cancelled for
low throughput.

Say you have a 120 GB data base, and you expect 40 GB/hr transfer rate thus
it should finish in 3 hours...
throughputtimethreshold 180(minutes)
throughputdatathreshold 11650 (KB/sec)

So if my math is right, the above would cancel ANY client session after 3
hours IF it wasn't running at 40 GB/hr.

NOTE the ANY client session...
I don't know if there is anything on the client side to do the same
sort of thing.

Dwight E. Cook
Software Application Engineer III
Science Applications International Corporation
509 S. Boston Ave.  Suite 220
Tulsa, Oklahoma 74103-4606
Office (918) 732-7109



-Original Message-
From: David Browne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 7:33 AM
To: [EMAIL PROTECTED]
Subject: Can a backup be stopped if not completed by a certain time?


I run a pre and post command to stop and then restart applications on an NT
server in order to back it up.
The applications have to be brought up by a certain time in the morning.
Is there any way I can do a time check during  the backups or set a time
for the applications be restarted even if the backup has not completed?



Re: Can a backup be stopped if not completed by a certain time?

2003-01-21 Thread Alex Paschal
Hmm.  I'll have to look into those throughput params Dwight mentioned.

Anyway, if that won't solve the problem, you can most likely script a forked
backup and a sleep, with a test for the backup process to kill if necessary
at a certain time.  Or you can have 2 schedules, one that starts a backup in
the background and immediately exists, and another schedule (or AT command)
at a later time that runs a script to test for the dsmc process and kills it
if necessary and starts your apps.  Or, you can have an admin script on your
TSM server that, at a certain time, checks for any sessions belonging to the
client and cancels them (should be possible, but I don't use those admin
scripts - I just use scheduled/cron'd shell scripts, which is also very
do-able).  I'm assuming you want to kill the backup, then start the apps,
but these suggestions, except the canceling sessions, could be implemented
without killing the backup.

I hope this helps.

Alex Paschal
Freightliner, LLC
(503) 745-6850 phone/vmail

-Original Message-
From: David Browne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 7:33 AM
To: [EMAIL PROTECTED]
Subject: Can a backup be stopped if not completed by a certain time?


I run a pre and post command to stop and then restart applications on an NT
server in order to back it up.
The applications have to be brought up by a certain time in the morning.
Is there any way I can do a time check during  the backups or set a time
for the applications be restarted even if the backup has not completed?