Records the business objects that have changed and the associated workspaces, task groups, and tasks that have made that change. This table will be used for resource locking and for determining the business objects that will be committed and published to production.
Column Description(s):
Column Name | Column Type | Description |
CMCONTAINER_ID |
INTEGER NOT NULL |
The container associated with the business object. |
CMRESMGR_ID |
INTEGER NOT NULL |
The resource manager associated with the business object. |
BOKEY1 |
BIGINT NOT NULL |
The 4 columns together eternal make up the primary key value for the business object. These 4 values with the container and manager id will uniquely identify the business object. |
BOKEY2 |
BIGINT NOT NULL |
The 4 columns together eternal make up the primary key value for the business object. These 4 values with the container and manager id will uniquely identify the business object. |
BOKEY3 |
BIGINT NOT NULL |
The 4 columns together eternal make up the primary key value for the business object. These 4 values with the container and manager id will uniquely identify the business object. |
BOKEY4 |
BIGINT NOT NULL |
The 4 columns together eternal make up the primary key value for the business object. These 4 values with the container and manager id will uniquely identify the business object. |
ACTION |
CHAR(1) NOT NULL |
The action performed on the business object (new, udpate, delete) |
CMTIMESTAMP |
TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP |
When the update was performed. |
WORKSPACE |
CHAR(25) |
The workspace identifier associated with the change. |
TASKGRP |
CHAR(25) |
The task group associated with the change. |
TASK |
CHAR(25) |
The task assoicated with the change. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
MEMBER_ID |
BIGINT |
The user who has modified the resource. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000835 |
CMCONTAINER_ID+CMRESMGR_ID+BOKEY1+BOKEY2+BOKEY3+BOKEY4 |
Non-Unique Index |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.