Difference between revisions of "Content Manager OnDemand Database Tables"

Jump to navigation Jump to search

Content Manager OnDemand Database Tables (view source)

Revision as of 15:48, 17 March 2017

3,044 bytes added ,  15:48, 17 March 2017
Added descriptions to IBM CMOD System Load Log table.
m (Added notes about IBM CMOD OD77 Lite)
(Added descriptions to IBM CMOD System Load Log table.)
Line 370: Line 370:
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.
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.


{| class="wikitable" style="text-align:center;"
{| class="wikitable" style="text-align:left;"
|+ IBM CMOD System Load Table Structure
|+ IBM CMOD System Load Table Structure
!Column Name
!Column Name
Line 377: Line 377:
!Description
!Description
|-
|-
|LOAD_TIME||Integer||4||
|LOAD_TIME||Integer||4||Integer representing the UNIX timestamp for the load (unused in IBM CMOD V9.0+), see LOAD_TIME_DT below.
|-
|-
|APPLGRP_NAME||Varchar||60||
|APPLGRP_NAME||Varchar||60||Name of the Application Group the data was loaded into.
|-
|-
|APPL_NAME||Varchar||60||
|APPL_NAME||Varchar||60||Name of the Application the data was loaded into.  (Implies specific indexing and compression settings defined in the Application.)
|-
|-
|LOAD_ID||Varchar||100||
|LOAD_ID||Varchar||100||The IBM CMOD Load ID for the load.
|-
|-
|TOTAL_ELAPSED||Double||8||
|TOTAL_ELAPSED||Double||8||The elapsed time in seconds and fractions of a second for the entire load to complete.
|-
|-
|INDEX_ELAPSED||Double||8||
|INDEX_ELAPSED||Double||8||The elapsed time in seconds for the indexing portion of the load.
|-
|-
|TOTAL_DOCS||BigInt||8||
|TOTAL_DOCS||BigInt||8||The total number of documents inserted into the database in this load.
|-
|-
|TOTAL_PAGES||BigInt||8||
|TOTAL_PAGES||BigInt||8||The total number of pages in all documents loaded as part of this load. (Where supported.)
|-
|-
|DOC_COMP_TYPE||SmallInt||2||
|DOC_COMP_TYPE||SmallInt||2||Document Compression Type - see [[Content_Manager_OnDemand_Database_Tables#arsapp.doc_comp_type_.26_arsapp.res_comp_type_-_Data_compression_type|arsapp.doc_comp_type]]
|-
|-
|DOC_INPUT_SIZE||BigInt||8||
|DOC_INPUT_SIZE||BigInt||8||Input size in bytes of the file to be loaded.
|-
|-
|DOC_OUTPUT_SIZE||BigInt||8||
|DOC_OUTPUT_SIZE||BigInt||8||Size of the data stored in CMOD after compression.
|-
|-
|RES_TYPE||SmallInt||2||
|RES_TYPE||SmallInt||2||Describes the resource type.
|-
|-
|RES_RID||Integer||4||
|RES_RID||Integer||4||The Resource Identifier for the loaded document.  May be duplicated if the resources match a previous load.
|-
|-
|RES_COMP_TYPE||SmallInt||2||
|RES_COMP_TYPE||SmallInt||2||Describes the resource compression type - see [[Content_Manager_OnDemand_Database_Tables#arsapp.doc_comp_type_.26_arsapp.res_comp_type_-_Data_compression_type|arsapp.doc_res_type]]
|-
|-
|RES_INPUT_SIZE||BigInt||8||
|RES_INPUT_SIZE||BigInt||8||Resource size before compression.
|-
|-
|RES_OUTPUT_SIZE||BigInt||8||
|RES_OUTPUT_SIZE||BigInt||8||Resource size stored after IBM CMOD compression.
|-
|-
|LOAD_AGID||Integer||4||
|LOAD_AGID||Integer||4||The numeric Application Group ID of the loaded file.  Included because Application Group names are allowed to be changed.
|-
|-
|LOAD_AID||Integer||4||
|LOAD_AID||Integer||4||The numeric Application ID used to load the file.  Included because Application names can be changed.
|-
|-
|LOAD_NAME||Varchar||11||
|LOAD_NAME||Varchar||11||The 'Doc_Name' portion of the Load ID.
|-
|-
|LOAD_PRI_NID||Integer||4||
|LOAD_PRI_NID||Integer||4||The Primary Node ID of the Load ID.
|-
|-
|LOAD_SEC_NID||Integer||4||
|LOAD_SEC_NID||Integer||4||The Secondary Node ID of the Load ID. (Deprecated and unused.)
|-
|-
|LOAD_START||BigInt||8||
|LOAD_START||BigInt||8||The start date and time of the load in UNIX timestamp format.
|-
|-
|LOAD_STOP||BigInt||8||
|LOAD_STOP||BigInt||8||The end date and time of the load in UNIX timestamp format.
|-
|-
|DOC_BGN_DATE||Integer||4||
|DOC_BGN_DATE||Integer||4||The earliest document date in the Load.
|-
|-
|DOC_END_DATE||Integer||4||
|DOC_END_DATE||Integer||4||The latest document date in the Load.
|-
|-
|INDEX_TYPE||SmallInt||2||
|INDEX_TYPE||SmallInt||2||Describes the indexer that was used to index the data in the load file.
|-
|-
|APPL_ID||Character||1||
|APPL_ID||Character||1||Unknown.
|-
|-
|LOCKDOWN||SmallInt||2||
|LOCKDOWN||SmallInt||2||Determines if the load was automatically held if Enhanced Retention Management is enabled.
|-
|-
|CFSOD||SmallInt||2||
|CFSOD||SmallInt||2||Describes if CFS:OD was used on the Load.
|-
|-
|INPUT_FILENAME||Varchar||1024||
|INPUT_FILENAME||Varchar||1024||The name of the file that was loaded.
|-
|-
|DOC_NAME||Varchar||11||
|DOC_NAME||Varchar||11||Internal object name of the log file.
|-
|-
|DOC_OFF||Integer||4||
|DOC_OFF||Integer||4||Internal offset inside the object name of the log file.
|-
|-
|DOC_LEN||Integer||4||
|DOC_LEN||Integer||4||Internal length of the log file inside the object.
|-
|-
|COMP_OFF||Integer||4||
|COMP_OFF||Integer||4||Internal compressed offset of the log file.
|-
|-
|COMP_LEN||Integer||4||
|COMP_LEN||Integer||4||Internal compressed length of the log file.
|-
|-
|ANNOT||Character||1||
|ANNOT||Character||1||Was there an annotation added to the log file?
|-
|-
|COMP_TYPE||Character||1||
|COMP_TYPE||Character||1||Compression type of the log file.
|-
|-
|RESOURCE||Integer||4||
|RESOURCE||Integer||4||Resource ID of the log file.
|-
|-
|PRI_NID||Integer||4||
|PRI_NID||Integer||4||Primary Node ID where the log file object is stored.
|-
|-
|SEC_NID||Integer||4||
|SEC_NID||Integer||4||Secondary Node ID - deprecated and unused.
|-
|-
|LOAD_TIME_DT||TimeStamp||10||
|LOAD_TIME_DT||TimeStamp||10||A timestamp of when the file was loaded in the database's internal date/time format.
|-
|-
|LOAD_START_DT||TimeStamp||10||
|LOAD_START_DT||TimeStamp||10||A timestamp of when the file started loading into CMOD, in the database's internal date/time format.
|-
|-
|LOAD_STOP_DT||TimeStamp||10||
|LOAD_STOP_DT||TimeStamp||10||A timestamp of when the file finished loading into CMOD, in the database's internal date/time format.
|-
|-
|DOC_BGN_DT||Date||4||
|DOC_BGN_DT||Date||4||A timestamp representing the earliest document date in the load, in the database's internal date format.
|-
|-
|DOC_END_DT||Date||4||
|DOC_END_DT||Date||4||A timestamp representing the latest document date in the load, in the database's internal date format.
|-
|-
|INPUT_FILE_SIZE||BigInt||8||
|INPUT_FILE_SIZE||BigInt||8||Size of the loaded file in bytes.
|}
|}


Retrieved from "https://CMOD.wiki/index.php?title=Special:MobileDiff/471"

Navigation menu