The ENV_SYS_INFO administrative view returns information about the system.
The schema is SYSIBMADM.
In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.
SELECT * from SYSIBMADM.ENV_SYS_INFO
OS_NAME OS_VERSION OS_RELEASE HOST_NAME
--------...- ----------...- --------------...- ---------...-
WIN32_NT 5.1 Service Pack 1 D570
1 record(s) selected.
... TOTAL_CPUS CONFIGURED_CPUS TOTAL_MEMORY
... ----------- --------------- ------------
... 1 2 1527
Column name | Data type | Description |
---|---|---|
OS_NAME | VARCHAR(256) | Name of the operating system. |
OS_VERSION | VARCHAR(256) | Version number of the operating system. |
OS_RELEASE | VARCHAR(256) | Release number of the operating system. |
HOST_NAME | VARCHAR(256) | host_name - Host name monitor element |
TOTAL_CPUS | INTEGER | The number of processors on this host. |
CONFIGURED_CPUS | INTEGER | Number of configured physical CPUs on the system. |
TOTAL_MEMORY | INTEGER | Total amount of memory on the system (in megabytes). |
OS_FULL_VERSION | VARCHAR(256) | os_full_version - Operating system full version monitor element |
OS_KERNEL_VERSION | VARCHAR(256) | os_kernel_version - Operating system kernel identifier monitor element |
OS_ARCH_TYPE | VARCHAR(256) | os_arch_type - Operating system architecture type monitor element |