SYS_ENVIRONMENT

Information on SESAM/SQL's operating system environment Created for maintenance purposes, specifically after a live migration.

Column name	Data type	Contents
INFO_TIMESTAMP	TIMESTAMP (3)	Time of the information (after a live migration, this is the time the live migration took place, otherwise it is a time in the initialization phase of the DBH)
HW_TYPE	CHAR (8)	Hardware type of the current system
OS_VERSION	CHAR (12)	Name and version of the BS2000 operating system
MAIN_MEMORY	INTEGER	Size of the BS2000 main memory in MB
NUMBER_OF_CPU_ MAX	INTEGER	Maximum number of BS2000 CPUs
NUMBER_OF_CPU_ ACTIVE	INTEGER	Number of active BS2000 CPUs
HOST_NAME	CHAR (8)	Host name

Table 115: SYS_ENVIRONMENT view of the SYS_INFO_SCHEMA