471,579 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,579 software developers and data experts.

Simple FORCE APPLICATION question....

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
2 5715
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
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.

Similar topics

6 posts views Thread by Ganesh | last post: by
1 post views Thread by Ramsey | last post: by
8 posts views Thread by Jim Butler | last post: by
5 posts views Thread by Mike L | last post: by
2 posts views Thread by comp.lang.php | last post: by
17 posts views Thread by Chris M. Thomasson | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.