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.
| 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. |
| node_name | name | Name of a data source node. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
