ENV_GET_SYS_INFO table function

9 9 9

ENV_GET_SYS_INFO table function

9 >>-ENV_GET_SYS_INFO--(--)--------------------------------------><
9

9 9

The schema is SYSPROC.

The ENV_GET_SYS_INFO table function returns information about the 9 system. 9 The function does not take any arguments.

The function returns a table as shown below.

9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9

Table 51. Information returned by the ENV_GET_SYS_INFO table function
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)	Name of the system.
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).

Example

Request information about the system. 9

   SELECT OS_NAME, HOST_NAME, TOTAL_CPUS,
9        CONFIGURED_CPUS, TOTAL_MEMORY
9      FROM TABLE(SYSPROC.ENV_GET_SYS_INFO()) AS SYSTEMINFO

9 The following is an example of output from this query. 9

OS_NAME   HOST_NAME   TOTAL_CPUS CONFIGURED_CPUS TOTAL_MEMORY
9 -------...---------...---------- --------------- ------------
9 AIX       kramer2              4               4         8192

9 Related reference 9

ENV_GET_INST_INFO table function

ENV_GET_PROD_INFO table function