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

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.