Use SYSDUMMY1 in DB2 to obtain the actual server name

By Oscar_paredes on Mon, 11/18/2019 - 08:16
ibm db2
DB2
SQL Tips
Databases

By using the auxiliar table sysdummy1 you can query information about a server with DB2 installed.

Next query shows how to obtain the DB2 server name where the session is connected:

SELECT CURRENT SERVER
 FROM SYSIBM.SYSDUMMY1