GS_ADM_ILMOBJECTS

GS_ADM_ILMOBJECTS displays the brief information about all data objects to which ILM policies are applied and the corresponding policies, including the policy name, data object name, policy source, and policy enabling/disabling status. Only the system administrator can access this system view.

**Table 1** GS_ADM_ILMOBJECTS 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.
object_owner	character varying(128)	Name of the schema where the data object is located.
object_name	character varying(128)	Data object name.
subobject_name	character varying(128)	Data object partition name or level-2 partition name.
object_type	character varying(18)	Data object type. r: table p: partition s: level-2 partition
inherited_from	character varying(20)	Object whose policy is inherited by the current policy. The options are as follows: TABLE: table TABLE PARTITION: partition POLICY NOT INHERITED: not inherited
tbs_inherited_from	character varying(30)	TS whose policy is inherited by the current policy. The value is null in the current version.
enabled	character varying(7)	Specifies whether the policy is enabled for the current object.
deleted	character varying(7)	Specifies that the ILM policy on the object is deleted. If the partition or the policy on the partition is deleted, the record (ILMOBJ) is deleted.