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.
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:
|
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:
|
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:
|
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot