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
精彩评论