How to find operating system (OS) that IBM Db2 server runs on

This query returns information on operating system DB2 database runs on.

Query

select os_name,
    os_version,
    os_full_version,
    host_name
from sysibmadm.env_sys_info

Columns

  • os_name - name of the operating system
  • os_version - version of the operating system
  • os_full_version - operating system full version
  • host_name - host name

Rows

Query returns just one row

Sample results

0
There are no comments. Click here to write the first comment.