My account Book a demo
IBM Db2 Data Dictionary Query Toolbox

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

Article for: SQL Server Oracle database Amazon Redshift PostgreSQL MySQL MariaDB

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

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
0
There are no comments. Click here to write the first comment.