Updated on 2024-06-03 GMT+08:00

GS_ADM_ILMPOLICIES

GS_ADM_ILMPOLICIES displays the brief information about an ILM policy, including the policy name, type, enabling status, disabling status, and deletion status. Only the system administrator can access this system view.

Table 1 GS_ADM_ILMPOLICIES columns

Name

Type

Description

policy_name

character varying(128)

Name of an ADO policy, which is automatically generated. The name format is P + Policy ID.

policy_type

character varying(13)

Policy type.

tablespace

character varying(30)

Tablespace name. This parameter has a value when the policy is created on a tablespace. The value is null in the current version.

enabled

character varying(6)

Specifies whether the policy is enabled.

deleted

character varying(7)

Specifies whether the policy is deleted.

node_name

name

Name of a data source node.