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

GS_ILM

The GS_ILM system catalog provides the main information about the ILM policy, including the policy name, policy owner, policy type, policy ID, and policy status.

Table 1 GS_ILM columns

Name

Type

Description

pidx

integer

Policy sequence number, which is globally unique and starts with 1.

creator

oid

Policy owner.

name

name

Policy name. Currently, the policy name cannot be customized. The default name is p+pidx.

ptype

"char"

Policy type:

  • m: data movement.

flag

smallint

Value range:
  • 0: The policy is enabled.
  • 1: The policy is disabled.