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

GS_ILM_OBJECT

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.

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')

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')

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: enabled.
  • 1: disabled.