Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Views/ OLTP Table Compression/ GS_MY_ILMPOLICIES
Updated on 2025-08-19 GMT+08:00
View PDF

GS_MY_ILMPOLICIES

GS_MY_ILMPOLICIES displays the brief information about an ILM policy, including the policy name, type, enabling status, disabling status, and deletion status.

Table 1 GS_MY_ILMPOLICIES

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.
Parent topic: OLTP Table Compression