How to detect a disconnected database ?

Massimiliano Campagnoli <[email protected]>
Newsgroups gmane.lisp.clsql.devel
Organization PAOLO ASTORI SRL
Message-ID <[email protected]> 
We are running a Lisp application connectetd to an IBM DB2 database via 
ODBC.
During the night the dbms runs an off-line backup so all applications 
(included the lisp one) are forced by the dbms to disconnect.
Unfortunately (CLSQL:CONNECTED-DATABASES) reports the the connection is 
still up and running which is not true any more after the backup.
So how can we detect that the connection is no more valid because the 
dbms dropped it and not because lisp called (CLSQL:DISCONNECT) ?
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.