Kish,
Try this, its a quick and dirty I just wrote for Unix
(not NT fluent):
db2 list applications show detail| grep -i
dbname|while read a b c junk
do
db2 -v "force application ($c)"
done
Make sense? Let me know if you have any questions.
Mike
--- kishore lingamallu <[EMAIL PROTECTED]> wrote:
>
>
> 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
>
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
