disconnect command

[Toralf Kirsten]

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

[Joachim Mueller]

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

[Joachim Mueller]

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

[PM \(pm3iinc-nospam\) CGO]

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

[PM \(pm3iinc-nospam\) CGO]

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

[Toralf Kirsten]

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

[Toralf Kirsten]

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