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

disconnect command

P: n/a
Hi,
we are using db2 8.1 on Linux. I'd like to close all open connection at
a defined time point. Therfore I wrote a sql script including the command

disconnect all

or

release all

Unfortunately, a warning returns telling me that a database connection
doesn't exists. If I use the command

list applications

then I see a list of open connection.

Question: How can I close all these open connections?

Thanks, Toralf
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Toralf,

you can use the force application command, or it's new for V8
the quiesce command for instance or database with force connection.

regards,

Joachim Müller

"Toralf Kirsten" <tk******@izbi.uni-leipzig.de> schrieb im Newsbeitrag
news:c6**********@news.uni-leipzig.de...
Hi,
we are using db2 8.1 on Linux. I'd like to close all open connection at
a defined time point. Therfore I wrote a sql script including the command

disconnect all

or

release all

Unfortunately, a warning returns telling me that a database connection
doesn't exists. If I use the command

list applications

then I see a list of open connection.

Question: How can I close all these open connections?

Thanks, Toralf

Nov 12 '05 #2

P: n/a
Toralf,

you can use the force application command, or it's new for V8
the quiesce command for instance or database with force connection.

regards,

Joachim Müller

"Toralf Kirsten" <tk******@izbi.uni-leipzig.de> schrieb im Newsbeitrag
news:c6**********@news.uni-leipzig.de...
Hi,
we are using db2 8.1 on Linux. I'd like to close all open connection at
a defined time point. Therfore I wrote a sql script including the command

disconnect all

or

release all

Unfortunately, a warning returns telling me that a database connection
doesn't exists. If I use the command

list applications

then I see a list of open connection.

Question: How can I close all these open connections?

Thanks, Toralf

Nov 12 '05 #3

P: n/a
Disconnect and Release works on 'your current connections', not on the whole
db or instance (connections of others).
You may use Disconnect and Release when you work with type 2 connections.

PM

"Toralf Kirsten" <tk******@izbi.uni-leipzig.de> a écrit dans le message de
news:c6**********@news.uni-leipzig.de...
Hi,
we are using db2 8.1 on Linux. I'd like to close all open connection at
a defined time point. Therfore I wrote a sql script including the command

disconnect all

or

release all

Unfortunately, a warning returns telling me that a database connection
doesn't exists. If I use the command

list applications

then I see a list of open connection.

Question: How can I close all these open connections?

Thanks, Toralf

Nov 12 '05 #4

P: n/a
Disconnect and Release works on 'your current connections', not on the whole
db or instance (connections of others).
You may use Disconnect and Release when you work with type 2 connections.

PM

"Toralf Kirsten" <tk******@izbi.uni-leipzig.de> a écrit dans le message de
news:c6**********@news.uni-leipzig.de...
Hi,
we are using db2 8.1 on Linux. I'd like to close all open connection at
a defined time point. Therfore I wrote a sql script including the command

disconnect all

or

release all

Unfortunately, a warning returns telling me that a database connection
doesn't exists. If I use the command

list applications

then I see a list of open connection.

Question: How can I close all these open connections?

Thanks, Toralf

Nov 12 '05 #5

P: n/a
Joachim,
force application command works fine.
Thanks, Toralf
Joachim Mueller wrote:
Toralf,

you can use the force application command, or it's new for V8
the quiesce command for instance or database with force connection.

regards,

Joachim Müller

"Toralf Kirsten" <tk******@izbi.uni-leipzig.de> schrieb im Newsbeitrag
news:c6**********@news.uni-leipzig.de...
Hi,
we are using db2 8.1 on Linux. I'd like to close all open connection at
a defined time point. Therfore I wrote a sql script including the command

disconnect all

or

release all

Unfortunately, a warning returns telling me that a database connection
doesn't exists. If I use the command

list applications

then I see a list of open connection.

Question: How can I close all these open connections?

Thanks, Toralf


Nov 12 '05 #6

P: n/a
Joachim,
force application command works fine.
Thanks, Toralf
Joachim Mueller wrote:
Toralf,

you can use the force application command, or it's new for V8
the quiesce command for instance or database with force connection.

regards,

Joachim Müller

"Toralf Kirsten" <tk******@izbi.uni-leipzig.de> schrieb im Newsbeitrag
news:c6**********@news.uni-leipzig.de...
Hi,
we are using db2 8.1 on Linux. I'd like to close all open connection at
a defined time point. Therfore I wrote a sql script including the command

disconnect all

or

release all

Unfortunately, a warning returns telling me that a database connection
doesn't exists. If I use the command

list applications

then I see a list of open connection.

Question: How can I close all these open connections?

Thanks, Toralf


Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.