1,126
edits
Difference between revisions of "Content Manager OnDemand Database Tables"
Content Manager OnDemand Database Tables (view source)
Revision as of 00:46, 7 February 2018
, 00:46, 7 February 2018IBM CMOD arsres resource table
m (Added IBM CMOD arsres table.) |
(IBM CMOD arsres resource table) |
||
| Line 378: | Line 378: | ||
|} | |} | ||
=arsres - IBM CMOD Document Resource Table= | = arsres - IBM CMOD Document Resource Table = | ||
One of the ways that Content Manager OnDemand acheives best-in-class compression is to perform de-duplication on loaded and indexed documents. These duplicate portions of documents are bundled into 'resources' which are stored separately from the data itself, referred to at the time a document is retrieved. | |||
{| class="wikitable" style="text-align:left;" | |||
|+ IBM CMOD Resource Table Structure | |||
!Column Name | |||
!Type | |||
!Description | |||
|- | |||
|RID||INTEGER||Unique Resource ID | |||
|- | |||
|AGID||INTEGER||Numeric Application Group ID that the resource belongs to - See: [[Content_Manager_OnDemand_Database_Tables#arsag_-_Application_Group_Table]] | |||
|- | |||
|PRI_NID||INTEGER||"Primary" Node ID where the resource is stored | |||
|- | |||
|SEC_NID||INTEGER||Deprecated | |||
|- | |||
|COMP_TYPE||CHARACTER||Compression Type - See: [[Content_Manager_OnDemand_Database_Tables#arsapp..2A_comp_type_-_Data_compression_type]] | |||
|- | |||
|ADD_DATE||BIGINT||Date the resource was added, as the number of seconds since the UNIX Epoch, midnight January 1st, 1970 UTC | |||
|- | |||
|COMP_SIZE||INTEGER||Compressed Size in bytes | |||
|- | |||
|DECOMP_SIZE||INTEGER||Decompressed Size in bytes | |||
|- | |||
|EXP_DATE||BIGINT||Expiration date of the resource, as the number of seconds since the UNIX Epoch, midnight January 1st, 1970 UTC | |||
|- | |||
|HOLD||SMALLINT||Is the resource part of a document being held by IBM CMOD Enhanced Retention Management? | |||
|- | |||
|ADD_DT||TIMESTAMP||Date & Time the resource was added in database-native time format. | |||
|- | |||
|EXP_DT||TIMESTAMP||Date & Time the resource is expected to expire, in database-native time format. This date will be updated as new loads are added to Content Manager OnDemand. | |||
|- | |||
|HASH_VAL||CHARACTER||Cryptographic Hash of the contents of the resource bundle. | |||
|- | |||
|CRYPT_STATUS||SMALLINT||Encryption status | |||
|} | |||
= SA2 - IBM CMOD System Load Table = | = SA2 - IBM CMOD System Load Table = | ||