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

Can we issue the "force applications" command from within a sql call?

P: n/a
Connected to BD2 8.2 via JDBC, can we force an application off the
database?

We know we can use the snapshot functions to get a view over connected
users, that works find through a standard SQL call. Now I'd like to
select one of those users and force it off. You can imagine the simple
GUI action, select connected user - right-click - force - confirm and
bang, the user's off.

It's that last bit I'm having trouble with. I haven't yet identified a)
whether I can issue the command b) what command it would be and c) how
best to call that command.

Any advice on these will be greatly appreciated.

Mark

Sep 6 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
marklawford wrote:
Connected to BD2 8.2 via JDBC, can we force an application off the
database?

We know we can use the snapshot functions to get a view over connected
users, that works find through a standard SQL call. Now I'd like to
select one of those users and force it off. You can imagine the simple
GUI action, select connected user - right-click - force - confirm and
bang, the user's off.

It's that last bit I'm having trouble with. I haven't yet identified a)
whether I can issue the command b) what command it would be and c) how
best to call that command.
I don't think there is a built-in SQL API. If it does exist (a lot was
added in DB2 9) is ought to be part of the sysproc.admin_cmd() procedure
interface.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 6 '06 #2

P: n/a

Thanks, Serge. That does give me exactly what I want... but not until
v9.

Still, it's good to know it's around for the future.

Serge Rielau wrote:
marklawford wrote:
Connected to BD2 8.2 via JDBC, can we force an application off the
database?

We know we can use the snapshot functions to get a view over connected
users, that works find through a standard SQL call. Now I'd like to
select one of those users and force it off. You can imagine the simple
GUI action, select connected user - right-click - force - confirm and
bang, the user's off.

It's that last bit I'm having trouble with. I haven't yet identified a)
whether I can issue the command b) what command it would be and c) how
best to call that command.
I don't think there is a built-in SQL API. If it does exist (a lot was
added in DB2 9) is ought to be part of the sysproc.admin_cmd() procedure
interface.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 6 '06 #3

P: n/a
marklawford wrote:
Thanks, Serge. That does give me exactly what I want... but not until
v9.

Still, it's good to know it's around for the future.

Serge Rielau wrote:
>marklawford wrote:
>>Connected to BD2 8.2 via JDBC, can we force an application off the
database?

We know we can use the snapshot functions to get a view over connected
users, that works find through a standard SQL call. Now I'd like to
select one of those users and force it off. You can imagine the simple
GUI action, select connected user - right-click - force - confirm and
bang, the user's off.

It's that last bit I'm having trouble with. I haven't yet identified a)
whether I can issue the command b) what command it would be and c) how
best to call that command.
I don't think there is a built-in SQL API. If it does exist (a lot was
added in DB2 9) is ought to be part of the sysproc.admin_cmd() procedure
interface.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
For the record here is the link confirming support for FORCE_APPLICATION
through SQL in DB2 9:
http://publib.boulder.ibm.com/infoce...c/r0023574.htm

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 6 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.