Search code examples
db2db2-400db2-luw

Server name, Instance Name, DB name in DB2 via sql query

How to find out Server name, Instance Name, DB name in DB2 via sql query.

I was found it via shell scripts. Need via sql scripts.

Solution

  • A Db2 for LUW instance may have multiple database partitions / members which may reside on different hosts.

    SELECT 
  E.INST_NAME
, I.ID              AS MEMBER
, I.HOME_HOST       AS HOST
, CURRENT SERVER    AS DBNAME
FROM 
  TABLE (DB2_GET_INSTANCE_INFO (NULL, NULL, NULL, NULL, NULL)) I
, SYSIBMADM.ENV_INST_INFO E 
--WHERE I.ID = CURRENT MEMBER
;