sysfeatures
The sysfeatures view provides general information about various features of the HCL OneDB™ 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 HCL OneDB 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. |