1,126
edits
Difference between revisions of "Content Manager OnDemand Database Tables"
Jump to navigation
Jump to search
m
Content Manager OnDemand Database Tables (view source)
Revision as of 18:02, 7 January 2020
, 18:02, 7 January 2020ibm cmod arsseg - fixed minor typos.
(Updated links to application group tables and cmod compression types) |
m (ibm cmod arsseg - fixed minor typos.) |
||
| Line 443: | Line 443: | ||
|CLOSED_DATE||BIGINT||The date the segment/table was closed, either by becoming full (ARSAG.MAX_ROWS) or being forced closed by the IBM CMOD arstblsp utility. | |CLOSED_DATE||BIGINT||The date the segment/table was closed, either by becoming full (ARSAG.MAX_ROWS) or being forced closed by the IBM CMOD arstblsp utility. | ||
|- | |- | ||
|REIMPORTED_DATE||BIGINT||The date the table was re-imported back into DB2 if it was migrated out to secondary (TSM) storage. | |REIMPORTED_DATE||BIGINT||The date the table was re-imported back into DB2 if it was migrated out to secondary (i.e. TSM) storage. | ||
|- | |- | ||
|LAST_UPDATE||BIGINT||The date of the last update to the database table (insert / delete / update to rows). | |LAST_UPDATE||BIGINT||The date of the last update to the database table (insert / delete / update to rows) if this configuration option is enabled. | ||
|- | |- | ||
|LAST_BACKUP||BIGINT||The date of the last backup in the segment field format. | |LAST_BACKUP||BIGINT||The date of the last backup in the segment field format. | ||
| Line 457: | Line 457: | ||
|UPD_ROWS||BIGINT||The number of rows updated in this table, by the [[arsdoc update]] command. | |UPD_ROWS||BIGINT||The number of rows updated in this table, by the [[arsdoc update]] command. | ||
|- | |- | ||
|DEL_ROWS||BIGINT||The number of rows deleted from this table, either by expiration processing, or the [[arsdoc delete]] | |DEL_ROWS||BIGINT||The number of rows deleted from this table, either by expiration processing, or the [[arsdoc delete]] command. | ||
|- | |- | ||
|MOD_ROWS||BIGINT||The number of rows modified in this table. | |MOD_ROWS||BIGINT||The number of rows modified in this table. | ||
|- | |- | ||
|MAX_ROWS||BIGINT||The maximum number of rows that this table | |MAX_ROWS||BIGINT||The maximum number of rows that this table should contain. This value is provided by ARSAG.MAX_ROWS at creation time. | ||
|- | |- | ||
|DATABASE_NAME||VARCHAR||On partitioned database systems, the name of the database this table is stored. | |DATABASE_NAME||VARCHAR||On partitioned database systems, the name of the database this table is stored in. | ||
|- | |- | ||
|FTI_SERVER||VARCHAR||The Full Text Indexing server that contains the full text index for documents contained in this table. | |FTI_SERVER||VARCHAR||The Full Text Indexing server that contains the full text index for documents contained in this table. | ||