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