Difference between revisions of "Content Manager OnDemand Database Tables"

m
Minor tweaking to structure
m (Corrected capitalization of IBM CMOD Sytem Load table - date fields.)
m (Minor tweaking to structure)
Line 1: Line 1:
{{TOCright}}
{{TOCright}}


= CMOD Database Tables =
= IBM CMOD Internal Database Tables =


This article is a reference of the contents of database tables inside Content Manager OnDemand.  The data on this page is to be considered informational, and may change from version to version, platform to platform.  There are also constraints on some fields and values, meaning that unless you fully understand how the values in specific fields work, you may combine features or options that are NOT compatible with each other, leading to unexpected, erroneous, or unintended behavior, up to and including problems with stability and/or reliability, and/or data loss.  Use this information at your own risk.
This article is a reference of the contents of database tables inside Content Manager OnDemand.  The data on this page is to be considered informational, and may change from version to version, platform to platform.  There are also constraints on some fields and values, meaning that unless you fully understand how the values in specific fields work, you may combine features or options that are NOT compatible with each other, leading to unexpected, erroneous, or unintended behavior, up to and including problems with stability and/or reliability, and/or data loss.  Use this information at your own risk.
Line 367: Line 367:




= System Load Application Group =
= SA2 - IBM CMOD System Load Table =
The IBM CMOD System Load Application Group contains information on loads into the server - and while this is convenient in itself, it's especially useful for running quick reports.  The System Load table is named SA#, starting with SA2.
The IBM Content Manager OnDemand System Load Application Group contains information on loads into the server - and while this is convenient in itself, it's especially useful for running quick reports.  The System Load table is named SA#, starting with SA2.


=== System Load - ARCHIVE.SA2 ===
{| class="wikitable" style="text-align:center;"
{| class="wikitable" style="text-align:center;"
|+ IBM CMOD System Load Table
|+ IBM CMOD System Load Table Structure
!Column Name
!Column Name
!Type
!Type
Line 471: Line 470:
|}
|}


=== SA2.Index_Type ===
=== SA2 Index_Type Field ===
The Index_Type field in the IBM CMOD System Load table describes the type of indexer that was used to extract the metadata from the document that was being loaded.
The Index_Type field in the IBM CMOD System Load table describes the type of indexer that was used to extract the metadata from the document that was being loaded.