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.

Copyright© 2019 HCL Technologies Limited