Simple DB2 Query for connection validation
Posted
by Eric Tuttleman
on Stack Overflow
See other posts from Stack Overflow
or by Eric Tuttleman
Published on 2010-05-05T16:48:32Z
Indexed on
2010/05/05
17:08 UTC
Read the original article
Hit count: 112
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!
© Stack Overflow or respective owner