How to check db2 database connection

Question

I need to check the connection to the db2 database.

With oracle databases, I would do "select * from dual" to do this.

But the dual is specific to the oracle. Is there a similar canonical sql test statement for db2?

+2

Jens schauder Jan 19 '11 at 8:57

source share

3 answers

SELECT 1 FROM SYSIBM.SYSDUMMY1

cheaper than

SELECT CURRENT SQLID FROM SYSIBM.SYSDUMMY1

+4

ruruskyi Jan 24 '12 at 16:42

source share

 LIST DB DIRECTORY

or

 LIST TABLES

0

Ilya saunkin Jan 19 '11 at 9:03

source share

Jens schauder · Accepted Answer · 2011-01-19T10:45:30+0000

I ended up using

SELECT CURRENT SQLID FROM SYSIBM.SYSDUMMY1

which seems to have worked.