Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Catalogs/ OLTP Table Compression/ GS_ILM_TASKDETAIL
Updated on 2025-08-19 GMT+08:00
View PDF

GS_ILM_TASKDETAIL

The GS_ILM_TASKDETAIL system catalog records the evaluation result of a specified data object and policy.

Table 1 GS_ILM_TASKDETAIL columns

Name

Type

Description

pidx

integer

Policy ID.

objoid

oid

Data OID.

objtype

"char"

Data object type.

taskoid

bigint

OID of an ADO task.

evalresult

smallint

Evaluation result:

  • 0: SELECTED FOR EXECUTION. The evaluation is passed.
  • 1: PRECONDITION NOT SATISFIED. The condition is not met.
  • 2: JOB ALREADY EXISTS. The job already exists.

jobname

text

ADO job name generated after the evaluation is passed is joined with the jobname column in the GS_ILM_JOBDETAIL system catalog.
Parent topic: OLTP Table Compression