Content Manager OnDemand Database Tables

From CMOD.wiki
Revision as of 20:37, 30 May 2016 by Jderrick (talk | contribs) (Second phase of ARSAG table update.)
Jump to navigation Jump to search

CMOD Database Tables

This article is a reference of the contents of database tables inside Content Manager OnDemand.

arsag - Application Group Table

This table contains all of the configuration data for Application Group Configuration in Content Manager OnDemand.

Field Sample Values Type Description
NAME System Log, AccountsPayable String Name of the Application Group. No special characters allowed.
DESCRIPTION System Log, Accounts Payable String Description of the Application Group.
AGID 5001,5938,6938 Integer Unique Numeric Identifier for Application Group. Used as a relation to ARSAGFLD, ARSAG2FLD, etc.
AGID_NAME SL,HGA,IBA String Three-character unique Alpha identifier for Application Group. Used in database ("Segment") names, as a filespace name in TSM, and in the cache filesystem.
DB_SEG 1,2,3,1000 Integer Used as a counter for the next database segment (table) number.
ANN_TYPE ? ? Determines the Annotation Type for an Application Group.
DB_EXP_DATE 90,365,2557 Integer Number of days to retain the documents loaded into this Application Group for. This field stores the Life of Data and Indexes value from the Administrative Client.
DB_MGRT_DATE 365,720,2557 Integer Duration after which the database segement (aka table) is migrated to secondary storage. Rarely

used.

SM_CACHE_DOC 90,366,720 Integer The period for which data should be cached after being loaded.
RESGRP 1,2,3,40,30000 Integer Used as a counter for the next Resource Group number.
LOAD_ID 1,359,497295 Integer Used as a counter for the next LoadID number.
LOG ? ? ?
LOAD_ID_SUFFIX FAA, GAA, HAA String Incremented for every 1 million LOAD_ID values. Incremented left-to-right from F to Z, A to Z, then A to Z until exhausted -- allowing for over 13.5 trillion loads in total.
MGRT_CACHE_DATE 30,45,90, 180 Integer Number of days after loading when the documents are migrated to secondary storage.
REIMPORT_EXP_DATE 30,90,180 Integer Number of days after which a re-imported database table is expired.
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 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 2500000,10000000 Integer Maximum number of rows per database table (aka Segment).
SEG_ID 1,2,3,1000 Integer Used as a counter for the next Segement (aka Database Table) number.
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
UPD_USERID ADMIN String The UserID of the last user to perform an update to the Application Group.
UPD_DATE 06/21/2015 08:15 Date The date of the last update to the Application Group configuration.
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
SM_CACHE_DELTA
DATABASE_NAME
SM_CACHE_RES -1,90,365,2557 Integer Duration to cache Resource Groups in Content Manager OnDemand.
FTI_SERVER ? String String that defines configuration data for Full Text Indexing.
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 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 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 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 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

This table contains a list of all of the fields defined in CMOD Application Groups.

Field Sample Values Type Description
AGID 5001, 5357, 3525 Integer Specifies the Application Group that the fields are related to. Relates to ARSAG.AGID.
Field 0,1,2,3,4,5 Integer Sequential number representing the field number, starting at 0.
Name RPT_ID,CUST_NUM String The text name of the field.
Type x'49', x'53', x'62' HexChar The hex values represent single-byte characters which describe a field type.
  • x'49' = "I" = Integer
  • x'53' = "S" = String
  • x'62' = "b" = Database Internal Date
Qual x'42', x'44' HexChar x'42 = "B", x'44' = "D"
Mask 1, 2, 32770 Integer This is a vectored field that stores the information in the field checkboxes in the Application Group Field Information Tab.
String_Type x'00', x'46', x'56' HexChar The hex values represent single-byte characters which describe a string type.
  • x'00' = None (Field is not a string type.)
  • x'46' = "F" = Fixed
  • x'56' = "V" = Variable
String_Len 0, 1, 2, 5, 10, 60 Integer The length of the string field. '0' if the field is a date or numeric field like Integer or Float.
String_Case x'4D', x'55' HexChar Represents a string field's case.
  • x'4D' = "M" = Mixed
  • x'55' = "U" = UPPER
  • x'4C' = "L" = lower
Leading $, #, <space>, - String A list of characters to remove from the FRONT of the string before inserting them into the database.
Strip $, #, <space>, - String A list of characters to remove from ANYWHERE in the string before inserting them into the database.
Trailing $, #, <space, -> String A list of characters to remove from the END of the string before inserting them into the database.
Map_Field NULL, -1, 0, 1, 25 NULL or Integer

arsagfld.mask

CAUTION: Changing these values without knowledge of how they inter-operate or conflict with each other is dangerous and not supported.

Checking the associated checkbox increases the value by the specified value below:

Value Checkbox Name Description
1 Indexed The Field Type is set to 'Indexed' when enabled, Filter when disabled.
2 Updatable The value for this field can be updated by users or administrators with sufficient privileges.
4 Segment Specifies that this field should be used to segment the database tables, for faster access. All Application Groups should have a Segment Field for maximum performance.
8 Application ID Field This field is used to identify different Applications Defined in the Application Group.
16 Expire Date This field is used to calculate the expiration date of the document when the Expiration Type is set to 'Document'.
32 Log Inserts the value of this field into the System Log for DocGets (retrievals) - message number 66
64 User Exit Sends the field name and value to a user exit.
128 Unknown Unknown
256 Partition Partitions the database based on this field. Only one field can be selected as the partition field.
512 Cluster Builds a cluster index if the database engine supports it.
1024 Reference Used by the OnDemand Distibution Facility to determine if the document should be distributed.
2048 Unknown Unknown
4096 Page Count This field contains the number of pages in the document.
8192 Document Size This field contains the size of the document in bytes.
16384 Unknown Unknown
32768 Unknown Unknown
65536 Lockdown This field contains the number of holds that exist for a document when CMOD Enhanced Retention Management is enabled.
131072 CFS-CMOD Required for interoperation with FileNet if your server is enabled with CFS:OD.
262144 Full Text Index Specifies that this field is indexed by the full-text indexing option for Content Manager OnDemand.
Retrieved from "https://CMOD.wiki/index.php?title=Content_Manager_OnDemand_Database_Tables&oldid=354"