GS_ADM_ILMDATAMOVEMENTPOLICIES

GS_ADM_ILMDATAMOVEMENTPOLICIES displays the data movement summary of ILM policies, including the policy name, action type, and conditions. Only the system administrator can access this system view.

**Table 1** GS_ADM_ILMDATAMOVEMENTPOLICIES 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.
action_type	character varying(11)	Action type. The current version supports only compression.
scope	character varying(7)	Scope. In the current version, only rows are supported.
compression_level	character varying(30)	Compression level. This parameter is available when the action type is compression.
tier_tablespace	character varying(128)	Target space. This parameter is available only when the action type is migration. The value is null in the current version.
tier_status	character varying(9)	Specifies whether the target space is read-only. The value is null in the current version.
condition_type	character varying(22)	Condition type. The current version supports only the last modification time.
condition_days	numeric	Number of days as a condition.
custom_function	character varying(128)	Name of a user-defined function. The value is null in the current version.
policy_subtype	character varying(10)	Policy subtype. The value is null in the current version.
action_clause	clob	Text that can be automatically executed during policy execution. The value is null in the current version.
tier_to	character varying(10)	Type of the target database to which data is migrated. The value is null in the current version.