WARNING: This set of views is for temporary use only until the next version that supports Content Manager tables. Applications should not presume that these views exist in every database and should consider that these tables may not be provided in future versions.
(C) Copyright International Business Machines Corporation 2003. All rights reserved.
U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
ACL related database tables and pre-configured settings
Item related database tables and pre-configured settings
This table stores system configuration parameters for the Content Manager
library server.
Column Name | Data Type | Attribute |
---|---|---|
LibraryServerID | INTEGER | NOT null |
LanguageCode | CHAR(3) | NOT null |
SysSegmentID | SMALLINT | NOT null |
SysSegmentThreshld | INTEGER | NOT null |
ACLBindingLevel | SMALLINT | NOT null |
LibraryACLCode | INTEGER | NOT null |
PubAccessEnabled | SMALLINT | NOT null |
DfltACLChoice | SMALLINT | NOT null |
SMSChoice | SMALLINT | NOT null |
TraceLevel | SMALLINT | NOT null |
MaxUsers | INTEGER | NOT null |
MaxUserAction | SMALLINT | NOT null |
CurrentUsers | INTEGER | NOT null |
MaxLogonRetry | SMALLINT | NOT null |
PasswordDuration | SMALLINT | 180 (days) |
SysAdminEventFlag | SMALLINT | NOT null |
SystemFlag | SMALLINT | NOT null |
DatabaseType | SMALLINT | NOT null |
MaxTxDuration | INTEGER | NOT null |
MaxResultSetSize | INTEGER | NOT null |
AllowTrustedLogon | SMALLINT | NOT null |
DocRoutingUpdate | INTEGER | NOT null |
DocRoutingFreq | SMALLINT | NOT null |
Platform | SMALLINT | NOT null |
SysTimeout | SMALLINT | NOT null |
TIEUserID | CHAR(32) | nullable |
TIEPassword | CHAR(72) FOR BIT DATA | nullable |
DatabaseName | VARCHAR(128) | NOT null |
DBSchemaName | VARCHAR(128) | NOT null |
TraceFileName | VARCHAR(128) | nullable |
EncryptionKey | VARCHAR(128) FOR BIT DATA | NOT null |
KeepTraceOpen | SMALLINT | NOT null |
MultipleTraceFiles | SMALLINT | NOT null |
MaxTraceFileSize | INTEGER | NOT null |
PathICMRoot | VARCHAR(128) | NOT null |
PathICMDLL | VARCHAR(128) | NOT null |
SuspendServerTime | TIMESTAMP | nullable |
RMStatusInterval | SMALLINT | NOT null |
RMStatusTimeout | SMALLINT | NOT null |
TIEInterval | SMALLINT0 | NOT null |
LSCurrentVersion | VARCHAR(128) | NOT null |
TraceUser | CHAR(32) |
|
Foreign Key = (LibraryACLCode) references ICMSTAccessCodes (ACLCODE) on delete restrict
Column Definitions
Implementation: When a user is logged on to ICM system, if the LanguageCode is not provided, the logon SP(TM) (ICMlogon) will extract LanguageCode from System Control table (ICMSTSYSCONTROL) as a default language and save it to both structures ICMUSERINFO_STRUCT and ICMSESSION_STRUCT. You can get the language code from the struct ICMUSERINFO_STRUCT returned by API ICMLogon for subsequent calls. If the language code is omitted, the ICM system (for each API documented) will provide it through the struct ICMSESSION_STRUCT at the time that the parameter language code is validated in the API level.
0 - 0x000000 ICMTRACE_OFF 1 - 0x000001 ICMTRACE_BASIC 2 - 0x000002 ICMTRACE_DETAILED 4 - 0x000004 ICMTRACE_DATA 8 - 0x000008 ICMTRACE_PERFORMANCE 16 - 0x000010 ICMTRACE_PARSEBUILD 32 - 0x000020 ICMTRACE_MEMDEBUG 256 - 0x000100 ICMTRACE_CACHE_TRACE 512 - 0x000200 ICMTRACE_CACHE_ALLOC 1024 - 0x000400 ICMTRACE_CACHE_MGT
Table 2. SystemFlag bit assignments
Bit | What the bit enables |
---|---|
0 | TIE is enabled. |
1 | EIP Advanced WF is enabled. |
2 | Information mining (IKF) is enabled. |
3 | LDAP is enabled. |
4 | Administrative Domain is enabled. |
5 | Database is enabled for Content Manager. |
6 | Database is enabled for EIP. |
This can "pause" the library server to stop all new transactions, and at the same time, allow transactions which are in progress to complete. When that time is greater than the current time, any new transactions are rejected. If an application is storing an object to a resource manager, those operations are allowed to complete as long as they do not exceed the time specified in MAXTXDURATION in ICMSTSYSCONTROL. After that time, any request to the library server is rejected. |
|Table 3. CM Pre-configured System Control Settings
Column Name | Value |
---|---|
LibraryServerID | 1 |
LanguageCode | ENU |
SysSegmentID | 1 |
SysSegmentThreshld | 0 |
ACLBindingLevel | 2 (mixed - item type and item) |
LibraryACLCode | 3 (PublicReadACL) |
PubAccessEnabled | 1 (enabled) |
DfltACLChoice | 0 (Item Type) |
SMSChoice | 0 |
TraceLevel | 0 |
MaxUsers | 0 |
MaxUserAction | 2 |
CurrentUsers | 0 |
MaxLogonRetry | 0 |
PasswordDuration | 180 (days) |
SysAdminEventFlag | 0 |
SystemFlag | 32 (2^5) |
DatabaseType | 0 (DB2) |
MaxTxDuration | 86400 |
MaxResultSetSize | 0 |
AllowTrustedLogon | 0 |
DocRoutingUpdate | 0 |
DocRoutingFreq | 10 |
Platform | %ICMCRLSDBPLATFORM% |
TIEUserID | %ICMCRLSDBUSER% |
TIEPassword | %ICMCRLSDBENCRYPTPWD% |
DatabaseName | %ICMCRLSDBDBNAME% |
DBSchemaName | %ICMCRLSDBSCHEMA% |
TraceFileName | %ICMCRLSDBTraceFileName% |
EncryptionKey | reserved |
KeepTraceOpen | 0 |
MultipleTraceFiles | 0 |
MaxTraceFileSize | 0 |
PathICMRoot | %ICMCRLSDBICMROOT% |
PathICMDLL | %ICMCRLSDBICMDLL% |
SuspendServerTime | NULL |
RMStatusInterval | 60 |
RMStatusTimeout | 15 |
TIEInterval | 0 |
LSCurrentVersion | 8.2.0.00 |
TraceUser | NULL |
This table maintains the administration domain identifier.
Column Name | Data Type | Attribute |
---|---|---|
DomainID | INTEGER | not null |
Column Definitions
Table 5. CM System-defined Administration Domain identifier
DomainID | DomainName* | DomainDesc* |
---|---|---|
0 | AdminDomain | ICM system reserved |
1 | SuperDomain | Super System Administration Domain. |
2 | PublicDomain | Public Domain. |
1000 | DefaultDomain | Default User Sub Domain. |
*For illustration only. Name and description are defined in the NLS Keywords table. |
This table maintains the unlimited number of CM privilege definitions,
including both CM System-defined and User-defined. All the
System-defined Privileges cannot be modified. Each privilege has a
system-generated unique code. Codes 0 to 999 are reserved to store CM
System-defined Privileges. For User-defined Privileges, 1000 and
up are open. When defining or updating Privilege Sets, this table can
be first queried to list all defined privileges. Applications can also
query this table at runtime to get the definitions of the connected
user's privileges and customize the application menu selections
specifically suitable for that user. Privilege name and description are
defined in the NLS Keywords Table (ICMSTNLSKEYWORDS).
Column Name | Data Type | Attribute |
---|---|---|
PrivDefCode | INTEGER | not null |
Column Definitions
This table maintains the Privilege Set definitions. A Privilege Set
consists of unlimited number of privileges. Each set is uniquely
identified by a CM system-generated code. Its set-member associations
are stored in the table ICMSTPrivSets. Privilege set name and
description are defined in the NLS Keywords Table (ICMSTNLSKEYWORDS).
Column Name | Data Type | Attribute |
---|---|---|
PrivSetCode | INTEGER | not null |
Column Definitions
This table maintains associations of CM Privileges with the Privilege
Sets. Rows with the same PrivSetCode form a Privilege Set. Rows
in this table can only be deleted, not updated.
Column Name | Data Type | Attribute |
---|---|---|
PrivSetCode | INTEGER | not null |
PrivDefCode | INTEGER | not null |
Unique Index = (PrivSetCode ascending, PrivDefCode ascending)
Foreign Key = PrivSetCode references ICMSTPrivSetCodes (PrivSetCode) on delete cascade Foreign Key = PrivDefCode references ICMSTPrivDefs (PrivDefCode) on delete restrict
Column Definitions
This table maintains associations of CM Privilege sets with the
domain. Rows with the same DomainID form a domain's privilege
set. Rows in this table can only be deleted, not updated.
Column Name | Data Type | Attribute |
---|---|---|
DomainID | INTEGER | not null |
PrivSetCode | INTEGER | not null |
Unique Index = (DomainID ascending, PrivSetCode ascending)
Foreign Key = DomainID references ICMSTAdminDomains (DomainID) on delete restrict Foreign Key = PrivSetCode references ICMSTPrivSetCodes (PrivSetCode) on delete cascade
Column Definitions
This table maintains the Privilege Group definitions. A Privilege Group consists of one or more privileges. Each group is uniquely identified by a CM system-generated code. Its group-member associations are stored in the table ICMSTPrivGroups. There is no direct relationship between privilege set and privilege group. Privilege group name and description are defined in the NLS Keywords Table (ICMSTNLSKEYWORDS).
Privilege Group versus Privilege Set
Column Name | Data Type | Attribute |
---|---|---|
PrivGroupCode | INTEGER | not null |
Column Definitions
This table maintains associations of CM Privileges with the Privilege
Groups. Rows with the same PrivGroupCode form a Privilege Group.
Rows in this table can only be deleted, not updated.
Column Name | Data Type | Attribute |
---|---|---|
PrivGroupCode | INTEGER | not null |
PrivDefCode | INTEGER | not null |
Unique Index = (PrivGroupCode ascending, PrivDefCode ascending)
Foreign Key = PrivGroupCode references ICMSTPrivGroupCode (PrivGroupCode) on delete cascade Foreign Key = PrivDefCode references ICMSTPrivDefs (PrivDefCode) on delete restrict
Column Definitions
This table maintains a catalog of individual users and user groups.
Individual users can belong to none or any number of groups. Users must be assigned a number of privileges, stored in UserPrivSetCode. Defining new CM users does not guarantee their existence in the DBMS and the operating system. It is the system administrator's responsibility to ensure the usefulness of the CM users he creates.
A group is a number of zero or more users, usually with the same job
description, and assigns them the same Privilege Set. A group cannot
belong to other groups. A group does not hold default privileges for
its members. CM groups do not relate to DBMS or operating system
groups. Defining groups merely minimizes the effort required to
administer ACLs.
Column Name | Data Type | Attribute |
---|---|---|
UserID | CHAR(32) | not null |
DomainID | INTEGER | not null |
UserKind | SMALLINT | not null |
UserPrivSetCode | INTEGER | not null |
GrantPrivSetCode | INTEGER | not null |
DfltACLCode | INTEGER | not null |
DfltRMCode | SMALLINT | not null |
DfltCollCode | SMALLINT | not null |
RetryCount | SMALLINT | not null |
LoggedOn | SMALLINT | not null |
LastAccess | INTEGER | not null |
Password | CHAR(8) FOR BIT DATA | nullable |
PasswordExpiration | DATE | nullable |
UserName | VARCHAR(128) | not null |
LDAPInfo | VARCHAR(1024) | nullable |
Foreign Key = DomainID references ICMSTAdminDomains (DomainID) on delete restrict Foreign Key = (UserPrivSetCode) references ICMSTPrivSetCodes (PrivSetCode) on delete restrict Foreign Key = (GrantPrivSetCode) references ICMSTPrivSetCodes (PrivSetCode) on delete restrict Foreign Key = DfltACLCode references ICMSTAccessCodes (ACLCode) on delete restrict Foreign Key = (DfltRMCode, DfltCollCode) references ICMSTCOLLNAME (RMCode, SmsCollCode) on delete restrict
Column Definitions
The System Administrator GUI for creating a user must have an entry field for that user's GrantPrivSetCode.
Your application provides the code of the resource manager that is to contain item resources pertaining to this user.
Your application provides the code of the collection that is to contain item resources pertaining to this user.
Table 13. CM Pre-configured User and Group
Column Name | Value |
---|---|
UserID | %ICMCRLSDBUSER% |
DomainID | 1 |
UserKind | 0 |
UserPrivSetCode | 1 (AllPrivSet) |
GrantPrivSetCode | 6 (ItemReadPrivSet, not used) |
DfltACLCode | 3 (PublicReadACL) |
DfltRMCode | 1 |
DfltCollCode | 1 |
RetryCount | 0 |
LoggedOn | 0 |
LastAccess | 0 |
Password | NULL |
PasswordExpiration | 2099-12-31 |
UserName | ICM Super System Administration |
LDAPInfo | NULL |
|
|
UserID | %ICMCRLSDBDB2CONNECTID% |
DomainID | 1000 |
UserKind | 0 |
UserPrivSetCode | 7 |
GrantPrivSetCode | 7 |
DfltACLCode | 3 |
DfltRMCode | 1 |
DfltCollCode | 1 |
RetryCount | 0 |
LoggedOn | 0 |
LastAccess | 0 |
Password | NULL |
PasswordExpiration | 2099-12-31 |
UserName | Database connection userid |
LDAPInfo | NULL |
UserID | ICMPUBLC |
DomainID | 2 |
UserKind | 1 |
UserPrivSetCode | 1 (not used) |
GrantPrivSetCode | 1 (not used) |
DfltACLCode | 1 (not used) |
DfltRMCode | 0 (not used) |
DfltCollCode | 0 (not used) |
RetryCount | 0 |
LoggedOn | 0 |
LastAccess | 0 |
Password | ' ' |
PasswordExpiration | 2099-12-31 |
UserName | ICM Public |
LDAPInfo | NULL |
This table maintains associations of individual users with the groups. An individual user can belong to none or any number of groups. A group cannot belong to other groups. When an individual user is associated with a group, the user is said to be a member of that group.
Associating individual users with groups simplifies the access control management. When defining access control specifications, a group can be granted a number of privileges instead of granting the same set of privileges to each user in the group.
The individual user and the group must be defined in the ICMSTUsers table before an association can be made between the user and the group.
Rows in this table can only be deleted, not updated.
Column Name | Data Type | Attribute |
---|---|---|
UserID | CHAR(32) | not null |
GroupUserID | CHAR(32) | not null |
Unique Index = (UserID ascending, GroupUserID ascending)
This index is designed to optimize the access control algorithm's frequently querying all groups a particular user belongs to.
Foreign Key = (UserID) references ICMSTUsers (UserID) on delete cascade Foreign Key = (GroupUserID) references ICMSTUsers (UserID) on delete cascade
Column Definitions
CM Pre-configured User Groups: n/a
This table maintains the access control list identifiers. Each list
is uniquely identified by the AccessListCode. The list specifications
are stored in the access control list table (ICMSTAccessLists). ACL
name and description are defined in the NLS Keywords Table
(ICMSTNLSKEYWORDS).
Column Name | Data Type | Attribute |
---|---|---|
ACLCode | INTEGER | not null |
Column Definitions
Table 16. CM Pre-configured ACL Codes
ACLCode | ACLName* | ACLDesc* |
---|---|---|
1 | SuperUserACL | ACL allows the first user from installation to perform all CM functions on the bound entities. |
2 | NoAccessACL | ACL specifies, for all CM users, no actions are allowed on the bound entities. |
3 | PublicReadACL | ACL allows all CM users to read the bound entities. |
4 | DocRouteACL | Document Routing ACL. |
*For illustration only. Name and description are defined in the NLS Keywords table. |
This table maintains associations of CM Access Control List Code with the
domain. Rows with the same DomainID form a domain's access control
list code. Rows in this table can only be deleted, not updated.
Column Name | Data Type | Attribute |
---|---|---|
DomainID | INTEGER | not null |
ACLCode | INTEGER | not null |
Unique Index = (DomainID ascending, ACLCode ascending)
Foreign Key = DomainID references ICMSTAdminDomains (DomainID) on delete restrict Foreign Key = ACLCode references ICMSTAccessCodes (ACLCode) on delete cascade
Column Definitions
Table 18. CM Pre-configured Domain Access Control List Codes
DomainID | ACLCode | DomainName* | ACLName* |
---|---|---|---|
1 | 1 | SuperDomain | SuperUserACL |
1 | 2 | SuperDomain | NoAccessACL |
1 | 3 | SuperDomain | PublicReadACL |
1 | 4 | SuperDomain | DocRouteACL |
2 | 1 | PublicDomain | SuperUserACL |
2 | 2 | PublicDomain | NoAccessACL |
2 | 3 | PublicDomain | PublicReadACL |
2 | 4 | PublicDomain | DouRouteACL |
1000 | 1 | DefaultDomain | SuperUserACL |
1000 | 2 | DefaultDomain | NoAccessACL |
1000 | 3 | DefaultDomain | PublicReadACL |
1000 | 4 | DefaultDomain | DocRouteACL |
*For illustration only. Name is defined in the NLS Keywords table. |
This table maintains the access control list specifications. A list
can contain more than one control. Each control is composed of two
elements: who (UserID, UserKind) can perform what (PrivSetCode).
Each CM data entity (Item) must be bound to a control list. The control
specifications then will be enforced whenever Items are accessed.
Column Name | Data Type | Attribute |
---|---|---|
ACLCode | INTEGER | not null |
UserID | CHAR(32) | not null |
UserKind | SMALLINT | not null |
PrivSetCode | INTEGER | not null |
Unique index = (ACLCode ascending, UserID ascending)
Foreign Key = ACLCode references ICMSTAccessCodes (ACLCode) on delete cascade Foreign Key = UserID references ICMSTUsers (UserID) on delete cascade Foreign Key = PrivSetCode references ICMSTPrivSetCodes (PrivSetCode) on delete restrict
Column Definitions
Table 20. CM Pre-configured Access Control Lists
ACLCode | UserID | UserKind | PrivSetCode |
---|---|---|---|
1 (SuperUserACL) | %ICMCRLSDBUSER% | 0 | 1 (AllPrivSet) |
3 (PublicReadACL) | ICMPUBLC | 2 (public) | 6 (ItemReadPrivSet) |
This table contains the compiled access control information. The
UserID contains only individual users. The PrivDefCode represents a
single Privilege for Item access. For incremental refresh on this
table, please refer to section "Access Control Compilation" paragraph
"Incremental Refresh".
Column Name | Data Type | Attribute |
---|---|---|
ACLCode | INTEGER | not null |
PrivDefCode | INTEGER | not null |
PrivSetCode | INTEGER | not null |
UserID | CHAR(32) | not null |
GroupUserID | CHAR(32) | null |
UserKind | SMALLINT | not null |
|Index = (UserID asc, PrivDefCode asc, ACLCode asc, UserKind asc) |Index = (PrivDefCode asc, ACLCode asc, UserKind asc, UserID asc) |Index = (ACLCode asc, UserKind asc, PrivDefCode asc, UserID asc, )
Column Definitions
This table contains the compiled individual user's User
Privileges. The UserID contains only individual users. The
PrivDefCode represents a single Privilege for Item access.
Column Name | Data Type | Attribute |
---|---|---|
UserID | CHAR(32) | not null |
PrivDefCode | INTEGER | not null |
PrivSetCode | INTEGER | not null |
|Unique index = (UserID ascending, PrivDefCode ascending) |Unique index = (PrivDefCode ascending, UserID ascending)
Column Definitions
The ICMSTATTRDEFS table identifies all system and user defined base attributes. These attributes are associated to a database data type, defined in the database. You must define a base attribute before you can associate it to a table or a view. The content manager checks this table to ensure that the AttributeID is unique to the content manager system. The DB2 table column name has the form "ATTR", and two numeric representations of the attribute group ID and attribute ID (example: ATTR0000300002) where 00003 is an attribute group ID and 00002 is an attribute ID.
Each base attribute defined in the table can have one and only one display
name. All display names are defined in the KeywordName in the NLS
Keywords table. Attribute ID is represented by the KeywordCode where
the KeywordClass is equal to 1.
Column Name | Data Type | Attribute |
---|---|---|
AttributeID | INTEGER | NOT null |
AttrSQLType | SMALLINT | NOT null |
AttrLength | INTEGER | NOT null |
AttrScale | INTEGER | NOT null |
AttrFlags | INTEGER | NOT null |
Column Definitions
The content manager generates a unique value for each base attribute when it is defined. The content manager assigns numeric values, starting at 1, and increments this value by 1 for each base attribute defined. An installation can have 99,999 base attributes at most that can be associated with item components.
The value is last five digits of DB2 column name. For example, ATTR0000000001 (base attribute 1), ATTR0000000002 (base attribute 2), ATTR0000100002 (attribute group 1 and base attribute 2)...
Your application cannot update this field if it's a system-defined attribute. It's value is controlled by your application if it's a user-defined attribute.
The ICMSTATTRGROUP table identifies attribute groups in the content manager. The content manager checks this table to ensure that the CompositeAttrID and AttributeID is unique to the content manager system.
All attribute group names are defined in the NLS Keywords table.
Nested attribute groups are not allowed. It means that attribute group can not contain another attribute group.
When user defines a attribute group, a CompositeAttrID (next sequential number in the ICMSTATTRGROUP table) and an attribute group name (KeywordName, KeywordCode = CompositeAttrID with the KeywordClass = 6 in the MSTNLSKEYWORDS table) will be generated.
The user can delete a specific attribute if it has not been used.
The user can also delete any attribute group if the attribute group is not
referenced.
Column Name | Data Type | Attribute |
---|---|---|
AttributeGroup | INTEGER | NOT null |
AttributeID | INTEGER | NOT null |
SequenceNum | SMALLINT | NOT null |
Unique Index (AttributeGroup asc, AttributeID asc, SequenceNum asc) Index None
Foreign Key = AttributeID references ICMSTATTRDEFS (AttributeID) on delete restrict
Column Definitions
The content manager generates a unique value for each attribute group when it is defined. The content manager assigns numeric values, starting at 1, and increments this value by 1 for each attribute group defined. An installation can have 99,999 attribute groups at most, that can be associated with item components.
The value is first five digits of DB2 column name. For example, ATTR0000100002 (attribute group 1 and base attribute 2)...
The ICMSTNLSKEYWORDS table provides the national language translations for
all keyword strings that are language sensitive. Each entry contains
the translated version of the string in a given national language. When
the keyword string is initially created, the content manager assigns it a
code: the KeywordCode (e.g. ComponentTypeID). This
code remains the same for all translations of the string in multiple
languages. The language code must be defined in the ICMSTNLSLANGUAGES
table before an entry for it can be created in this table.
Column Name | Data Type | Attribute |
---|---|---|
KeywordClass | SMALLINT | NOT null |
LanguageCode | CHAR(3) | NOT null |
KeywordCode | INTEGER | NOT null |
KeywordName | VARCHAR(32) | NOT null |
KeywordDescription | VARCHAR(254) | NOT null |
Unique Indexes (LanguageCode asc, KeywordClass asc, KeywordCode asc) (LanguageCode asc, KeywordClass asc, KeywordName asc) Index None.
Foreign key = LanguageCode references ICMSTNLSLANGAUGES (LanguageCode) on delete cascade
Column Definitions
The ICMSTNLSLANGUAGES table identifies all national languages used within the content manager. All languages must be identified in this table before language-specific textual strings can be created in the ICMSTNLSKEYWORDS table.
When a new language is added, all the keywords are duplicated for that
language. Although you cannot update the keyword name, you can update
the newly generated keyword description. An asterisk (*) is added at
the beginning of a newly generated keyword description.
Column Name | Data Type | Attribute |
---|---|---|
LanguageCode | CHAR(3) | NOT null |
LanguageName | VARCHAR(32) | NOT null |
Unique Index LanguageName asc Index None
Column Definitions
The language codes are assigned to the written languages of the world by IBM. The language codes are documented in Chapter 8 of the IBM National Language Design Guide: National Language Support Reference Manual, Volume 2.
The ICMSTITEMTYPEDEFS, ICMSTCOMPDEFS, Item Root, and Component system tables are used to build the complex object. When the user defines a new Item Type, the CM content manager inserts a row into the ICMSTITEMTYPEDEFS table. The ItemTypeID is an unique sequential number to be managed by the system. The name of the Item Type is defined in the ICMSTNLSKEYWORDS table for NLS support. The system will also insert rows into ICMSTCOMPDEFS table. One item root table and either zero or many item child tables will be created.
When an item type is defined, the installation can specify the following for the new item type:
Resource is a special type of Item Type. You can define an Item Type
for a resource.
Column Name | Data Type | Attribute |
---|---|---|
ItemTypeID | INTEGER | NOT null |
ItemTypeClass | SMALLINT | NOT null |
ItemLevelACLFlag | SMALLINT | NOT null |
ItemTypeACLCode | INTEGER | NOT null |
DfltRMCode | SMALLINT | NOT null |
DfltCollCode | SMALLINT | NOT null |
DfltPrefchCollCode | SMALLINT | NOT null |
DfltRetentionUnit | SMALLINT | NOT null |
DfltItemRetention | INTEGER | NOT null |
DfltXDOClassID | INTEGER | NOT null |
AutoLinkEnabled | SMALLINT | NOT null |
AutoLinkSMS | SMALLINT | NOT null |
SegmentID | SMALLINT | NOT null |
SegmentThreshold | INTEGER | NOT null |
PartitionID | SMALLINT | NOT null |
PartitionThreshold | INTEGER | NOT null |
VersionControl | SMALLINT | NOT null |
VersionMax | SMALLINT | NOT null |
ItemEventFlag | SMALLINT | NOT null |
UserID | CHAR(32) | NOT null |
Changed | TIMESTAMP | NOT null |
ProcessName | CHAR(32) | nullable |
DFLTPRIORITY | INTEGER | nullable |
Foreign Key = ItemTypeACLCode references ICMSTACCESSCODES (ACLCode) on delete restrict Foreign Key = (DfltRMCode, DfltCollCode) references ICMSTCOLLNAME (RMCode, SmsCollCode) on delete restrict For 390 only: Foreign Key = (DfltRMCode, DfltPrefchCollCode) references ICMSTCOLLNAME (RMCode, SmsCollCode) on delete restrict
Column Definitions
When a new item type is defined, the content manager generates this value. At the same time, the library inserts a row into the ICMSTCOMPDEFS table and generates a component root table for the item type.
Your application provides the code of the resource manager that contains item resources pertaining to this item type.
Your application provides the code of the collection that is to contain item resources pertaining to this item type.
Your application provides the code of the prefetch collection that is to contain item resources pertaining to this item type.
Your application provides number of days, weeks, months, or years of item pertaining to this item type.
The ICMSTITVIEWID table identifies component views defined on item type views. Item type view consists of one or more item component views. When the system administrator defines item type view on an item type, one view is selected from each component table which is defined in the item type. Once the view is selected, it becomes unavailable to the other item type view.
The ICMSTITVIEWID table identifies component views defined on item type views. When the system administrator defines item type view, a row per component view is inserted into this table.
Item type views are defined to control access to sensitive data contained
in all component views defined in the item type view. An installation
can have multiple views defined on the item type. You should not delete
the item type view that has the same ID as the item type. This is the
base view, which includes all base views for the components.
Column Name | Data Type | Attribute |
---|---|---|
ItemTypeViewID | INTEGER | NOT null |
ComponentViewID | INTEGER | NOT null |
|Unique Index |(ComponentViewID asc) |Index |(ComponentViewID asc, ItemTypeViewID desc)
Foreign key = ItemTypeViewID references ICMSTITVIEWDEFS (ItemTypeViewID) on delete restrict
Column Definitions
An ItemTypeViewID is generated by the content manager when a new view is created.
A ComponentViewID is generated by the content manager when a new view is created.
An item type consists of one or more component tables. Each component table can have one (base) or more views. A group of views (one from each component table) are included in an item type view.
The ICMSTITVIEWDEFS table identifies item type views defined on item type. When the system administrator defines item type view on an item type, a row is inserted into this table.
Item type views are defined to control access to sensitive data contained
in all component views defined in the item type view. An installation
can have multiple views defined on the item type. You should not delete
the view that has the same ID as the item type. This is the base view,
which includes all base views for the components.
Column Name | Data Type | Attribute |
---|---|---|
ItemTypeViewID | INTEGER | NOT null |
ItemTypeID | INTEGER | NOT null |
ACLCode | INTEGER | NOT null |
UserID | CHAR(32) | NOT null |
Created | TIMESTAMP | NOT null |
Unique Index None Index None
Foreign key = ItemTypeID references ICMSTITEMTYPEDEFS (ItemTypeID) on delete restrict Foreign Key = ACLCode references ICMSTACCESSCODES(ACLCode) on delete restrict
Column Definitions
An ItemTypeViewID is generated by the content manager when a new view is created.
When the user defines an Item Type, the CM content manager inserts rows into the ICMSTCOMPDEFS table for a root and either zero or many descendant (child) tables. The ComponentTypeID is a unique sequential number which will be managed by the system. The user must provide an ItemTypeID for all component types which associated to the Item Type. The Item Type is the default parent of all component type tables associate to it. Each component type could have many children, but the child can have only one component type parent. Both the ItemTypeID and the component parent ID must exist in the ICMSTITEMTYPEDEFS table and ICMSTCOMPDEFS table respectively. The component type cannot be shared by different item type.
When an item type is defined, the content manager performs the following tasks on behalf of the application:
Column Name | Data Type | Attribute |
---|---|---|
ComponentTypeID | INTEGER | NOT null |
ItemTypeID | INTEGER | NOT null |
ParentCompTypeID | INTEGER | NOT null |
CardinalityMin | SMALLINT | NOT null |
CardinalityMax | SMALLINT | NOT null |
DeleteRule | SMALLINT | nullable |
CompTypeClass | SMALLINT | NOT null |
UserID | CHAR(32) | NOT null |
Changed | TIMESTAMP | NOT null |
|Unique Index |None |Index |ItemTypeID |(ComponentTypeID asc, ItemTypeID asc)
Foreign key = ItemTypeID references ICMSTITEMTYPEDEFS (ItemTypeID) on delete restrict
Column Definitions
When a new component table is defined, the content manager generates this value. A component cannot be shared by different item type. An installation can have 46,655 component type views at most.
When a new item type is defined, the content manager generates this value. At the same time, the library inserts a row into the ICMSTCOMPDEFS table and generates a component root table for the item type.
For the root component:
For the child component:
The Component table identifies all items belonging to the table. The content manager represents an Component table as a single, distinct table known as an ICMUT, or Component Table. The table name has the form "ICMUT" and a numeric representation of the ComponentTypeID and SegmentID (e.g. ICMUT00001001). The two types of Component Tables are Component Root Table and Component Child Table. Each item type is represented by a Component root table and either zero or more Component child tables.
A Component table can be dropped when there are no Items stored in it.
An attribute can be added to a Component at any time. The administrative client should first search to determine whether any components are actually using that attribute. If so, a warning message should be displayed. The alternative (which is used in VI/400) is to remove an attribute only if it is not used by any items. The access module will be modified accordingly.
There is only one Component Root Table per Item Type.
Column Name | Data Type | Attribute |
---|---|---|
CompClusterID | INTEGER | NOT null |
ComponentID | CHAR(18) | NOT null |
ItemID | CHAR(26) | NOT null |
VersionID | SMALLINT | NOT null |
ACLCode | INTEGER | NOT null |
Expiration date | DATE | nullable |
SemanticType | INTEGER | nullable |
CompKey | VARCHAR(23) | NOT null |
CreateTS | TIMESTAMP | NOT null |
CreateUserID | CHAR(32) | NOT null |
LastChangedTS | TIMESTAMP | NOT null |
LastChangedUserID | CHAR(32) | NOT null |
... User Defined Attributes |
|
|
Unique Index (ItemID asc, VersionID asc) (ComponentID, VersionID) (ItemID asc, ComponentID, VersionID asc) Index None
Column Definitions
Example:
PartitionID ItemID Timestamp 001 2000-04-07-20.22.43.123987 |______________________ ------------ | _______________________| reversed | | CompClusterID 0017893213
This column cannot be updated by your application.
This column cannot be updated by your application.
The value for ItemID is generated in content manager the application requests to create an item.
This column cannot be updated by your application.
For example, suppose you have a book that is available in both the English and the French language. You might set the SemanticType to 'book' in the Items table. Then you could set the RepType (could be selected by user as an user defined attribute) in the Item Resources table to 'English' for the resource that represents the English version of the book, and to 'French' for the resource that represents the French version of the book.
This field is set and interpreted by your application.
This field has set definitions that are used by the system. Your
application can use these values with the defined meanings.
Definition | Value |
---|---|
Document | 1 |
Folder | 2 |
WorkBasket | 3 |
Annotation | 4 |
History | 5 |
Workflow | 6 |
Note | 7 |
Base | 8 |
All | 9 |
ACL | 10 |
Folder_Doc | 11 |
MGDS | 12 |
System | 13 |
User | 14 |
Container | 15 |
... | 16-999 |
user defined | 1000+ |
This column cannot be updated by your application.
Each item type can define zero or more Component child tables. A
Component Child Table can be the parent of another Component Child
Table. The top of the hierarchy must be the Component Root
Table.
Column Name | Data Type | Attribute |
---|---|---|
CompClusterID | INTEGER | NOT null |
ComponentID | CHAR(18) | NOT null |
ItemID | CHAR(26) | NOT null |
VersionID | SMALLINT | NOT null |
ParentCompID | CHAR(18) | NOT null |
CompKey | CHAR(23) | NOT null |
ParentCompKey | CHAR(23) | NOT null |
... User Defined Attributes |
|
|
|Unique Index |(ComponentID, VersionID) |Index |(ItemID asc, ComponentID, VersionID asc) | |(ItemID asc, VersionID asc) |(ParentCompID, VersionID)
Foreign key = ParentCompKey references parent table ICMUTnnnnnsss CompKey on delete cascade or restrict depends on DeleteRule in the Component Definition Table (ICMSTCOMPDEFS)
Column Definitions
Example:
PartitionID ItemID Timestamp 001 2000-04-07-20.22.43.123987 |______________________ ------------ | _______________________| reversed | | CompClusterID 0017893213
This column cannot be updated by your application.
This column cannot be updated by your application.
The ItemID and VersionID must exist in the Component Root table.
This column cannot be updated by your application.
The ItemID and VersionID must exist in the Component Root table.
This column cannot be updated by your application.
This column cannot be updated by your application.
This column cannot be updated by your application.
This column cannot be updated by your application.
The ICMSTCOMPATTRS table associates attribute display names with component tables. An attribute can be associated with more than one component table. In this case, one row is created for each AttributeID/ComponentTypeID combination.
The item type and each attribute that is to be associated with the item
type must be defined before an association can be made. The Component
Type is defined in the ICMSTCOMPDEFS, and attribute display names are defined
in the ICMSTNLSKEYWORDS table.
Column Name | Data Type | Attribute |
---|---|---|
ComponentTypeID | INTEGER | NOT null |
AttributeID | INTEGER | NOT null |
AttributeGroup | INTEGER | NOT null |
SequenceNum | SMALLINT | NOT null |
AttrFlags | SMALLINT | NOT null |
DefaultType | SMALLINT | NOT null |
MinimumValue | INTEGER | NOT null |
MaximumValue | INTEGER | NOT null |
DefaultValue | VARCHAR(512) | nullable |
Unique Indexes (ComponentTypeID asc, AttributeID asc, AttributeGroup asc) (ComponentTypeID asc, SequenceNum asc) Index None
Foreign Key = ComponentTypeID references ICMSTCOMPDEFS (ComponentTypeID) on delete restrict Foreign Key = AttributeID references ICMSTATTRDEFS (AttributeID) on delete restrict
Column Definitions
This column represents the component type ID that is associated with the attribute. The component type must be defined in the Component definition (ICMSTCOMPDEFS) before attribute display names can be associated with it.
This column represents the ID of the attribute display name that is associated with the component type. The attribute display name or attribute group name must be defined in the NLS Keywords table (ICMSTNLSKEYWORDS) before it can be associated with the component type.
When you add an attribute group to the component, the system will add one row for each base attribute in the attribute group and assign the AttributeGroup. If the AttributeID is a base attribute then the attribute group ID is set to zero.
This column is for use by your application exclusively. The content manager does not set or interpret this column.
All attributes in the attribute group are either required or not required. If there is a mixed situation, all attributes in the attribute group must be presented in this table separately.
Bit positions are counted from right to left. Counting starts with number 0, so the rightmost bit is bit number 0 and the leftmost bit is bit number 15.
Each item type can define zero or more Component child tables. A
Component Child Table can be the parent of another Component Child
Table. The top of the hierarchy must be the Component Root
Table.
Bit | 0 | 1 |
---|---|---|
0 | Indicates that a value for the attribute is required (NOT NULL). | Indicates that a value for the attribute is not required (nullable). |
1 | Indicates that a value for the attribute is unique. | Indicates that a value for the attribute is not unique. |
2 | Indicates that a value for the attribute is a regular (not resource manager) attribute. | Indicates that a value for the attribute is a resource manager attribute. This bit is set on by LS if it is a system-defined resource attribute for OO API XDO uses. If it is user-defined attribute, it's up to application to set it on/off. |
3 | Indicates that a value for the attribute is XML-Element. | Indicates that a value for the attribute is XML-attribute. |
4 | Indicates that a value for the attribute is a regular (not text searchable) attribute. | Indicates that a value for the attribute is a text searchable attribute. |
Your application provides a value for this column.
If the value of the DefaultValue column is not null, the default is the value in the DefaultValue.
If the value of the DefaultValue column is null, the default depends on the bit 0 of AttrFlags.
If bit 0 of AttrFlags is 0 (not null), the default value depends on the
data type of the attribute:
Data type | Default value |
---|---|
Numeric | 0 |
Fixed-length string | blanks |
Varying-length string | A string length of 0 |
Date | The current date |
Time | The current time |
Timestamp | The current timestamp |
If bit 0 of AttrFlags is 1 (nullable), the attribute has a default value of null.
There is no maximum if MaximumValue is zero. If both MinimumValue and MaximumValue are not zero, MaximumValue must be equal to or greater than MinimumValue.
The ICMSTCOMPATTRFK table identifies all foreign key definitions.
Each row identifies both dependent attribute information (attribute ID and
Attribute Group ID) and parent attribute information and/or external table
column name. Assume this is a small table so it is not
normalized. If the foreign key has multiple columns, then there are
multiple rows to represent the foreign key.
Column Name | Data Type | Attribute |
---|---|---|
SourceCompTypeID | INTEGER | NOT null |
SrcAttributeID | INTEGER | NOT null |
SrcAttrGroupID | INTEGER | NOT null |
ColumnSeq | SMALLINT | NOT null |
TargetCompTypeID | INTEGER | NOT null |
TargetAttributeID | INTEGER | NOT null |
TargetAttrGroupID | INTEGER | NOT null |
ColumnName | VARCHAR(18) | nullable |
DeleteRule | SMALLINT | nullable |
UpdateRule | SMALLINT | nullable |
ConstraintName | VARCHAR(18) | nullable |
TabSchema | VARCHAR(128) | nullable |
TargetTblName | VARCHAR(128) | nullable |
Unique Indexes (SourceCompTypeID asc, ColumnSeq asc, SrcAttrGroupID asc, SrcAttributeID asc, ConstraintName asc) Index None
Foreign Key = SourceCompTypeID references ICMSTCOMPDEFS (ComponentTypeID) on delete restrict Foreign Key = SrcAttributeID references ICMSTATTRDEFS (AttributeID) on delete restrict
Column Definitions
The ICMSTCOMPVIEWDEFS table identifies views defined on components. Item type consists of one or more item component tables. All views are created on the Component tables. When the system administrator defines views on a component table, a row is inserted into this table. In addition, one or more rows are inserted in the ICMSTCOMPVIEWATTRS table, one for each attribute included in the view.
An installation can have multiple views defined on the item
components. You should not delete the view that has the same ID as the
item component. This is the base view, which includes all columns for
the item component.
Column Name | Data Type | Attribute |
---|---|---|
ComponentViewID | INTEGER | NOT null |
ComponentTypeID | INTEGER | NOT null |
SegmentID | SMALLINT | NOT null |
ItemTypeID | INTEGER | NOT null |
ComponentViewName | CHAR(18) | NOT null |
AccessModuleName | CHAR(8) | NOT null |
AccessModuleStatus | SMALLINT | NOT null |
AccessModuleResult | INTEGER | NOT null |
AccessModuleVers | SMALLINT | NOT null |
PrevAccessModule | CHAR(8) | NOT null |
UserID | CHAR(32) | NOT null |
Created | TIMESTAMP | NOT null |
|Unique Indexes |None |Index |(ComponentViewID asc, ComponentTypeID asc)
Foreign Key =ComponentTypeID references ICMSTCOMPDEFS(ComponentTypeID) on delete cascade Foreign Key = ItemTypeID references ICMSTITEMTYPEDEFS(ItemTypeID) on delete restrict
Column Definitions
A ComponentViewID is generated by the content manager when a new view is created. An installation can have 46,655 component views at most.
When a new component table is defined, the content manager generates this value.
When a new item type is defined, the content manager generates this value. At the same time, the library inserts a row into the ICMSTCOMPDEFS table and generates a component root table for the item type.
The content manager generates this name. Your application cannot provide or update this column.
The access module generation process goes through five phases:
When the access module is created for the first time, the PrevAccessModule is the same as the AccessModuleName. Subsequently, if a request to create a new access module is made and the new access module cannot be created for some reason, then the content manager uses the previously active access module. The AccessModuleStatus column indicates this situation, and identifies the previously active access module.
The ICMSTCOMPVIEWATTRS table associates attribute display names with
component type views. When the system administrator defines views on
component types, the content manager inserts a row for each attribute display
name included in the view. The content manager server also inserts a
row for the defined view in the ICMSTCOMPVIEWDEFS table. The view and
the attributes must be defined before an association can be made between the
view and the attributes.
Column Name | Data Type | Attribute |
---|---|---|
ComponentViewID | INTEGER | NOT null |
AttributeID | INTEGER | NOT null |
AttributeGroup | INTEGER | NOT null |
SequenceNum | SMALLINT | NOT null |
AttributeFlags | SMALLINT | NOT null |
ViewOperator | SMALLINT | NOT null |
ViewCompareValue | VARCHAR(254) | nullable |
Unique Indexes (ComponentViewID asc, AttributeID asc, AttributeGroup asc) (ComponentViewID asc, SequenceNum asc) Index (AttributeID) (AttributeGroup)
Foreign Key = AttributeID references ICMSTATTRDEFS (AttributeID) on delete restrict
Column Definitions
A ComponentViewID is generated by the content manager when a new view is created.
This column represents the ID of the attribute display name that is associated with the component type. The attribute display name must be defined in the NLS Keywords table (ICMSTNLSKEYWORDS) before it can be associated with the component type.
When you add an attribute group to the component view, the system will add one row for each base attribute in the attribute group and assign the AttributeGroup. If the AttributeID is a base attribute then the attribute group ID is set to zero.
This column is for use by your application exclusively. The content manager does not set or interpret this column.
Bit positions are counted from right to left. Counting starts with number 0, so the rightmost bit is bit number 0 and the leftmost bit is bit number 15. Flags using multiple bits are read from left to right within the bit positions they occupy. For example, if bits 0 and 1 are said to have the value 10, that indicates that bit 1 is 1 and bit 0 is 0.
The bit settings are as follows:
All other bits are reserved for future use.
If an attribute is set for read access only, even users who have privileges to update the view cannot update this attribute. The attribute flag setting overrides the privileges of the user over the view.
Exception: In this context, writeable has the same meaning as readable and writeable.
Your application sets values for this column.
|The ICMSTVIEWACCESS table is empty and will be used for future
|reference.
|
Column Name | Data Type | Attribute |
---|---|---|
ComponentViewID | INTEGER | NOT null |
SegmentID | SMALLINT | NOT null |
VIEWACCESSINFO | BLOB(100K) | NOT null |
ACLSUBSELECT | VARCHAR(1000) | NOT null |
LASTCHANGEDTS | TIMESTAMP | NOT null |
The ICMSTITEMAUTOLINK table predefines container of items in one or more
item types. If you set 1 on the AutoLinkEnable column in the
ICMSTITEMTYPEDEFS table, then when an item in the item type is created, the
item will be automatically added to the predefined container or
containers.
Column Name | Data Type | Attribute |
---|---|---|
SourceItemTypeID | INTEGER | NOT null |
SourceCompTypeID | INTEGER | NOT null |
TargetItemTypeID | INTEGER | NOT null |
TargetCompTypeID | INTEGER | NOT null |
LinkType | INTEGER | NOT null |
AttributeID | INTEGER | NOT null |
AttributeGroup | INTEGER | NOT null |
SequenceNum | SMALLINT | NOT null |
Unique Indexes (SourceItemTypeID asc, SourceCompTypeID asc, TargetItemTypeID asc, TargetCompTypeID asc, AttributeID asc, AttributeGroup asc) Index None
Foreign Key = SourceItemTypeID references ICMSTITEMTYPEDEFS (ItemTypeID) on delete cascade Foreign Key = SourceCompTypeID references ICMSTCOMPDEFS(ComponentTypeID) on delete cascade Foreign Key = TargetItemTypeID references ICMSTITEMTYPEDEFS (ItemTypeID) on delete cascade Foreign Key = TargetCompTypeID references ICMSTCOMPDEFS(ComponentTypeID) on delete cascade
Column Definitions
This column represents the source item type ID that is associated with the item.
This column represents the ID (KeywordCode in the ICMSTNLSKEYWORDS) of the attribute display name that is associated with the mapping. The attribute display name must be defined in the NLS Keywords table (ICMSTNLSKEYWORDS) before it can be associated with the component type.
When you map an attribute group, the system will add one row for each base attribute in the attribute group and assign the AttributeGroup. If the AttributeID is a base attribute then the attribute group ID is set to zero.
This column is for use by your application exclusively. The content manager does not set or interpret this column.
The ICMSTITEMSnnnsss table (where nnn is LibraryID and
sss is SysSegmentID) identifies all items within the content
manager. If the item has different versions, this table will only keep
the current version of the item.
Column Name | Data Type | Attribute |
---|---|---|
ItemID | CHAR(26) | NOT null |
VersionID | SMALLINT | NOT null |
ComponentID | CHAR(18) | NOT null |
SegmentID | SMALLINT | NOT null |
ACLCode | INTEGER | NOT null |
SemanticType | INTEGER | NOT null |
ItemTypeID | INTEGER | NOT null |
ComponentTypeID | INTEGER | NOT null |
Changed | TIMESTAMP | NOT null |
InProgress | SMALLINT | NOT null |
Unique Indexes None Index None
Foreign key = ACLCode references ICMSTACCESSCODES (ACLCode) on delete restrict Foreign key = ItemTypeID references ICMSTITEMTYPEDEFS (ItemTypeID) on delete restrict Foreign key = ComponentTypeID references ICMSTCOMPDEFS (ComponentTypeID) on delete restrict
Column Definitions
The ItemID is composed of four fields:
Position | Description |
---|---|
1 | The first digit of the library server ID: A-0, B-1, C-2, D-3, E-4, F-5, G-6, H-8, I-92 |
2 | The second digit of the library server ID. |
3-5 | The library ID. |
6-8 | The segment ID. |
9 | A if the first two digits of the year are 20. B if the first two digits of the year are 21. |
10-11 | The last two digits of the year. |
12 | The character (A-L) representation of the month: A-01, B-02, C-03, D-04, E-05, F-06, G-07, H-08, I-09, J-10, K-11, L-12 |
13-14 | The day of the month. |
15 | A if the first digit of the hour is 0. B if the first digit of the hour is 1. C if the first digit of the hour is 2. |
16 | The second digit of the hour. |
17-18 | The minutes (mm). |
19-20 | The seconds (ss). |
21 | The first digit of the microseconds. A-0, B-1, C-2, D-3, E-4, F-5, G-6, H-8, I-9 |
22-26 | The rest of microseconds (nnnnn). |
This column cannot be updated by your application.
This column cannot be updated by your application.
The ICMSTITEMVERnnnsss table (where nnn is LibraryID and
sss is SysSegmentID) identifies old item versions within the content
manager. The current version of the item is kept in the Items
Table.
Column Name | Data Type | Attribute |
---|---|---|
ItemID | CHAR(26) | NOT null |
VersionID | SMALLINT | NOT null |
ComponentID | CHAR(18) | NOT null |
SegmentID | SMALLINT | NOT null |
ACLCode | INTEGER | NOT null |
SemanticType | INTEGER | NOT null |
ItemTypeID | INTEGER | NOT null |
ComponentTypeID | INTEGER | NOT null |
Changed | TIMESTAMP | NOT null |
InProgress | SMALLINT | NOT null |
Foreign key = ACLCode references ICMSTACCESSCODES (ACLCode) on delete restrict Foreign key = ItemTypeID references ICMSTITEMTYPEDEFS (ItemTypeID) on delete restrict Foreign key = ComponentTypeID references ICMSTCOMPDEFS (ComponentTypeID) on delete restrict
Column Definitions
This column cannot be updated by your application.
This column cannot be updated by your application.
This column value is updated by the content manager (by default) whenever a change (insert, update, delete) is made to the properties, links, names, descriptions or attributes of the item. The installation can change the default value to not update this field by setting the ItemReferenceFlag in the ICMSTSYSCONTROL to 0.
The ICMSTItemsToDelete table identifies all items in resource managers to
be deleted by asynchronous recovery.
Column Name | Data Type | Attribute |
---|---|---|
ItemID | CHAR(26) | NOT null |
VersionID | SMALLINT | NOT null |
RMCode | SMALLINT | NOT null |
RMAccessType | INTEGER | NOT null |
SmsCollCode | SMALLINT | NOT null |
RepType | CHAR(8) | NOT null |
UserID | CHAR(32) | NOT null |
Created | TIMESTAMP | NOT null |
URLAddress | VARCHAR(512) | nullable |
Foreign key = (RMCode, SmsCollCode) references ICMSTCOLLNAME (RMCode, SmsCollCode) on delete restrict
Column Definitions
The value for ItemID is generated in content manager the application requests to create an item.
The ICMSTLINKSnnnsss table maintains relationships between
Items. Links can be used to support various functionality. One
example use is to support folder and document capability. For support
of folder/document, each link represents a folder-document
relationship. The TargetItemID represents the document Item, and the
SourceItemID represents the folder Item. The LinkType indicates the
functionality.
Column Name | Data Type | Attribute |
---|---|---|
LinkItemID | CHAR(26) | nullable |
TargetItemID | CHAR(26) | NOT null |
SourceItemID | CHAR(26) | NOT null |
LinkType | INTEGER | NOT null |
Changed | TIMESTAMP | NOT null |
Unique index = (TargetItemID asc, SourceItemID asc, LinkType asc) Index = (SourceItemID asc)
Column Definitions
System administrator can define user-defined link type.
The ICMSTITEMTYPEREL table uses to define relationships between any two
ItemTypes. In Version 8, used to model document to part relationships
using references from a child component. This can be extended later to
include allowable LinkTypes for modelling link relationships. Nothing
is built in which would prevent definition of a hierarchy of related
ItemTypes.
Column Name | Data Type | Attribute |
---|---|---|
SourceItemTypeID | INTEGER | NOT null |
TargetItemTypeID | INTEGER | NOT null |
DfltRMCode | SMALLINT | NOT null |
DfltCollCode | SMALLINT | NOT null |
DfltACLCode | INTEGER | NOT null |
DfltPrefchCollCode | SMALLINT | NOT null |
VersionControl | SMALLINT | NOT null |
Unique index (SourceItemTypeID,TargetItemTypeID) Index (TargetItemTypeID asc)
FOREIGN KEY (SourceItemTypeID) REFERENCES ICMSTItemTypeDefs (ItemTypeID) ON DELETE RESTRICT, FOREIGN KEY (TargetItemTypeID) REFERENCES ICMSTItemTypeDefs (ItemTypeID) ON DELETE RESTRICT, FOREIGN KEY (DfltRMCode) REFERENCES ICMSTResourceMgr (RMCode) ON DELETE RESTRICT, FOREIGN KEY (DfltRMCode, DfltCollCode) REFERENCES ICMSTCOLLNAME (RMCode, SmsCollCode) ON DELETE RESTRICT, FOREIGN KEY (DfltACLCode) REFERENCES ICMSTACCESSCODES (ACLCode) ON DELETE RESTRICT, FOREIGN KEY (DfltRMCode, DfltPrefchCollCode) REFERENCES ICMSTCOLLNAME (RMCode, SmsCollCode) ON DELETE RESTRICT
Column Definitions
Your application provides the code of the resource manager that is to contain item resources pertaining to the target item type.
Your application provides the code of the collection that is to contain item resources pertaining to the target item type.
Your application provides the code of the ACL that is to contain item resources pertaining to the target item type.
Your application provides the code of the prefetch collection that is to contain item resources pertaining to the target item type.
The ICMSTCHECKEDOUT table maintains a list of all items that have been
checked out. When a user check in a locked item, the row will be
deleted from this table. The content manager pays attention to rows
that reflect currently active checkout locks.
Column Name | Data Type | Attribute |
---|---|---|
ItemID | CHAR(26) | NOT null |
UserID | CHAR(32) | NOT null |
GroupID | CHAR(16) | NOT null |
Created | TIMESTAMP | NOT null |
Unique Index (UserID, ItemID) (ItemID) Index None
Column Definitions
The value for ItemID is generated in content manager the application requests to create an item.
This column cannot be updated by your application.
Your application cannot update this field.
The ICMSTTXLT table contains CM explicit transaction information for
asynchronous recovery.
Column Name | Data Type | Attribute |
---|---|---|
TxId | CHAR(26) | NOT null |
ExpireTime | TIMESTAMP | NOT null |
RMCode | SMALLINT | NOT null |
Status | SMALLINT | NOT null |
UserId | CHAR(26) | NOT null |
|Unique Index |None |Index |(Status asc, RMCode asc, ExpireTime asc) |(RMCode asc, ExpireTime asc)
Column Definitions
Component type 300 series are special types of Item Types. These are
the sample Component root tables (ICMUTnnnnnsss) for parts.
Each row describes a single part. It is possible for a resource belongs
to zero, one , or more items. The associations of items and resources
are defined in the ICMSTLINKSnnnsss table. It is possible for
an item to have zero resources; therefore, there can be an item entry
that has no corresponding resources entry in the ICMSTLINKSnnnsss
table. However, a resource can belong to multiple items.
Table 50. ICMBASE (ICMUT00300001 table) and ICMANNOTATION (ICMUT00304001 table)
Column Name | Data Type | Attribute |
---|---|---|
CompClusterID | INTEGER | NOT null |
ComponentID | CHAR(18) | NOT null |
ItemID | CHAR(26) | NOT null |
VersionID | SMALLINT | NOT null |
ACLCode | INTEGER | NOT null |
SemanticType | INTEGER | NOT null |
CompKey | VARCHAR(23) | NOT null |
CREATETS | TIMESTAMP | NOT null |
CREATEUSERID | CHAR(32) | NOT null |
LASTCHANGEDTS | TIMESTAMP | NOT null |
LASTCHANGEDUSERID | CHAR(32) | NOT null |
RMCODE | SMALLINT | NOT null |
SMSCOLLCODE | SMALLINT | NOT null |
RESOURCELENGTH | FLOAT | NOT null |
MIMETYPEID | INTEGER | NOT null |
OBJECTUPDATED | TIMESTAMP | NOT null |
RESOURCEFLAG | SMALLINT | NOT null |
XDOCLASSID | INTEGER | NOT null |
EXTOBJECTNAME | VARCHAR(128) | NOT null |
OBJECTCREATED | TIMESTAMP | NOT null |
Unique Index (ComponentID, VersionID) (ItemID, VersionID) (ItemID, ComponentID, VersionID) Index None
Foreign key = (RMCode, SmsCollCode) references ICMSTCOLLNAME on delete restrict Foreign key = MIMETYPEID references ICMSTMIMETYPES on delete restrict
Column Definitions
Example:
PartitionID ItemID Timestamp 001 2000-04-07-20.22.43.123987 |______________________ ------------ | _______________________| reversed | | CompClusterID 0017893213
This column cannot be updated by your application.
This column cannot be updated by your application.
The value for ItemID is generated in the content manager that the application requests to create an item.
This column cannot be updated by your application.
For example, suppose you have a book that is available in both the English and the French language. You might set the SemanticType to be 'book' in the Items table. Then you could set the RepType (could be selected by user as an user defined attribute) in the Item Resources table to 'English' for the resource that represents the English version of the book and to 'French' for the resource that represents the French version of the book.
This field is set and interpreted by your application.
This field has set definitions that are used by the system. Your
application can use these values with the defined meanings.
Table 51. SemanticType definitions
Column Name | Value |
---|---|
Document | 1 |
Folder | 2 |
WorkBasket | 3 |
Annotation | 4 |
History | 5 |
Workflow | 6 |
Note | 7 |
Base | 8 |
All | 9 |
ACL | 10 |
Folder_Doc | 11 |
MGDS | 12 |
System | 13 |
User | 14 |
Container | 15 |
... | 16-999 |
user defined | 1000+ |
This column cannot be updated by your application.
Your application cannot update this field.
Your application cannot update this field.
Bit positions are counted from right to left. Counting starts with number 0, so the rightmost bit is bit number 0 and the leftmost bit is bit number 15. Flags using multiple bits are read from left to right within the bit positions they occupy. For example, if bits 0 and 1 are said to have the value 10, that indicates that bit 1 is 1 and bit 0 is 0.
|The default value is only CM Managed on (0x00000002). Your
|application cannot update this field except as a side effect of other
|actions. The bit settings are as follows:
|
Bit | Name | Description |
---|---|---|
Bit 0 | Non CM Managed | Indicates that the entry in this ICMUTnnnnnsss table is managed by the external system. It is stored externally to the system, and exists in some external location (pointed to by the ExtObjectName column in this table). The value 01 indicates that the resource is NOT Content Manager managed. The values 00 and 11 are reserved. |
Bit 1 | CM Managed | Indicates that the resource represented by this entry in this ICMUTnnnnnsss table is managed by the Content Manager subsystem. Meaning, it is stored within the library and managed by a resource manager known to the library. A value of 10 indicates that the resource is Content Manager managed. The values 00 and 11 are reserved. |
Bit 2 | No Content | Currently has no actual data containing object associated with it yet (no object with an underlining itemID / versionID on this RM/Coll). Resources in this state have placeholders in the library and resource managers and SMS collections associated with them, however an actual object has not yet been stored in an resource manager. Resources in this state are later replaced with actual data objects while retaining all other information given when the resource was stored with no content. |
Bit 3 | Waiting Replicator | This RM/Coll is waiting for the replicator, which has the latest object to copy or replace over. |
Bit 4 | Asynchronous Copy Pending | Used for the AsyncStore process. The OOAPI sets it on for an RM AsyncStore start, and the RM turns it off whenever AsyncStore completes (regardless success or failure). During the time between the asynchronous store request and its actual completion, no other actions can be performed on this resource. |
Bit 5 | Asynchronous Replace Pending | CM toggles this on for an RM AsyncReplace start, and the RM turns it off whenever AsyncReplace completes (regardless success or failure). During the time between the asynchronous replace request and its actual completion, no other actions can be performed on this resource. |
Bit 6 | External Object | Indicates that the object name cannot be derived from ItemID, ResourceNum and VersionNum. the actual name of the object can be found in ExtObjectName column. |
Bit 7 | Replicas Exist | The RM contains replicas. |
Bit 8 | Asynchronous Failure | The AsyncStore or AsyncReplace process failed. |
For resources that are migrated from other image products and do not follow the Content Manager naming convention, the value is the original object name from the migrated products.
For resources that are not stored in an resource manager defined to the content manager, the value is any user-defined location specified by your application.
For OS/390, the value is the object name stored in OAM.
In addition to ICMBBASE columns:
Table 52. ICMBASETEXT (ICMUT00301001 table) and ICMNOTELOG (ICMUT00303001 table)
Column Name | Data Type | Attribute |
---|---|---|
TIEFlag | SMALLINT | NOT null |
TIERef | VARCHAR(512) | nullable |
CCSID | INTEGER | nullable |
LANGUAGECODE | CHAR(5) | nullable |
FORMAT | VARCHAR(30) | nullable |
Both TIEFlag and TIERef are only included if the XDO Class is set to Text:
In addition to ICMBBASE columns:
Table 53. ICMBASESTREAM (ICMUT00302001 table)
Column Name | Data Type | Attribute |
---|---|---|
MediaTimeStamp | TIMESTAMP | nullable |
MediaState | INTEGER | nullable |
MediaNVDCmds | INTEGER | nullable |
MediaDurSeconds | INTEGER | nullable |
MediaDurFrames | INTEGER | nullable |
MediaFrameRate | INTEGER | nullable |
MediaBitRate | INTEGER | nullable |
MediaCopyRate | INTEGER | nullable |
MediaNumUsers | INTEGER | nullable |
MediaType | VARCHAR(16) | nullable |
MediaResolution | VARCHAR(16) | nullable |
MediaStandard | VARCHAR(16) | nullable |
MediaFormat | VARCHAR(16) | nullable |
MediaAssetGrp | VARCHAR(120) | nullable |
The ICMSTRESOURCEMGR table contains one entry for each resource manager
defined to the system.
Column Name | Data Type | Attribute |
---|---|---|
RMCode | SMALLINT | NOT null |
RMPlatform | SMALLINT | NOT null |
UserID | CHAR(32) | NOT null |
Changed | TIMESTAMP | NOT null |
RMFlags | SMALLINT | NOT null |
TokenDuration | INTEGER | NOT null |
DomainID | INTEGER | NOT null |
RMUserID | CHAR(32) | nullable |
RMPassword | CHAR(72) FOR BIT DATA | nullable |
RMName | VARCHAR(128) | NOT null |
INetAddr | VARCHAR(128) | NOT null |
CurrentVersion | VARCHAR(128) | NOT null |
CacheObjSizeLimit | FLOAT | NOT null |
Unique Index RMName Index None
Foreign Key = DomainID references ICMSTAdminDomains (DomainID) on delete restrict
Column Definitions
Your system administrator provides number of seconds of object token pertaining to this resource manager.
The ICMSTRMACCESSTYPES table contains one entry for each access protocol
type that the resource manager supports in the system.
Column Name | Data Type | Attribute |
---|---|---|
RMCode | SMALLINT | NOT null |
RMAccessType | INTEGER | NOT null |
Port | INTEGER | NOT null |
AccessData | VARCHAR(128) | nullable |
Unique Index None Index None
Foreign key = (RMCode) references ICMSTRESOURCEMGR on delete cascade
Column Definitions
Your application can provide or update this column.
The ICMSTCOLLNAME table maintains all collection names that can be used by
each resource manager. It contains one entry for each collection name
used within an resource manager. Thus, if a collection name is used
within 2 different resource managers, 2 entries must be created, one for each
resource manager.
Column Name | Data Type | Attribute |
---|---|---|
RMCode | SMALLINT | NOT null |
SmsCollCode | SMALLINT | NOT null |
UserID | CHAR(32) | NOT null |
Created | TIMESTAMP | NOT null |
PrefetchInd | SMALLINT | NOT null |
DomainID | INTEGER | NOT null |
SmsCollName | VARCHAR(254) | NOT null |
Unique Index (RMCode asc, SmsCollName asc) Index None
Foreign key = RMCode references ICMSTRESOURCEMGR on delete restrict Foreign Key = DomainID references ICMSTAdminDomains (DomainID) on delete restrict
Column Definitions
Your application cannot update this field.
The ICMSTMIMETYPES table contains one entry for each MIME type defined to
the system.
Column Name | Data Type | Attribute |
---|---|---|
MIMETypeID | INTEGER | NOT null |
MIMETypeFlags | INTEGER | NOT null |
MIMEType | VARCHAR(254) | nullable |
Application | VARCHAR(512) | nullable |
ApplicationFlags | VARCHAR(512) | nullable |
Suffixes | VARCHAR(512) | nullable |
Unique Index MIMEType ASC Index None
Column Definitions
Bit positions are counted from right to left. Counting starts with number 0, so the rightmost bit is bit number 0 and the leftmost bit is bit number 31. Flags using multiple bits are read from left to right within the bit positions they occupy. For example, if bits 0 and 1 are said to have the value 10, that indicates that bit 1 is 1 and bit 0 is 0.
The bit settings are as follows:
The ICMSTITEMEVENTS table contains records of item CRUD events logged by
server depends on the ItemEventFlag in the Item Type Definition Table
(ICMSTITEMTYPEDEFS). Events may relate to actions of library users when
working on items. After data for an event is created, it cannot be
updated.
Column Name | Data Type | Attribute |
---|---|---|
EventCode | INTEGER | NOT null |
Created | TIMESTAMP | NOT null |
ItemID | CHAR(26) | NOT null |
UserID | CHAR(32) | NOT null |
EventData1 | VARCHAR(254) | nullable |
EventData2 | VARCHAR(254) | nullable |
EventData3 | VARCHAR(254) | nullable |
EventData4 | VARCHAR(254) | nullable |
EventData5 | VARCHAR(254) | nullable |
Unique Index None Index Index = (ItemID asc, Created desc, EventCode asc)
Column Definitions
The value for ItemID is generated in content manager the application requests to create an item.
This column cannot be updated by your application.
The ICMSTSYSADMEVENTS table contains records of System Administration
events logged by server depends on SysAdminEventFlag in the System Control
table (ICMSTSYSCONTROL). Events may relate to actions of library system
administrator. After data for an event is created, it cannot be
updated.
Column Name | Data Type | Attribute |
---|---|---|
EventCode | INTEGER | NOT null |
Created | TIMESTAMP | NOT null |
UserID | CHAR(32) | NOT null |
EventData1 | VARCHAR(254) | nullable |
EventData2 | VARCHAR(254) | nullable |
EventData3 | VARCHAR(254) | nullable |
EventData4 | VARCHAR(254) | nullable |
EventData5 | VARCHAR(254) | nullable |
|Unique Index |None |Index |Index = (Created desc, EventCode asc)
Column Definitions
The ICMSTTEXINDEXCONF table contains text search information of each text
searchable column. Rows are inserted into this table be
defineCompType. These values are used by defineTIEIndex SP to create
and update indexes.
Column Name | Data Type | Attribute |
---|---|---|
ComponentTypeID | INTEGER | NOT null |
CCSID | INTEGER | nullable |
ModelCCSID | INTEGER | nullable |
MinChanges | INTEGER | nullable |
CommitCount | INTEGER | nullable |
LanguageCode | CHAR(5) | nullable |
Format | VARCHAR(30) | nullable |
ColumnName | VARCHAR(18) | NOT null |
IndexName | VARCHAR(18) | NOT null |
SchemaName | VARCHAR(128) | NOT null |
UpdateFeq | VARCHAR(300) | nullable |
IndexDir | VARCHAR(254) | nullable |
WorkingDir | VARCHAR(254) | nullable |
ModelName | VARCHAR(254) | nullable |
ModelFile | VARCHAR(254) | nullable |
UDFName | VARCHAR(18) | nullable |
UDFSchema | VARCHAR(18) | nullable |
Unique Index None Index None
Foreign key = (ComponentTypeID) references ICMSTCompDefs (ComponentTypeID) on delete cascade
Column Definitions
For these formats, you can specify the structure information in a document model file, If not specified, the whole document's text is indexed.
A document model is bound to a document format that supports structures (HTML, XML, GPP). Only one document model may be specified in a model file. Document models need not to be referenced in search conditions, all section names in the model file can be used in search conditions. The document model will only be read during the creation of the text index. Any later changes are not recognized for this index.
This is used by CM to handle the indexing of documents stored in the resource manager. When indexing the content of resource manager documents, the UDF name is set to ICMFetchContent.
For more details on these fields see the TIE Reference.
The ICMSTXDOOBJECTS table contains XDO class definitions and Java(TM) XDO
class name in the system.
Column Name | Data Type | Attribute |
---|---|---|
XDOClassID | INTEGER | NOT null |
AttributeGroup | INTEGER | NOT null |
XDOClassName | VARCHAR(254) | NOT null |
XDOClassDesc | VARCHAR(254) | nullable |
JavaXDOClassName | VARCHAR(254) | nullable |
Unique Index XDOClassName Index None
Column Definitions
The ICMSTXDOOBJFACTORY table contains XDO object factories in the
system.
Column Name | Data Type | Attribute |
---|---|---|
XDOClassID | INTEGER | NOT null |
SystemType | SMALLINT | NOT null |
CompileOption | SMALLINT | NOT null |
CPPXDOFactory | VARCHAR(254) | nullable |
Unique Index None Index None
Foreign Key = XDOClassID references ICMSTXDOOBJECTS (XDOClassID) on delete cascade
Column Definitions
The ICMSTRI0nnnsss table (where nnn is LibraryID and
sss is SysSegmentID) maintains the Referential Integrity of all the
references exist within the content manager.
Column Name | Data Type | Attribute |
---|---|---|
SourceItemID | CHAR(26) | NOT null |
SourceItemTypeID | INTEGER | NOT null |
SourceCompID | CHAR(18) | NOT null |
SourceCompTypeID | INTEGER | NOT null |
SourceVersionID | SMALLINT | NOT null |
TargetItemID | CHAR(26) | NOT null |
TargetItemTypeID | INTEGER | NOT null |
TargetCompID | CHAR(18) | NOT null |
TargetCompTypeID | INTEGER | NOT null |
TargetVersionID | SMALLINT | NOT null |
RRIID | CHAR(26) | NOT null |
Status | SMALLINT | NOT null |
(SourceItemID ASC, SourceCompID ASC, SourceVersionID ASC, SourceCompTypeID ASC) (TargetItemID ASC, TargetVersionID ASC, TargetCompID ASC, TargetCompTypeID ASC) Unique Index None Index None
Column Definitions
The ICMSTREPLICARULES table contains all source and target replication
relationships information.
Column Name | Data Type | Attribute |
---|---|---|
SourceRMCode | SMALLINT | NOT null |
SourceSmsCollCode | SMALLINT | NOT null |
TargetRMCode | SMALLINT | NOT null |
TargetSmsCollCode | SMALLINT | NOT null |
Priority | SMALLINT | NOT null |
|Unique Index |(SourceRMCode, SourceSmsCollCode, Priority) |Index |None
CHECK (NOT (SourceRMCode = TargetRMCode AND SourceSMSCollCode = TargetSmsCollCode)) CHECK (SourceRMCode> 0 AND SourceSmsCollCode > 0 AND TargetRMCode > 0 AND TargetSmsCollCode > 0)
|FOREIGN KEY (SourceRMCode, SourceSmsCollCode) | REFERENCES ICMSTCOLLNAME (RMCode, SmsCollCode) | ON DELETE CASCADE, | |FOREIGN KEY (TargetRMCode, TargetSmsCollCode) | REFERENCES ICMSTCOLLNAME (RMCode, SmsCollCode) | ON DELETE CASCADE
Column Definitions
The ICMSTREPLICAS table contains items with the replica rules
applied. As long as a replica is inserted, it can't be deleted
unless this item is removed by deleteItem function. Moreover, no
replicas are added or removed during updateItem time.
Column Name | Data Type | Attribute |
---|---|---|
ItemID | CHAR(26) | NOT null |
VersionID | SMALLINT | NOT null |
RMCode | SMALLINT | NOT null |
SmsCollCode | SMALLINT | NOT null |
ResourceFlag | SMALLINT | NOT null |
ResourceLength | FLOAT | NOT null |
ObjectCreated | TIMESTAMP | NOT null |
ObjectUpdated | TIMESTAMP | NOT null |
Priority | SMALLINT | NOT null |
|Unique Index |(ItemID, VersionID, Priority) |Index |None
FOREIGN KEY (RMCode, SMSCollCode) REFERENCES ICMSTCOLLNAME (RMCode, SmsCollCode) ON DELETE RESTRICT
Column Definitions
|Bit positions are counted from right to left. Counting starts with |number 0, so the rightmost bit is bit number 0 and the leftmost bit is bit |number 15. Flags using multiple bits are read from left to right within |the bit positions they occupy. For example, if bits 0 and 1 are said to |have the value 10, that indicates that bit 1 is 1 and bit 0 is 0.
|The default value is only CM Managed on (0x00000002). Your
|application cannot update this field except as a side effect of other
|actions. The bit settings are as follows:
|
Bit | Name | Description |
---|---|---|
Bit 0 | Non CM Managed | Indicates that the entry in this table is managed by the external system. It is stored externally to the system, and exists in some external location (pointed to by the ExtObjectName column in this table). The value 01 indicates that the resource is NOT Content Manager managed. The values 00 and 11 are reserved. |
Bit 1 | CM Managed | Indicates that the resource represented by this entry in this table is managed by the Content Manager subsystem. Meaning, it is stored within the library and managed by a resource manager known to the library. A value of 10 indicates that the resource is Content Manager managed. The values 00 and 11 are reserved. |
Bit 2 | No Content | Currently has no actual data containing object associated with it yet (no object with an underlining itemID / versionID on this RM/Coll). Resources in this state have placeholders in the library and resource managers and SMS collections associated with them, however an actual object has not yet been stored in an resource manager. Resources in this state are later replaced with actual data objects while retaining all other information given when the resource was stored with no content. |
Bit 3 | Waiting Replicator | This RM/Coll is waiting for the replicator, which has the latest object to copy or replace over. |
Bit 4 | Asynchronous Copy Pending | Used for the AsyncStore process. The OOAPI sets it on for an RM AsyncStore start, and the RM turns it off whenever AsyncStore completes (regardless success or failure). During the time between the asynchronous store request and its actual completion, no other actions can be performed on this resource. |
Bit 5 | Asynchronous Replace Pending | CM toggles this on for an RM AsyncReplace start, and the RM turns it off whenever AsyncReplace completes (regardless success or failure). During the time between the asynchronous replace request and its actual completion, no other actions can be performed on this resource. |
Bit 6 | External Object | Indicates that the object name cannot be derived from ItemID, ResourceNum and VersionNum. the actual name of the object can be found in ExtObjectName column. |
Bit 7 | Replicas Exist | Indicates that this is a Replica RM. By default, this bit is on. |
Bit 8 | Asynchronous Failure | The AsyncStore or AsyncReplace process failed. |
Before calling ICMCreateItem to create the process, you must define process
name, process description, menu name, menu description to get the process ID,
menu ID. A Process consists of a root row and child rows which define
the route.
Table 54. Root table: RoutingProcess (200)
Attr ID | Attribute | SQL type | Attribute flag | BaseView |
---|---|---|---|---|
200 | ProcessName | Char(32) | Not Null Unique | Yes |
201 | ProcessDescription | Char(256) | Not Null | Yes |
Table 55. Child table: RoutingSteps (201)
Attr ID | Attribute | SQL type | Attribute flag | BaseView |
---|---|---|---|---|
202 | FromWNItemID | Char(26) | nullable | Yes |
203 | ToWNItemID | Char(26) | nullable | Yes |
204 | MenuName | Char(32) | nullable | No |
Before calling ICMCreateItem to create a work node, you must define work
node name and work node description to get the work node ID. A work
node item consists of a root row (that defines the work nodes characteristic)
and child rows in several tables (to define work packages currently located at
this work node).
Table 56. Root table: WorkNode (202)
Attr ID | Attribute | SQL type | Attribute flag | BaseView |
---|---|---|---|---|
205 | WorkNodeName | Char(32) | not null unique | Yes |
206 | WorkNodeDescription | Char(256) | not null | Yes |
207 | WorkNodeType | smallint | not null | Yes |
208 | MaxNodeTime | Integer | not null | Yes |
209 | OverloadLimit | Integer | not null | Yes |
210 | OverloadDllPath | varchar(256) | nullable | No |
211 | OverloadFunc | varchar(128) | nullable | No |
212 | EnterDllPath | varchar(256) | nullable | No |
213 | EnterFunc | varchar(128) | nullable | No |
214 | LeaveDllPath | varchar(256) | nullable | No |
215 | LeaveFunc | varchar(128) | nullable | No |
Table 57. Child table: CollectionResumeList (203)
Attr ID | Attribute | SQL type | Attribute flag | BaseView |
---|---|---|---|---|
216 | FolderITID | Integer | Not Null | Yes |
217 | RequiredITID | Integer | Not Null | Yes |
218 | QuantityNeeded | Integer | Not Null | Yes |
If a work node is a collection point, then it must have a resume list. This table is used for this purpose. Since different folder types (such as Item type) can come to a collection point, this table should identify the resume list each folder type. Each resume list identifies which item type the folder needs, and how many documents you need to satisfy the collection point requirement.
Table 58. Child table: WorkPackage (204)
Attr ID | Attribute | SQL type | Attribute flag | BaseView |
---|---|---|---|---|
219 | Priority | Integer | Not Null | Yes |
220 | ProcessItemID | Char(26) | Not Null | Yes |
221 | ProcessLastChg | TimeStamp | Not Null | Yes |
222 | LastAccUserID | Char(32) | Not Null | Yes |
223 | LastAccTime | TimeStamp | Not Null | Yes |
217 | NotifyFlag | Smallint | Not Null | Yes |
225 | NotifyTime | TimeStamp | Nullable | Yes |
226 | SuspendFlag | Smallint | Not Null | Yes |
227 | ResumeTime | TimeStamp | Nullable | Yes |
228 | AssignedUserID | Char(32) | Nullable | Yes |
100 | Attribute 100 | Char(26) | Not Null | Yes |
101 | Attribute 101 | Integer | Not Null | Yes |
105 | Attribute 105 | TimeStamp | Not Null | Yes |
110 | Attribute 110 | Integer | Not Null | Yes |
115 | Attribute 115 | SmallInt | Not Null | Yes |
120 | Attribute 120 | Char(26) | Not Null | Yes |
Each work node contains work packages. A work package is modeled as a child component of a work node. This child component has two direct child components: ItemResumeList to hold the item resume list, and ContainerData to hold the container data information
The following reference attributes refer to the item ID that is being routed by this work package.
Table 59. Child table: ItemResumeList (205)
Attr ID | Attribute | SQL type | Attribute flag | BaseView |
---|---|---|---|---|
217 | RequiredITID | Integer | Not Null | Yes |
218 | QuantityNeeded | Integer | Not Null | Yes |
Content Manger Version 7 supports a feature called suspend. This forces folder items into a non-collection point work node and suspends the arrival of other items. This table is used for this purpose.
Table 60. Child table: ContainerData (208)
Attr ID | Attribute | SQL type | Attribute flag | BaseView |
---|---|---|---|---|
238 | ContainerDataName | Char(32) | nullable | Yes |
239 | ContainerDataVal | Varchar(254) | nullable | Yes |
Holds container data for a work package. Carries name and value pairs as provided by client applications (for example, LastAction/Approve).
Before calling ICMCreateItem to create a work list, you must define work
list name and work list description to get the WorkListID.
Table 61. Child table: ContainerData (208)
Attr ID | Attribute | SQL type | Attribute flag | BaseView |
---|---|---|---|---|
238 | ContainerDataName | Char(32) | Not Null | Yes |
239 | ContainerDataVal | Varchar(254) | Not Null | Yes |
Table 62. Root table: WorkList (206)
Attr ID | Attribute | SQL type | Attribute flag | BaseView |
---|---|---|---|---|
229 | WorkListName | Char(32) | Not Null Unique | Yes |
230 | WorkListDescription | Char(256) | Not Null | Yes |
231 | SelectionOrder | smallint | Not Null | Yes |
232 | SuspendedFilter | smallint | Not Null | Yes |
233 | NotifiedFilter | smallint | Not Null | Yes |
234 | ReturnSize | integer | Not Null | Yes |
235 | AssignFilter | smallint | Not Null | Yes |
Table 63. Child table: WorkNodeList (207)
Attr ID | Attribute | SQL type | Attribute flag | BaseView |
---|---|---|---|---|
236 | WorkNodeItemID | Char(26) | Not Null | Yes |
237 | WorkNodeOrder | smallint | Not Null | Yes |
This table holds information that describes level and history and
platform. It is currently only used to aid migrations from level to
level.
Column Name | Data Type | Attribute |
---|---|---|
Platform | CHAR(17) | NOT null |
Version | INTEGER | NOT null |
LastUpdated | TIMESTAMP | NOT null |
Created | TIMESTAMP | NOT null |
Column Definitions
Table 65. Content Manager versions
Version | Product |
---|---|
1 | Content Manager Version 6 |
2 | Content Manager Version 7 |
3 | Content Manager Version 8 |
This table holds user information (one for each RMServer entry). It
is not designed to hold multiple users for any given server.
Column Name | Data Type | Attribute |
---|---|---|
ACC_USERID | SMALLINT | NOT null |
ACC_USERNAME | CHAR(32) | NOT null |
ACC_PASSWORD | CHAR(128) FOR BIT DATA | NOT null |
ACC_PUBLIC_KEY | VARCHAR(3800) FOR BIT DATA | NOT null WITH DEFAULT '', |
Unique Index None Index None
Column Definitions
This table holds server information including itself. It extends use
of Content Manager Version 6, and replaces the FRNOLINT.
Column Name | Data Type | Attribute |
---|---|---|
SVR_SERVERID | SMALLINT | NOT null |
SVR_SERVERTYPE | CHAR(4) | NOT null |
SVR_SERVERNAME | CHAR(32) | NOT null |
SVR_PROTOCOL | CHAR(5) | NOT null |
SVR_USERID | SMALLINT | NOT null |
SVR_HOSTNAME | VARCHAR(254) | NOT null |
SVR_PORT | INTEGER | NOT null |
SVR_SCHEMA | CHAR(32) | NOT null |
SVR_PATH | CHAR(254) | NOT null |
SVR_SERPLATFORM | CHAR(17) | NOT null |
Unique Index IDX_BOS_NAME ON RMSERVER (SVR_SERVERNAME ASC); Index None
FOREIGN KEY (SVR_USERID) REFERENCES RMACCESS ON DELETE RESTRICT ON UPDATE RESTRICT
CREATE TRIGGER RMSERVER_CASECHECK NO CASCADE BEFORE INSERT ON RMSERVER REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL WHEN (LCASE(N.SVR_SERVERNAME) = (SELECT LCASE(SVR_SERVERNAME) FROM RMSERVER WHERE LCASE(N.SVR_SERVERNAME) = LCASE(SVR_SERVERNAME))) SIGNAL SQLSTATE '75000' ('Servername already exists') ;
Column Definitions
This table holds one row for each physical file managed or
referencable.
Column Name | Data Type | Attribute |
---|---|---|
OBJ_LIBRARYID | SMALLINT | NOT null |
OBJ_ITEMID | CHAR(26) | NOT null |
OBJ_VERSION | SMALLINT | NOT null WITH DEFAULT 1 |
OBJ_COLLECTIONID | INTEGER | NOT null |
OBJ_MGTCLASSID | SMALLINT | NOT null |
OBJ_STGCLASSID | SMALLINT | NOT null |
OBJ_ATTRIBUTES | SMALLINT | NOT null WITH DEFAULT 0 |
OBJ_RETENTION | INTEGER | NOT null WITH DEFAULT 0 |
OBJ_VOLUMEID | INTEGER | NOT null |
OBJ_STAGEDVOLUMEID | INTEGER | NOT null WITH DEFAULT -1 |
OBJ_PATH | INTEGER | NOT null |
OBJ_STATUS | CHAR | NOT null |
OBJ_SIZE | BIGINT | NOT null |
OBJ_CREATEDATE | TIMESTAMP | NOT null WITH DEFAULT CURRENT TIMESTAMP |
OBJ_UPDATEDATE | TIMESTAMP | NOT null WITH DEFAULT CURRENT TIMESTAMP |
OBJ_REFERENCEDDATE | TIMESTAMP | NOT null WITH DEFAULT CURRENT TIMESTAMP |
OBJ_ACTIONDATE | DATE | NOT null |
OBJ_MGTCLASSDATE | DATE | NOT null |
OBJ_STGCLASSDATE | DATE | NOT null |
OBJ_PLAYSTATUS | CHAR | NOT null |
OBJ_VOLSTATUS | CHAR | NOT null |
OBJ_OBJECTNAME | VARCHAR(128) | NOT null WITH DEFAULT '' |
OBJ_ORGFILENAME | VARCHAR(128) | NOT null WITH DEFAULT '' |
OBJ_FILENAME | VARCHAR(128) | NOT null WITH DEFAULT '' |
OBJ_MIMETYPE | VARCHAR(128) | NOT null WITH DEFAULT 'text/html' |
Unique Index None Index IDX_OBJ_ACTION ON RMOBJECTS ( OBJ_ACTIONDATE ASC ); IDX_OBJ_VOLUME ON RMOBJECTS ( OBJ_VOLUMEID ASC );
(OBJ_LIBRARYID) REFERENCES RMSERVER ON DELETE RESTRICT ON UPDATE RESTRICT ) IN OBJECTS;
Column Definitions
This table holds the device manager information.
Column Name | Data Type | Attribute |
---|---|---|
DEV_DEVMGRID | SMALLINT | NOT null |
DEV_DEVMGRNAME | CHAR(32) | NOT null |
DEV_ENABLE | CHAR | NOT null |
DEV_DESCRIPTION | VARCHAR(80) | NOT null |
DEV_PARAMETERS | VARCHAR(254) | NOT null |
DEV_CLASS | VARCHAR(254) | NOT null |
Unique Index IDX_DEV_DEVMGRNAME ON RMDEVMGR (DEV_DEVMGRNAME ASC); Index None
Column Definitions
This table holds the name of this storage group. See RMStgGrpClass
and RMStgGrpVolume.
Column Name | Data Type | Attribute |
---|---|---|
STG_STGGROUPID | SMALLINT | NOT null |
STG_STGGROUPNAME | CHAR(32) | NOT null |
Unique Index IDX_STG_STGGRPNAME ON RMSTORAGEGROUP ( STG_STGGROUPNAME ASC ); Index None
Column Definitions
This table holds the name of the management class.
Column Name | Data Type | Attribute |
---|---|---|
MGC_MGTCLASSID | SMALLINT | NOT null |
MGC_MGTCLASSNAME | CHAR(32) | NOT null |
Unique Index IDX_MGC_MGTCLSNAME ON RMMGTCLASS (MGC_MGTCLASSNAME ASC); Index None
Column Definitions
This table defines a collection. A collection is a storage endpoint
for the LS.
Column Name | Data Type | Attribute |
---|---|---|
COL_COLLID | INTEGER | NOT null |
COL_COLLNAME | CHAR(44) | NOT null |
COL_STGGROUPID | SMALLINT | NOT null |
COL_MGTCLASSID | SMALLINT | NOT null |
Unique Index IDX_COL_COLLNAME ON RMCOLLECTIONS ( COL_COLLNAME ASC ); Index None
FOREIGN KEY (COL_STGGROUPID) REFERENCES RMSTORAGEGROUP ON DELETE RESTRICT ON UPDATE RESTRICT, FOREIGN KEY (COL_MGTCLASSID) REFERENCES RMMGTCLASS ON DELETE RESTRICT ON UPDATE RESTRICT
Column Definitions
This table defines a Storage Class.
Column Name | Data Type | Attribute |
---|---|---|
STC_STGCLASSID | SMALLINT | NOT null |
STC_STGCLASSNAME | CHAR(32) | NOT null |
STC_ATTRIBUTES | INTEGER | NOT null |
STC_DEVMGRID | SMALLINT | NOT null |
STC_OBJECTSERVERID | SMALLINT | NOT null |
STC_REMOTECOLLNAME | VARCHAR(44) | NOT null |
Unique Index IDX_STC_STGCLSNAME ON RMSTORAGECLASS ( STC_STGCLASSNAME ASC ); Index None
FOREIGN KEY (STC_OBJECTSERVERID) REFERENCES RMSERVER ON DELETE RESTRICT ON UPDATE RESTRICT FOREIGN KEY (STC_DEVMGRID) REFERENCES RMDEVMGR ON DELETE RESTRICT ON UPDATE RESTRICT
Column Definitions
This table defines strings used as first part of path to documents.
Column Name | Data Type | Attribute |
---|---|---|
STR_STRINGID | INTEGER | NOT null |
STR_USECNT | INTEGER | NOT null |
STR_STRING | VARCHAR(254) | NOT null |
Unique Index None Index None
Column Definitions
This table holds the customer configuration information.
Column Name | Data Type | Attribute |
---|---|---|
CTL_CONFIGID | CHAR(16) | NOT null |
CTL_CONFIGACTIVE | CHAR | NOT null |
CTL_DESCRIPTION | CHAR(80) | NOT null |
CTL_LIBTIMEOUT | INTEGER | NOT null |
CTL_CLIENTTIMEOUT | INTEGER | NOT null |
CTL_PURGERTIMEOUT | INTEGER | NOT null |
CTL_MOUNTTIMEOUT | INTEGER | NOT null |
CTL_PURGERCYCLE | SMALLINT | NOT null |
CTL_MIGRATORCYCLE | SMALLINT | NOT null |
CTL_MIGTHRESHCYCLE | SMALLINT | NOT null |
CTL_STAGERCYCLE | SMALLINT | NOT null |
CTL_PURGERBATCHSIZE | SMALLINT | NOT null |
CTL_STAGEBATCHSIZE | SMALLINT | NOT null |
CTL_MIGRABATCHSIZE | SMALLINT | NOT null |
CTL_MIGSTARTMON | CHAR(4) | NOT null |
CTL_MIGMONMINS | SMALLINT | NOT null |
CTL_MIGSTARTTUE | CHAR(4) | NOT null |
CTL_MIGTUESMINS | SMALLINT | NOT null |
CTL_MIGSTARTWED | CHAR(4) | NOT null |
CTL_MIGWEDMINS | SMALLINT | NOT null |
CTL_MIGSTARTTHURS | CHAR(4) | NOT null |
CTL_MIGTHURSMINS | SMALLINT | NOT null |
CTL_MIGSTARTFRI | CHAR(4) | NOT null |
CTL_MIGFRIMINS | SMALLINT | NOT null |
CTL_MIGSTARTSAT | CHAR(4) | NOT null |
CTL_MIGSATMINS | SMALLINT | NOT null |
CTL_MIGSTARTSUN | CHAR(4) | NOT null |
CTL_MIGSUNMINS | SMALLINT | NOT null |
CTL_REPLICATECYCLE | SMALLINT | NOT null |
CTL_REPBATCHSZE | SMALLINT | NOT null |
CTL_REPSTARTMON | CHAR(4) | NOT null |
CTL_REPMONMINS | SMALLINT | NOT null |
CTL_REPSTARTTUE | CHAR(4) | NOT null |
CTL_REPTUESMINS | SMALLINT | NOT null |
CTL_REPSTARTWED | CHAR(4) | NOT null |
CTL_REPWEDMINS | SMALLINT | NOT null |
CTL_REPSTARTTHURS | CHAR(4) | NOT null |
CTL_REPTHURSMINS | SMALLINT | NOT null |
CTL_REPSTARTFRI | CHAR(4) | NOT null |
CTL_REPFRIMINS | SMALLINT | NOT null |
CTL_REPSTARTSAT | CHAR(4) | NOT null |
CTL_REPSATMINS | SMALLINT | NOT null |
CTL_REPSTARTSUN | CHAR(4) | NOT null |
CTL_REPSUNMINS | SMALLINT | NOT null |
Unique Index None Index None
Column Definitions
This table holds work records for the replication to be done.
Column Name | Data Type | Attribute |
---|---|---|
REP_LIBRARYID | SMALLINT | NOT null |
REP_ITEMID | CHAR(26) | NOT null |
REP_VERSION | SMALLINT | NOT null |
REP_COLLID | INTEGER | NOT null |
REP_COLLNAME | CHAR(26) | NOT null |
REP_OBJSERVERID | SMALLINT | NOT null |
REP_REPLICATETYPE | CHAR(1) | NOT null |
REP_SIZE | BIGINT | NOT null |
REP_UPDATEDATE | TIMESTAMP | NOT null |
Unique Index None Index None
Column Definitions
This table holds the definition of the staging area. This table only
contains one row.
Column Name | Data Type | Attribute |
---|---|---|
STA_ID | SMALLINT | NOT null |
STA_SIZE | BIGINT | NOT null |
STA_SPACEUSED | BIGINT | NOT null |
STA_PERCENTSTART | SMALLINT | NOT null |
STA_PERCENTSTOP | SMALLINT | NOT null |
STA_SERVERACTIVE | CHAR | NOT null |
STA_PATH | VARCHAR(1023) | NOT null |
Unique Index None Index None
Column Definitions
This table holds volume information on system and virtual volumes.
Column Name | Data Type | Attribute |
---|---|---|
VOL_VOLUMEID | INTEGER | NOT null |
VOL_SERIAL | INTEGER | NOT null |
VOL_STGCLASSID | SMALLINT | NOT null |
VOL_ATTRIBUTES | SMALLINT | NOT null |
VOL_MEDIATYPE | SMALLINT | NOT null |
VOL_SERVERID | SMALLINT | NOT null |
VOL_SIZE | BIGINT | NOT null |
VOL_FREESPACE | BIGINT | NOT null |
VOL_STATUS | CHAR | NOT null |
VOL_THRESHOLD | SMALLINT | NOT null |
VOL_NUMBUCKETS | SMALLINT | NOT null |
VOL_REFERENCEDDATE | DATE | NOT null |
VOL_LOGICALNAME | CHAR(254) | NOT null |
VOL_MOUNTPOINT | VARCHAR(1023) | NOT null |
VOL_PATH | VARCHAR(1023) | NOT null |
VOL_OFFLINELOC | VARCHAR(128) | NOT null |
Unique Index IDX_VOL_VOLSER ON RMVOLUMES ( VOL_LOGICALNAME ASC ); Index None
FOREIGN KEY (VOL_STGCLASSID) REFERENCES RMSTORAGECLASS ON DELETE RESTRICT ON UPDATE RESTRICT, FOREIGN KEY (VOL_SERVERID) REFERENCES RMSERVER ON DELETE RESTRICT ON UPDATE RESTRICT
Column Definitions
This table holds links of storage group to volume.
Column Name | Data Type | Attribute |
---|---|---|
SGV_STGGROUPID | SMALLINT | NOT null |
SGV_VOLUMEID | INTEGER | NOT null |
Unique Index None Index None
FOREIGN KEY (SGV_STGGROUPID) REFERENCES RMSTORAGEGROUP ON DELETE RESTRICT ON UPDATE RESTRICT, FOREIGN KEY (SGV_VOLUMEID) REFERENCES RMVOLUMES ON DELETE RESTRICT ON UPDATE RESTRICT
Column Definitions
This table holds links of storage group to storage class.
Column Name | Data Type | Attribute |
---|---|---|
SGC_STGGROUPID | SMALLINT | NOT null |
SGC_STGCLASSID | SMALLINT | NOT null |
Unique Index None Index None
FOREIGN KEY (SGC_STGGROUPID) REFERENCES RMSTORAGEGROUP ON DELETE RESTRICT ON UPDATE RESTRICT, FOREIGN KEY (SGC_STGCLASSID) REFERENCES RMSTORAGECLASS ON DELETE RESTRICT ON UPDATE RESTRICT
Column Definitions
This table holds links of storage group to storage class.
Column Name | Data Type | Attribute |
---|---|---|
MGP_MGTCLASSID | SMALLINT | NOT null |
MGP_SEQUENCENUM | SMALLINT | NOT null |
MGP_STGCLASSID | SMALLINT | NOT null |
MGP_SINCEENTER | INTEGER | NOT null |
Unique Index IDX_MGP_MGTSTGCLS ON RMMGTTRANSITION ( MGP_MGTCLASSID ASC, MGP_STGCLASSID ASC ); Index None
FOREIGN KEY (MGP_MGTCLASSID) REFERENCES RMMGTCLASS ON DELETE RESTRICT ON UPDATE RESTRICT, FOREIGN KEY (MGP_STGCLASSID) REFERENCES RMSTORAGECLASS ON DELETE RESTRICT ON UPDATE RESTRICT
Column Definitions
This table holds one row for each table in the RM system.
Column Name | Data Type | Attribute |
---|---|---|
LastReorgTS | TIMESTAMP | NOT null |
ReorgIndicator | SMALLINT | NOT null |
ServerType | CHAR(4) | NOT null |
TableName | VARCHAR(27) | NOT null |
IndexName | VARCHAR(27) | NOT null |
Column Definitions
Column Name | Data Type | Attribute |
---|---|---|
SCH_SYNCSCHEDID | INTEGER | NOT null |
SCH_SYNCENABLE | CHAR | NOT null |
SCH_SYNCATTRIBUTES | INTEGER | NOT null |
SCH_SYNCSHEDYY | SMALLINT | NOT null |
SCH_SYNCSHEDMM | SMALLINT | NOT null |
SCH_SYNCSHEDDD | SMALLINT | NOT null |
SCH_SYNCSTARTTIME | CHAR(4) | NOT null |
SCH_SYNCSHEDMINUTE | SMALLINT | NOT null |
Column Name | Data Type | Attribute |
---|---|---|
STS_SYNCSTATUSID | INTEGER | NOT null |
STS_SYNCATTRIBUTES | INTEGER | NOT null |
STS_SYNCERRMSG | VARCHAR(300) | NOT null |
Column Name | Data Type | Attribute |
---|---|---|
RPT_SYNCREPORTID | INTEGER | NOT null |
RPT_SYNCATTRIBUTES | INTEGER | NOT null |
RPT_SYNCTOTALCOUNT | INTEGER | NOT null |
RPT_SYNCERRORCOUNT | INTEGER | NOT null |
RPT_SYNCSTARTDATE | VARCHAR(35) | NOT null |
RPT_SYNCENDDATE | VARCHAR(35) | NOT null |
Unique Index None Index None
Column Name | Data Type | Attribute |
---|---|---|
SVL_SYNCVOLID | SMALLINT | NOT null |
SVL_VOLUMEID | SMALLINT | NOT null |
Unique Index None Index None
FOREIGN KEY (SVL_VOLUMEID) REFERENCES RMVOLUMES ON DELETE RESTRICT ON UPDATE RESTRICT
Column Name | Data Type | Attribute |
---|---|---|
SPM_SYNCPARMID | SMALLINT | NOT null |
SPM_SYNCMETHOD | INTEGER | NOT null |
SPM_SYNCSTARTDATE | TIMESTAMP | NOT null |
SPM_SYNCENDDATE | TIMESTAMP | NOT null |
Unique Index None Index None
Column Name | Data Type | Attribute |
---|---|---|
PTS_LIBRARYID | SMALLINT | NOT null |
PTS_ITEMID | CHAR(26) | NOT null |
PTS_VERSION | SMALLINT | NOT null WITH DEFAULT 1 |
PTS_COLLID | INTEGER | NOT null WITH DEFAULT 0 |
PTS_OBJECTNAME | CHAR(128) | NOT null |
PTS_SIZE | BIGINT | NOT null |
PTS_CREATEDATE | TIMESTAMP | NOT null |
PTS_CHANGEDATE | TIMESTAMP | NOT null |
Unique Index None Index None
Unique Index None Index None
Column definitions
This table holds state information on a transaction.
Column Name | Data Type | Attribute |
---|---|---|
TT_LIBRARYID | SMALLINT | NOT null |
TT_ITEMID | CHAR(26) | NOT null |
TT_VERSION | SMALLINT | NOT null WITH DEFAULT 1 |
TT_COLLID | INTEGER | NOT null |
TT_TMP_ITEMID | CHAR(26) | NOT null |
TT_TMP_VERSION | SMALLINT | NOT null |
TT_TMP_COLLID | INTEGER | NOT null |
TT_TXID | CHAR(26) | NOT null |
TT_TS | TIMESTAMP | NOT null WITH DEFAULT CURRENT TIMESTAMP |
TT_STATUS | CHAR(1) | NOT null |
TT_ACTION | CHAR(1) | NOT null |
TT_LSSTATUS | CHAR(1) |
|
TT_INFO | VARCHAR(128) |
|
Unique Index None Index IDX_TT_TXID ON RMTRACKING ( TT_TXID ASC );
Column definitions
The following terms are trademarks of the International Business Machines
Corporation in the United States, other countries, or both:
AIX | DB2 | IBM |
MVS | OS/390 | SP |
VideoCharger |
|
|
Approach, Domino, Lotus, Lotus 1-2-3, Lotus Notes and SmartSuite are trademarks or registered trademarks of the Lotus Development Corporation in the United States, other countries, or both.
Intel and Pentium are trademarks or registered trademarks of Intel Corporation in the United States, other countries, or both.
Microsoft, Windows, and Windows NT are registered trademarks of Microsoft Corporation in the United States, other countries, or both.
Java and all Java-based trademarks and logos are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.
UNIX is a registered trademark of The Open Group in the United States and other countries.
Other company, product, and service names may be trademarks or service marks of others.