Table CTL_PURGE_HISTORY
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
- For Microsoft SQL Server, varchar/nvarchar in the Data Type column 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.) THIS BULLET WILL DISPLAY ONLY IN THE PE MSSQL PDM.
Contents
Description
This table provides information about the execution history of Job_MaintainGIM as it pertains to purge.
Column List
Column | Data Type | P | M | F | DV |
---|---|---|---|---|---|
JOB_ID | varchar(64) | X | |||
JOB_VERSION | varchar(64) | ||||
TABLE_NAME | varchar(255) | X | |||
PURGE_MAX_TIME | timestamp(3) | ||||
PURGE_MAX_TS | integer | X | |||
PURGE_START_TIME | timestamp(3) | ||||
PURGE_END_TIME | timestamp(3) | ||||
ROW_COUNT | integer | ||||
CREATED_TS | integer | 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 |
Subject Areas
References
The summary List of References will include the following entries for this table or view:
There are no references from this table/view.