DB2 10.5 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
DBADM authority
SQLADM 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

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	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