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