Use SYSDUMMY1 in DB2 to obtain the actual server name
- Read more about Use SYSDUMMY1 in DB2 to obtain the actual server name
- Log in or register to post comments
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