Testing for a Connection

[Geoff]

Hello All,

After searching google groups and the web, there seems to be no good answer
to this but I thought I would ask anyway.

Is there a way to programmatically test for a db2 connection, similar to
'db2 get connection status'?

I can not even seem to programmatically direct the output of that command to
a file. Any ideas?

Thanks.

-g

[Knut Stolze]

Geoff wrote:

Hello All,

After searching google groups and the web, there seems to be no good
answer to this but I thought I would ask anyway.

Is there a way to programmatically test for a db2 connection, similar to
'db2 get connection status'?

You could issue a simple SQL query like:

VALUES (1)

to test if a connection exists.

I can not even seem to programmatically direct the output of that command
to a file. Any ideas?

I would simply use pipes - assuming that you have C code.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Geoff]

I like that except we have several type 2 connections running at the same
time. When a connect is issued multiple times, programmatically, eventually
the process has problems creating threads. There is plenty of memory left
and the error is, 'can not start thread'.

I was looking for some other way to test if a live db is there before
actually trying to connect.

-g

[Knut Stolze]

Geoff wrote:

I was looking for some other way to test if a live db is there before
actually trying to connect.

Unless you explicitly activate the database using the ACTIVATE DATABASE
command, the DB is not active if no connection (from any client) exists.
Hence, I'm not sure what kind of information you really want to have.
Maybe you want to know if the DB2 instance is started? Or is it really
DB-specific what you want to know?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany