GS_ILM_OBJECT

0: The object compression policy is enabled.
1: The object compression policy is disabled.
2: The object compression policy is enabled, and a full table scan is completed during the last compression scheduling.

GS_ILM_OBJECT records the relationships between data objects and policies as well as the scheduling information of policies on the data objects. When a policy is set for a partitioned table, this catalog generates an independent record for each partition or subpartition.

**Table 1** GS_ILM_OBJECT columns
Name	Type	Description
pidx	integer	Policy ID.
objoid	oid	OID of a logical data object which has a partitioned table and partitions with level-2 partitions.
dataobjoid	oid	OID of a physical data object, which is the entity that needs to execute the policy and the leaf of the tree-level partition relationship.
objtype	"char"	Current data object type. The options are as follows: Table ('r') Partition ('p') Level-2 partition ('s')
origobjoid	oid	OID of the original object that defines the policy.
origobjtype	"char"	Type of the original data object that defines the policy. The options are as follows: Table ('r') Partition ('p') Level-2 partition ('s')
lastchktime	timestamp with time zone	Time of the last ADO task.
lastexetime	timestamp with time zone	Time of the last ADO job.
roundcnt	smallint	Number of successful rounds.
failcnt	smallint	Number of failures.
lastjobstatus	"char"	Execution status of the last job.
lastroundstarttime	timestamp with time zone	Start time of the full table scan.
lastjobblkid	bigint	ID of the block that has been processed by the job last time.
flag	smallint	Value range: 0: The object compression policy is enabled. 1: The object compression policy is disabled. 2: The object compression policy is enabled, and a full table scan is completed during the last compression scheduling.
lasthashbktpos	ARRAY	Records the last compression position of the previous compression scheduling by storing two values: [bucketid, blockid].