Test database connection using C++

[Michel Esber]

Hello,

DB2 V7 FP14 running Linux.

Our application constantly tests whether the database connection is
still alive before sending new statements to the DB. A "values current
timestamp" statement is issued and, if there is no database exception,
the connection acquired is considered to be alive.

During one of my event monitors, this statement was by far the most
executed in the DB.

I personally dislike this solution. Just wondering if there is any
simpler solution / API for this. We are using C++.

TIA, Michel.

[Knut Stolze]

Michel Esber wrote:

Hello,

DB2 V7 FP14 running Linux.

Our application constantly tests whether the database connection is
still alive before sending new statements to the DB. A "values current
timestamp" statement is issued and, if there is no database exception,
the connection acquired is considered to be alive.

How about simply sending the intended SQL statement and then handling the
error afterwards if there is one?

The pinging is equally unreliable as the connection might break down between
the ping and the actual start of the execution of the SQL statement. So
even then you have to handle a broken connection as part of the usual error
handling.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Peri]

Michel,
You might want to look at the db2gDatabasePing API whose prerequisite
is connection.
For futher information
http://publib.boulder.ibm.com/infoce...n/r0001915.htm

Hello,

DB2 V7 FP14 running Linux.

Our application constantly tests whether the database connection is
still alive before sending new statements to the DB. A "values current
timestamp" statement is issued and, if there is no database exception,
the connection acquired is considered to be alive.

During one of my event monitors, this statement was by far the most
executed in the DB.

I personally dislike this solution. Just wondering if there is any
simpler solution / API for this. We are using C++.

TIA, Michel.