sysfeatures

The sysfeatures view provides general information about various features of the Informix® database server instance. The sysfeatures view is created from an internal table named syslicenseinfo, which is stored permanently on the disk. When the database server instances are initialized, the table is pre-allocated with a fixed size which allows tracking of 260 weeks of data. The data wraps every five years.

Metrics are sampled every 15 minutes and only the highest values during the particular week are stored. Each row in the table contains data only for the specific week it represents.

Column Type Description
week smallint The week that the information was recorded.
year smallint The year that the information was recorded.
version char(12) The Informix server version.
max_cpu_vps smallint The maximum number of CPU virtual processors.
max_vps smallint The maximum number of virtual processors.
max_conns integer The maximum number of concurrent physical connections on a standalone or high-availability cluster primary server instance.
max_sec_conns integer The maximum number of concurrent physical connections on an HDR secondary or RS secondary server instance.
max_sds_clones smallint The maximum number of SD secondary server instances connected to the primary server.
max_rss_clones smallint The maximum number of RS secondary server instances connected to the primary server.
total_size integer The maximum disk space allocated in all chunks (in megabytes).
total_size_used integer The maximum disk space used in all chunks (in megabytes).
max_memory integer The maximum memory allocated in all segments (in megabytes).
max_memory _used integer The maximum memory used in all segments (in megabytes).
is_primary integer Indicates whether the server was a primary server in a particular week; 1 = yes, 0 = no.
is_secondary integer Indicates whether the server was an HDR secondary server in a particular week; 1 = yes, 0 = no.
is_sds integer Indicates whether the server was an SD secondary server in a particular week; 1 = yes, 0 = no (not implemented; always 0).
is_rss integer Indicates whether the server was an RS secondary server in a particular week; 1 = yes, 0 = no.
is_er integer Indicates whether the server was an enterprise replication server in a particular week; 1 = yes, 0 = no.
is_pdq integer Indicates whether the PDQ feature was used on the server instance in the particular week; 1 = yes, 0 = no.

Copyright© 2019 HCL Technologies Limited