ENV_SYS_INFO administrative view - Retrieve information about the system
The ENV_SYS_INFO administrative view returns information about the system.
The schema is SYSIBMADM.
Authorization
One of the following authorizations is required:
- SELECT privilege on the ENV_SYS_INFO administrative view
- CONTROL privilege on the ENV_SYS_INFO administrative view
- DATAACCESS authority
- DBADM authority
- SQLADM authority
- ACCESSCTRL authority
- SECADM authority
Default PUBLIC privilege
In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.
Example
Request information about the system.
SELECT * from SYSIBMADM.ENV_SYS_INFO
The
following is an example of output from this query.
OS_NAME OS_VERSION OS_RELEASE HOST_NAME
--------...- ----------...- --------------...- ---------...-
WIN32_NT 5.1 Service Pack 1 D570
1 record(s) selected.
Output from this query (continued).
... TOTAL_CPUS CONFIGURED_CPUS TOTAL_MEMORY
... ----------- --------------- ------------
... 1 2 1527
Information returned
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 |