How to test the connection to a db2 database

I need to test the connection to a db2 database.

With oracle databases I'd execute a 'select * from dual' in order to do this.

But dual is specific for oracle. Is t开发者_开发知识库here a similar canonical test sql statement for db2?

---

SELECT 1 FROM SYSIBM.SYSDUMMY1

cheaper then

SELECT CURRENT SQLID FROM SYSIBM.SYSDUMMY1

---

I ended up using

SELECT CURRENT SQLID FROM SYSIBM.SYSDUMMY1

which seems to work nice.

---

LIST DB DIRECTORY

or

LIST TABLES