Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
Administrator's ReferenceThe includes comprehensive descriptions of HCL Informix® configuration parameters, the system-monitoring interface (SMI) tables in the sysmaster database, the syntax of database server utilities such as onmode and onstat, logical-log records, disk structures, event alarms, and unnumbered error messages.
Configuring and monitoring Informix®
The sysadmin DatabaseThe sysadmin database contains the tables that contain and organize the Scheduler tasks and sensors, store data collected by sensors, and record the results of Scheduler jobs and SQL administration API functions.
The Scheduler tablesThe Scheduler stores information about tasks and sensors in five tables in the sysadmin database: ph_task, ph_run, ph_group, ph_alert, and ph_threshold.
The ph_threshold TableThe ph_threshold table contains information about thresholds for Scheduler tasks.

The ph_threshold Table

The ph_threshold table contains information about thresholds for Scheduler tasks.

The ph_threshold table contains built-in thresholds that are associated with built-in tasks and sensors. For example, a threshold named COMMAND HISTORY RETENTION determines the length of time rows should remain in the command_history table.

Table 1. The ph_threshold table
Column	Type	Description
id	integer	Threshold ID.
name	char	The name of the threshold.
task_name	varchar	Scheduler task name associated with the threshold. Must be the same as a value in the tk_name column in the ph_task table.
value	lvarchar	The value of the threshold.
value_type	char	The data type of the value column: STRING NUMERIC NUMERIC(p,s)
description	lvarchar	A long description of the threshold.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.