By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,077 Members | 1,790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,077 IT Pros & Developers. It's quick & easy.

Simple FORCE APPLICATION question....

P: n/a
FORCE APPLICATION command is valid only at the 'instance' level. Why
is this so? An instance may contain many databases. So, what command
do I give if I want to force applications from a particular database.
Interestingly, LIST APPLICATIONS command does have a 'FOR DATABASE'
option which means that I can find the list of applications for a
particular database, but have no option to Force all the applications
for that database. I have to note down all the application handles for
that database from List Applications command and then explicitly
specify all those application handles in Force Application command.

Is my understanding correct?

TIA
Raquel.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Raquel <ra****************@yahoo.com> wrote:
FORCE APPLICATION command is valid only at the 'instance' level. Why
is this so? An instance may contain many databases. So, what command
do I give if I want to force applications from a particular database.
Interestingly, LIST APPLICATIONS command does have a 'FOR DATABASE'
option which means that I can find the list of applications for a
particular database, but have no option to Force all the applications
for that database. I have to note down all the application handles for
that database from List Applications command and then explicitly
specify all those application handles in Force Application command.


On Unix, you can easily force all applications like this:

for i in `db2 list applications | awk '$5 = "<db-name>" {print $3}'`; do db2
"force application ($i)"; done

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2

P: n/a
Good question. I heard this complain a couple of times.
DB2 UDB V8.1 introduce a new command - QUIESCE command - you can force all
users off an instance or a database and put it into a quiesced mode for
database maintenance activities.
QUIESCE DATABASE <db_alias> ....

"Raquel" <ra****************@yahoo.com> wrote in message
news:9a*************************@posting.google.co m...
FORCE APPLICATION command is valid only at the 'instance' level. Why
is this so? An instance may contain many databases. So, what command
do I give if I want to force applications from a particular database.
Interestingly, LIST APPLICATIONS command does have a 'FOR DATABASE'
option which means that I can find the list of applications for a
particular database, but have no option to Force all the applications
for that database. I have to note down all the application handles for
that database from List Applications command and then explicitly
specify all those application handles in Force Application command.

Is my understanding correct?

TIA
Raquel.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.