Simple DB2 Query for connection validation

Question

I'm looking for a simple DB2 query that can be used to test if a database connection in pool is still valid. It needs to be a generic query that would execute regardless of which databases exist.

For other database servers, I've used something like 'SELECT 1' or 'SELECT version();'

What would be an equivalent for DB2?

Thanks!

Answer 1

Try values 1.

Also, you can get the current date as

VALUES current date  

or

SELECT current date FROM sysibm.sysdummy1  

You can also get the version info as follows

SELECT service_level, fixpack_num, bld_level FROM TABLE (sysproc.env_get_inst_info()) as A;