Kish,
I don't have a script written to do this, but I think perhaps you could do
something like this (we're aix, thus my syntax):
Where xxx is the database name,
1) db2 list applications for database xxx > appl.for.xxx
2) grep xxx appl.for.xxx | while read a b c d e f ; do db2 "force application (
$c )";done
Step 1 creates a file with all of the application handles, which is what you
need to force individual tasks for the database.
Step 2 reads the file created from step 1, and then performs a force application
on each task.
This is a just theory on my part, as I have not tested it. You might want to
try it out on a development instance first!
HTH,
Judy
"kishore lingamallu" <[EMAIL PROTECTED]> on 08/28/2001 01:13:56 PM
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc: (bcc: Judy Kibler/Nashville)
Subject: Re: DB2EUG: Database connections termination
Does any body have suggestion in the following task?
I wan to kill all the connection of a specific database every night and
submit the UDB backup command on NT box.
We have more than one database under same instance. Force applications
doesn't have for database option. Is there is any of finding the list and
killing only related a specific database.
If some body has implemented and can share the script for NT/UNIX that will
be really appreciated.
Kish
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
