1,126
edits
Difference between revisions of "Content Manager OnDemand Database Tables"
Content Manager OnDemand Database Tables (view source)
Revision as of 20:37, 30 May 2016
, 20:37, 30 May 2016Second phase of ARSAG table update.
(First Draft of ARSAG table information.) |
(Second phase of ARSAG table update.) |
||
| Line 45: | Line 45: | ||
|SID||1,80,88,837||Integer||The Storage Set ID Number. A unique integer is defined for each new Storage Set defined in the Administrative Client. | |SID||1,80,88,837||Integer||The Storage Set ID Number. A unique integer is defined for each new Storage Set defined in the Administrative Client. | ||
|- | |- | ||
|EXPIRE_TYPE | |EXPIRE_TYPE||x'44', x'4C', x'53'||HexChar||The Expiration Type for the Application Group: | ||
* x'44' = "D" = Document | |||
* x'4C' = "L" = Load | |||
* x'53' = "S" = Segment | |||
|- | |- | ||
|SEG_ROWS | |SEG_ROWS||2500000,10000000||Integer||Maximum number of rows per database table (aka Segment). | ||
|- | |- | ||
|SEG_ID | |SEG_ID||1,2,3,1000||Integer||Used as a counter for the next Segement (aka Database Table) number. | ||
|- | |- | ||
|OBJ_SIZE | |OBJ_SIZE||10000,50000||Integer||Maximum Object Size per compressed object loaded into the Application Group. | ||
See [[ARS0141E]] for information on tuning Compressed Object Sizes in CMOD. | |||
|- | |- | ||
|TYPE | |TYPE | ||
|- | |- | ||
|UPD_USERID | |UPD_USERID||ADMIN||String||The UserID of the last user to perform an update to the Application Group. | ||
|- | |- | ||
|UPD_DATE | |UPD_DATE||06/21/2015 08:15||Date||The date of the last update to the Application Group configuration. | ||
|- | |- | ||
|LAST_DOC_DATE | |LAST_DOC_DATE||15727||Integer||The numeric internal date of the oldest document that exists in the Application Group. Deprecated in CMOD v9.0. | ||
|- | |- | ||
|MIGR_SRVR_STR | |MIGR_SRVR_STR | ||
| Line 67: | Line 71: | ||
|DATABASE_NAME | |DATABASE_NAME | ||
|- | |- | ||
|SM_CACHE_RES | |SM_CACHE_RES||-1,90,365,2557||Integer||Duration to cache Resource Groups in Content Manager OnDemand. | ||
|- | |- | ||
|FTI_SERVER | |FTI_SERVER||?||String||String that defines configuration data for Full Text Indexing. | ||
|- | |- | ||
|UPD_DT | |UPD_DT||2015-06-21 08:15:05.385839||Database Date||Date of last update using the internal database date format, introduced in CMOD v9.0. | ||
|- | |- | ||
|LAST_DOC_DT | |LAST_DOC_DT||2016-04-14 17:38:30.285285||Database Date||Date of oldest document that exists in the Application Group. Introduced in CMOD v9.0. | ||
|- | |- | ||
|LAST_LOAD_DT | |LAST_LOAD_DT||2016-04-15 04:05:48.385921||Database Date||Date of the last load into the Application Group in the internal database date format. | ||
|- | |- | ||
|LAST_QUERY_DT | |LAST_QUERY_DT||2016-04-16 10:46:03.958183||Database Date||Date of the last query performed on the Application Group, in the internal database date format. | ||
|- | |- | ||
|LAST_RETR_DT | |LAST_RETR_DT||2016-04-15 04:07:19.727563||Database Date||Date of the last document retrieval from the Application Group in the internal database date format. | ||
|} | |} | ||
== arsagfld - Application Group Fields Table == | == arsagfld - Application Group Fields Table == | ||