ENV_SYS_INFO view
The ENV_SYS_INFO view contains information about the current server.
Authorization: None required.
The following table describes the columns in the view. The system name is ENVSYSINFO. The schema is SYSIBMADM.
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
OS_NAME | OS_NAME | VARCHAR(256) Nullable
|
Operating system name. |
OS_VERSION | OS_VERSION | VARCHAR(256) Nullable
|
Operating system version. |
OS_RELEASE | OS_RELEASE | VARCHAR(256) Nullable
|
Operating system release. |
HOST_NAME | HOST_NAME | VARCHAR(256) Nullable
|
Name of the system. |
TOTAL_CPUS | TOTAL_CPUS | INTEGER Nullable
|
The maximum number of virtual processors defined within the LPAR configuration. |
CONFIGURED_CPUS | CONFIGCPUS | INTEGER Nullable
|
The number of virtual processors currently available to the partition. |
CONFIGURED_MEMORY | CONFIGMEM | BIGINT Nullable
|
Total amount of configured memory on the system, in megabytes. |
TOTAL_MEMORY | TOTAL_MEM | INTEGER Nullable
|
Total amount of memory on the system, in megabytes. |
Example
Return information about the current server.
SELECT * FROM SYSIBMADM.ENV_SYS_INFO