WikiSysop: Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_PURGE_HISTORY |Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}} }} {{PDMTa..."

2022-06-29T04:30:44Z

Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_PURGE_HISTORY |Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}} }} {{PDMTa..."

New page

{{ArticleSimplifiedWikiEdit
|DisplayName=Table CTL_PURGE_HISTORY
|Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}}
}}
{{PDMTable
|tableName = CTL_PURGE_HISTORY
|shortDesc =
|tableDesc = This table provides information about the execution history of Job_MaintainGIM as it pertains to purge.
|subjectAreas =
|introduced =
|modified = 8.5.003 (in Oracle, fields with <tt>VARCHAR</tt> data types use explicit <tt>CHAR</tt> character-length semantics)
|discontinued =
|group =
|partitioned = yes
}}

{{PDMColumn
|colName = JOB_ID
|dataType_Ora = VARCHAR2(64 CHAR)
|dataType_MSSQL = varchar(64)
|dataType_Postgre = varchar(64)
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = ID that uniquely identifies the execution instance of the maintenance job.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = JOB_VERSION
|dataType_Ora = VARCHAR2(64 CHAR)
|dataType_MSSQL = varchar(64)
|dataType_Postgre = varchar(64)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The version of the job that purged data--for example, 8.1.000.10.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = TABLE_NAME
|dataType_Ora = VARCHAR2(255 CHAR)
|dataType_MSSQL = varchar(255)
|dataType_Postgre = varchar(255)
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = The name of the table from which data was purged.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = PURGE_MAX_TIME
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = 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.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = PURGE_MAX_TS
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = 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.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = PURGE_START_TIME
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The date and time when the maintenance job started the purge cycle.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = PURGE_END_TIME
|dataType_Ora = TIMESTAMP(3)
|dataType_MSSQL = datetime
|dataType_Postgre = timestamp(3)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The date and time when the maintenance job finished the purge cycle.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = ROW_COUNT
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The number of rows that was deleted in a given purge cycle.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = CREATED_TS
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = The UTC-equivalent value of the date and time at which the maintenance job started the purge cycle.
|introduced =
|modified =
|discontinued =
}}

{{PDMIndex}}
{{PDMIndexItem
|indexName = I_C_PURGE_H_CTS
|indexDesc = Improves purge performance.
|indexPresentInPartitioned = yes
|indexKey = CREATED_TS
|keyPresentInNonpartitioned = yes
|sort = Ascending
|unique =
|cluster =
}}

Documentation:PEC-REP/Library/PDMLibraryGIM/Table-CTL PURGE HISTORY - Revision history

WikiSysop: Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_PURGE_HISTORY |Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}} }} {{PDMTa..."