Help Center/ GaussDB/ Centralized_8.x/ System Catalogs and System Views/ System Views/ OLTP Table Compression/ GS_ADM_ILMPOLICIES
Updated on 2024-06-03 GMT+08:00
View PDF

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