Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
  • DV = Default value
  • In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.)

Table CTL_PURGE_HISTORY

Description


In partitioned databases, this table is partitioned.


This table provides information about the execution history of Job_MaintainGIM as it pertains to purge.

Column List

Legend

Column Data Type P M F DV

JOB_ID

varchar(64) X

JOB_VERSION

varchar(64)

TABLE_NAME

varchar(255) X

PURGE_MAX_TIME

datetime

PURGE_MAX_TS

int X

PURGE_START_TIME

datetime

PURGE_END_TIME

datetime

ROW_COUNT

int

CREATED_TS

int X

JOB_ID

ID that uniquely identifies the execution instance of the maintenance job.

JOB_VERSION

The version of the job that purged data--for example, 8.1.000.10.

TABLE_NAME

The name of the table from which data was purged.

PURGE_MAX_TIME

The date and time, in the GMT time zone, that represent the highest timestamp value for the records that are deleted in a given purge cycle.

PURGE_MAX_TS

The UTC-equivalent value of the date and time that represents the highest timestamp value for the records that are deleted in a given purge cycle.

PURGE_START_TIME

The date and time when the maintenance job started the purge cycle.

PURGE_END_TIME

The date and time when the maintenance job finished the purge cycle.

ROW_COUNT

The number of rows that was deleted in a given purge cycle.

CREATED_TS

The UTC-equivalent value of the date and time at which the maintenance job started the purge cycle.


Index List

CODE U C Description

I_C_PURGE_H_CTS

Improves purge performance.

Index I_C_PURGE_H_CTS

Field Sort Comment
CREATED_TS Ascending

No subject area information available.

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 10 August 2017, at 06:44.