DB2 Version 9.7 for Linux, UNIX, and Windows

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

Example

Request information about the system.

SELECT * from SYSIBMADM.ENV_SYS_INFO

The following example is a sample 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

Table 1. Information returned by the ENV_SYS_INFO administrative view
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	Total number of physical CPUs on the system.
CONFIGURED_CPUS	INTEGER	Number of configured physical CPUs on the system.
TOTAL_MEMORY	INTEGER	Total amount of memory on the system (in megabytes).