473,382 Members | 1,313 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

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

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
3 2187
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

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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Konstantin Zakharenko | last post by:
Hello, Our QA team have running a lot of test scripts (for automated regression testing), they run them on the different databases (Oracle/MS SQL). Several of those tests are dependent on the...
0
by: pigeon | last post by:
SSL only works when ms sql server has "force encryption option" turned on... If I turn that off, and try to have the client software request encryption.. I get a ssl security error msg. The...
13
by: royaltiger | last post by:
I am trying to copy the inventory database in Building Access Applications by John L Viescas but when i try to run the database i get an error in the orders form when i click on the allocate...
32
by: Next | last post by:
Hi folks, Years ago, it occurred to me that a lot of the trouble of writing web browsers is caused by the upside-down arrangement of things: Javascript code exists inside a document, when...
3
by: Polaris | last post by:
Hi: Anyone can explain the concept of "System Level Applications"? An example? Thanks in Advance! Polaris
4
by: Rahul B | last post by:
Hi, When i do a "db2 list applications", i get the required applications with their ip addresses. However, some of the application Ids are ip addresses while some application Ids are...
2
by: paulquinlan100 | last post by:
Hi I'm using automation in excel to insert a lot of data into an Access DB. Its all working fine, apart from the fact that the data entry people occasionally put "n/a" in the cells instead of 0,...
2
by: =?Utf-8?B?QWxleCBNYWdoZW4=?= | last post by:
I want to be able to place ASP.NET applications inside each other (nested). The idea would be that I want to be able to have a docroot that contains the normal Web.config and App_Code directory,...
0
by: Josetta | last post by:
Here is something really bizarre that is happening...let me see if I can describe it. I have a report which has two locations on it. Primary Location and Secondary Location. I have both...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.