uCosminexus Service Platform, Setup and Operation Guide
![[Contents]](FIGURE/CONTENT.GIF)
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
(1) Table information
The following tables are required for every HCSC cluster.
- Basic information table
- Variable information table
- Message log related information table
(a) Basic information table
The basic information table stores the basic elements (instances) of business process execution.
![[Figure]](FIGURE/ZUENG030.GIF)
CSCBP_<cluster name>_PROCESS table- The contents of CSCBP_<cluster name>_PROCESS table are as follows:
| No. |
Column name |
Description |
HiRDB type |
ORACLE type |
Existence of index |
NULL value |
Update |
Default value |
| 1 |
ProcessID |
Process instance identifier |
MVARCHAR(240) |
VARCHAR2(240) |
Yes |
Not possible |
Not possible |
Not possible |
| 2 |
ProcessDefinitionName |
BP definition name |
MVARCHAR(64) |
VARCHAR2(64) |
Yes |
Not possible |
Not possible |
Not possible |
| 3 |
ProcessDefinitionVersion |
BP definition version |
SMALLINT |
NUMBER(5) |
No |
Not possible |
Not possible |
Not possible |
| 4 |
State |
Process instance status |
VARCHAR(20) |
VARCHAR2(20) |
Yes |
Not possible |
Yes |
Not possible |
| 5 |
ChangeCount#1 |
Number of data updates |
INTEGER#2 |
NUMBER(10) #3 |
No |
Not possible |
Possible |
Not possible |
| 6 |
StartTime |
Process instance Start time (GMT) |
TIMESTAMP(0) |
TIMESTAMP(0) |
Yes |
Possible |
Possible |
NULL |
| 7 |
EndTime |
Process instance end time (GMT) |
TIMESTAMP(0) |
TIMESTAMP(0) |
Yes |
Possible |
Possible |
NULL |
| 8 |
CSCServerName |
Last executed HCSC server name |
VARCHAR(8) |
VARCHAR2(8) |
Yes |
Possible |
Possible |
NULL |
| 9 |
SplitKey#4 |
Split key (GMT) |
CHAR(2) |
CHAR(2) |
Yes |
Not possible |
Not possible |
Not possible |
- Note#1
- There is no need to know the value because this item is used for internal management during execution.
- Note#2
- "SMALLINT" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "SMALLINT", since the area does not change.
- Note#3
- "NUMBER(5)" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "NUMBER(5)", since the area does not change.
- Note#4
- This column is included in SQL script file if you set up by specifying a value other than "NONE" in the db-tbl-split-key of HCSC server setup definition file. For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
-
- CSCBP_<cluster name>_ACTIVITY table
- The contents of CSCBP_<cluster name>_ACTIVITY table are as follows:
| No. |
Column name |
Description |
HiRDB type |
ORACLE Type |
Index |
NULL |
Update |
Default value |
| 1 |
ProcessID |
Process instance identifier |
MVARCHAR(240) |
VARCHAR2(240) |
Yes |
Not possible |
Not possible |
Not possible |
| 2 |
ActivityNumber |
Number to identify activity instance. Unique in process instance. |
INTEGER#2 |
NUMBER(10) #3 |
No |
Not possible |
Not possible |
Not possible |
| 3 |
ActivityDefinitionName |
Activity definition name |
MVARCHAR(64) |
VARCHAR2(64) |
No |
Not possible |
Not possible |
Not possible |
| 4 |
ActivityKind |
Activity type |
VARCHAR(16) |
VARCHAR2(16) |
No |
Not possible |
Not possible |
Not possible |
| 5 |
ParentNumber#1 |
New activity instance identifier |
INTEGER#2 |
NUMBER(10) #3 |
No |
Not possible |
Not possible |
Not possible |
| 6 |
ScopeNumber |
Identification number of the associated scope instance |
INTEGER#2 |
NUMBER(10) #3 |
No |
Not possible |
Not possible |
Not possible |
| 7 |
RepeatNumber#1 |
Identification number of the associated repeat process |
INTEGER#2 |
NUMBER(10) #3 |
No |
Not possible |
Not possible |
Not possible |
| 8 |
State |
Activity instance status |
VARCHAR(20) |
VARCHAR2(20) |
No |
Not possible |
Possible |
Not possible |
| 9 |
FirstChildNumber#1 |
Smallest identification number of child activity instance |
INTEGER#2 |
NUMBER(10) #3 |
No |
Not possible |
Possible |
Not possible |
| 10 |
LastChildNumber#1 |
Largest identification number of child activity instance |
INTEGER#2 |
NUMBER(10) #3 |
No |
Not possible |
Possible |
Not possible |
| 11 |
StartTime |
Activity instance start time (GMT) |
TIMESTAMP(0) |
TIMESTAMP(0) |
No |
Possible |
Possible |
NULL |
| 12 |
EndTime |
Activity instance end time (GMT) |
TIMESTAMP(0) |
TIMESTAMP(0) |
No |
Possible |
Possible |
NULL |
| 13 |
WaitTime |
Wait cancellation time of Activity (GMT) |
TIMESTAMP(0) |
TIMESTAMP(0) |
No |
Possible |
Possible |
NULL |
| 14 |
SplitKey#4 |
Split key (GMT) |
CHAR(2) |
CHAR(2) |
Yes |
Not possible |
Not possible |
Not possible |
- #1
- There is no need to know the value because this item is used for internal management during execution.
- #2
- "SMALLINT" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "SMALLINT", since the area does not change.
- #3
- "NUMBER(5)" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "NUMBER(5)", since the area does not change.
- #4
- This column is included in SQL script file, if you set up by specifying a value other than "NONE" in the db-tbl-split-key of HCSC server setup definition file. For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
-
- CSCBP_<cluster name>_LINK table
- The contents of CSCBP_<cluster name>_LINK table are as follows:
| No. |
Column name |
Description |
HiRDB type |
ORACLE type |
Index |
NULL |
Update |
Default value |
| 1 |
ProcessID |
Process instance identifier |
MVARCHAR(240) |
VARCHAR2(240) |
Yes |
Not possible |
Not possible |
Not possible |
| 2 |
LinkDefinitionName |
Link definition name |
MVARCHAR(64) |
VARCHAR2(64) |
Yes |
Not possible |
Not possible |
Not possible |
| 3 |
RepeatNumber#1 |
Identification number of the associated repeat process |
INTEGER#2 |
NUMBER(10) #3 |
Yes |
Not possible |
Not possible |
Not possible |
| 4 |
State |
Link status (true or false) |
CHAR(1) |
CHAR(1) |
No |
Not possible |
Not possible |
Not possible |
| 5 |
SplitKey#4 |
Split key (GMT) |
CHAR(2) |
CHAR(2) |
Yes |
Not possible |
Not possible |
Not possible |
- Note#1
- There is no need to know the value, since this item is used for internal management during execution.
- Note#2
- "SMALLINT" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "SMALLINT", since the area does not change.
- Note#3
- "NUMBER(5)" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "NUMBER(5)", since the area does not change.
- Note#4
- This column is included in SQL script file, if you set up by specifying a value other than "NONE" in the db-tbl-split-key of HCSC server setup definition file. For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
-
- CSCBP_<cluster name>_CORRELATIONSET table
- The contents of CSCBP_<cluster name>_CORRELATIONSET table are as follows:
| No. |
Column name |
Description |
HiRDB type |
ORACLE type |
Index |
NULL |
Update |
Default value |
| 1 |
ProcessID |
Process instance identifier |
MVARCHAR(240) |
VARCHAR2(240) |
Yes |
Not possible |
Not possible |
Not possible |
| 2 |
ProcessDefinitionName |
BP definition name |
MVARCHAR(64) |
VARCHAR2(64) |
Yes |
Not possible |
Not possible |
Not possible |
| 3 |
ProcessDefinitionVersion |
BP definition version |
SMALLINT |
NUMBER(5) |
No |
Not possible |
Not possible |
Not possible |
| 4 |
ScopeDefinitionName |
Scope definition name |
MVARCHAR(64) |
VARCHAR2(64) |
Yes |
Not possible |
Not possible |
Not possible |
| 5 |
ScopeNumber |
Scope instance identification number |
INTEGER#1 |
NUMBER(10) #2 |
Yes |
Not possible |
Not possible |
Not possible |
| 6 |
CorrelationSetName |
Correlation set definition name |
MVARCHAR(64) |
VARCHAR2(64) |
Yes |
Not possible |
Not possible |
Not possible |
| 7 |
CorrelationSetValue |
Correlation set value. Stringizing and linking of this value is done and then it is stored. |
MVARCHAR(512) |
VARCHAR2(512) |
Yes |
Not possible |
Not possible |
Not possible |
| 8 |
State |
Validity of correlation set (true or false) |
CHAR(1) |
CHAR(1) |
No |
Not possible |
Possible |
Not possible |
| 9 |
SplitKey#3 |
Split key (GMT) |
CHAR(2) |
CHAR(2) |
Yes |
Not possible |
Not possible |
Not possible |
- Note#1
- "SMALLINT" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "SMALLINT", since the area does not change.
- Note#2
- "NUMBER(5)" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "NUMBER(5)", since the area does not change.
- Note#3
- This column is included in SQL script file, if you set up by specifying a value other than "NONE" in the db-tbl-split-key of HCSC server setup definition file. For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
(b) Variable information table
The variable information table stores the values of user-defined variables while business processes are being executed.
- CSCBP_<cluster name>_STR_VARIABLE table
- The contents of the CSCBP_<cluster name>_STR_VARIABLE table are as follows:
| No. |
Column name |
Description |
HiRDB type |
ORACLE type |
Index |
NULL |
Update |
Default value |
| 1 |
ProcessID |
Process instance identifier |
MVARCHAR(240) |
VARCHAR2(240) |
Yes |
Not possible |
Not possible |
Not possible |
| 2 |
ScopeNumber |
Scope instance identification number |
INTEGER#1 |
NUMBER(10) #2 |
Yes |
Not possible |
Not possible |
Not possible |
| 3 |
VariableName |
Variable definition name |
MVARCHAR(64) |
VARCHAR2(64) |
Yes |
Not possible |
Not possible |
Not possible |
| 4 |
VariableValue |
Variable value |
MVARCHAR(4000) |
VARCHAR2(4000) |
No |
Possible#3 |
Possible |
Not possible |
| 5 |
SplitKey#4 |
Split key (GMT) |
CHAR(2) |
CHAR(2) |
Yes |
Not possible |
Not possible |
Not possible |
- Note#1
- "SMALLINT" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "SMALLINT", since the area does not change.
- Note#2
- "NUMBER(5)" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "NUMBER(5)", since the area does not change.
- Note#3
- In HiRDB, the null value cannot be specified, but in Oracle, the null value can be specified.
- Note#4
- This column is included in SQL script file, if you set up by specifying a value other than "NONE" in the db-tbl-split-key of HCSC server setup definition file. For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
- CSCBP_<cluster name>_NUM_VARIABLE table
- The contents of the CSCBP_<cluster name>_NUM_VARIABLE table are as follows:
| No. |
Column name |
Description |
HiRDB type |
ORACLE type |
Index |
NULL |
Update |
Default value |
| 1 |
ProcessID |
Process instance identifier |
MVARCHAR(240) |
VARCHAR2(240) |
Yes |
Not possible |
Not possible |
Not possible |
| 2 |
ScopeNumber |
Scope instance identification number |
INTEGER#1 |
NUMBER(10) #2 |
Yes |
Not possible |
Not possible |
Not possible |
| 3 |
VariableName |
Variable definition name |
MVARCHAR(64) |
VARCHAR2(64) |
Yes |
Not possible |
Not possible |
Not possible |
| 4 |
VariableValue |
Variable value |
DOUBLE PRECISION |
NUMBER |
No |
Not possible |
Possible |
Not possible |
| 5 |
SplitKey#3 |
Split key (GMT) |
CHAR(2) |
CHAR(2) |
Yes |
Not possible |
Not possible |
Not possible |
- Note#1
- "SMALLINT" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "SMALLINT", since the area does not change.
- Note#2
- "NUMBER(5)" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "NUMBER(5)", since the area does not change.
- Note#3
- This column is included in SQL script file, if you set up by specifying a value other than "NONE" in the db-tbl-split-key of HCSC server setup definition file. For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
- CSCBP_<cluster name>_BOOL_VARIABLE table
- The contents of the CSCBP_<cluster name>_BOOL_VARIABLE table are as follows:
| No. |
Column name |
Description |
HiRDB type |
ORACLE type |
Index |
NULL |
Update |
Default value |
| 1 |
ProcessID |
Process instance identifier |
MVARCHAR(240) |
VARCHAR2(240) |
Yes |
Not possible |
Not possible |
Not possible |
| 2 |
ScopeNumber |
Scope instance identification number |
INTEGER#1 |
NUMBER(10) #2 |
Yes |
Not possible |
Not possible |
Not possible |
| 3 |
VariableName |
Variable definition name |
MVARCHAR(64) |
VARCHAR2(64) |
Yes |
Not possible |
Not possible |
Not possible |
| 4 |
VariableValue |
Variable value |
CHAR(1) |
CHAR(1) |
No |
Not possible |
Possible |
Not possible |
| 5 |
SplitKey#3 |
Split key (GMT) |
CHAR(2) |
CHAR(2) |
Yes |
Not possible |
Not possible |
Not possible |
- Note#1
- "SMALLINT" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "SMALLINT" because the area does not change.
- Note#2
- "NUMBER(5)" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "NUMBER(5)", since the area does not change.
- Note#3
- This column is included in SQL script file, if you set up by specifying a value other than "NONE" in the db-tbl-split-key of HCSC server setup definition file. For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
- CSCBP_<cluster name>_MSG_VARIABLE table
- The contents of the CSCBP_<cluster name>_MSG_VARIABLE table are as follows:
| No. |
Column name |
Description |
HiRDB type |
ORACLE type |
Index |
NULL |
Update |
Default value |
| 1 |
ProcessID |
Process instance identifier |
MVARCHAR(240) |
VARCHAR2(240) |
Yes |
Not possible |
Not possible |
Not possible |
| 2 |
ScopeNumber |
Identification number of a scope instance |
INTEGER#1 |
NUMBER(10) #2 |
Yes |
Not possible |
Not possible |
Not possible |
| 3 |
VariableName |
Variable definition Name |
MVARCHAR(64) |
VARCHAR2(64) |
Yes |
Not possible |
Not possible |
Not possible |
| 4 |
VariableValue |
Variable Value |
BINARY(2147483639) |
BLOB |
No |
Possible#3 |
Possible |
Not possible |
| 5 |
SplitKey#4 |
Split key (GMT) |
CHAR(2) |
CHAR(2) |
Yes |
Not possible |
Not possible |
Not possible |
- Note#1
- "SMALLINT" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "SMALLINT", since the area does not change.
- Note#2
- "NUMBER(5)" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "NUMBER(5)", since the area does not change.
- Note#3
- In HiRDB, the null value cannot be specified. However, the null value can be specified in Oracle.
- Note#4
- This column is included in SQL script file, if you set up by specifying a value other than "NONE" in the db-tbl-split-key of HCSC server setup definition file. For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
(c) Message log related information table
The message log related information table stores the message log related data.
- CSCBP_<cluster name>_MSG_RELATION table
- The contents of the CSCBP_<cluster name>_MSG_RELATION table are as follows:
| No. |
Column name |
Description |
HiRDB type |
ORACLE type |
Index |
NULL |
Update |
Default value |
| 1 |
MessageID#1 |
Message common ID |
VARCHAR(75) |
VARCHAR2(75) |
Yes |
Not possible |
Not possible |
Not possible |
| 2 |
ProcessID#1 |
Process instance identifier |
MVARCHAR(240) |
VARCHAR2(240) |
Yes |
Not possible |
Not possible |
Not possible |
| 3 |
ActivityNumber#1 |
Identification number of an activity instance |
INTEGER#2 |
NUMBER(10) #3 |
Yes |
Not possible |
Not possible |
Not possible |
| 4 |
SendOrReceive#1 |
Send/receive flag for the message |
CHAR(1) |
CHAR(1) |
Yes |
Not possible |
Not possible |
Not possible |
| 5 |
AsynchronousMessagingID#1 |
Asynchronous messaging ID that uses Reliable Messaging |
VARCHAR(255) |
VARCHAR2(255) |
Yes |
Possible |
Not possible |
NULL |
| 6 |
SplitKey#4 |
Split key (GMT) |
CHAR(2) |
CHAR(2) |
Yes |
Not possible |
Not possible |
Not possible |
- Note#1
- There is no need to know the value, since this item is used for internal management during execution.
- Note#2
- "SMALLINT" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "SMALLINT", since the area does not change.
- Note#3
- "NUMBER(5)" in versions prior to the version 08-10.
- Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "NUMBER(5)", since the area does not change.
- Note#4
- This column is included in SQL script file, if you set up by specifying a value other than "NONE" in the db-tbl-split-key of HCSC server setup definition file. For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
(2) Status information
This subsection describes the values that are stored in the table and the actual values (character strings).
(a) HCSC cluster name
Specify a name consisting of a maximum of 8 alphanumeric characters.
(b) Process instance identifier
This is an identifier used to uniquely identify each process instance.
(c) Process instance status
| No. |
Name |
Description |
Value in database |
| 1 |
Unexecuted |
The process instance is not executed and might be executed in the future. |
Unexecution |
| 2 |
Executing |
The process instance is executing. |
Executing |
| 3 |
Error |
An exception occurred in the invoke service activity or scope activity, and the process instance was interrupted with an error. |
Error |
| 4 |
Completed |
The global scope of the process is completed and the process instance is completed. |
Completed |
| 5 |
Terminated with fault |
A fault occurred and could not be detected by the global scope, resulting in termination of the process instance with a fault. |
Faulted |
| 6 |
Forced termination |
The process instance was forcibly terminated in the end activity. |
Terminated |
(d) Activity type
| No. |
Name |
Description |
Value in database |
| 1 |
receive |
Indicates a receive activity. |
RECEIVE |
| 2 |
reply |
Indicates a reply activity. |
REPLY |
| 3 |
invoke |
Indicates an invoke service activity. |
INVOKE |
| 4 |
assign |
Indicates an assign activity. |
ASSIGN |
| 5 |
scope |
Indicates a scope activity. |
SCOPE |
| 6 |
sequence |
Indicates activities to be executed in the defined order. |
SEQUENCE |
| 7 |
flow |
Indicates a flow activity. |
FLOW |
| 8 |
switch |
Indicates a switch activity. |
SWITCH |
| 9 |
while |
Indicates a while activity. |
WHILE |
| 10 |
java |
Indicates an invoke Java activity. |
JAVA |
| 11 |
wait |
Indicates a standby activity. |
WAIT |
| 12 |
empty |
Indicates an empty activity. |
EMPTY |
| 13 |
throw |
Indicates a throw activity. |
THROW |
| 14 |
validate |
Indicates a validation activity. |
VALIDATE |
(e) Activity instance status
| No. |
Name |
Description |
Value in database |
| 1 |
Unexecuted |
The activity instance is not executed and might be executed in the future. |
Unexecution |
| 2 |
Unomitted |
The activity instance is not executed and its execution might be omitted in the future. |
Unomission |
| 3 |
Executing |
The activity instance is executing. |
Executing |
| 4 |
Executing (Wait) |
Roll back is executed and the scope activity instance might be re-executed in future. |
Executingwait |
| 5 |
Waiting |
The receive activity instance is ready to receive. |
Awaiting |
| 6 |
Faulting |
The scope activity instance is executing an activity that was detected during fault processing. |
Faulting |
| 7 |
Error |
An exception (error) occurred in the invoke service activity or the scope activity, and the activity instance was interrupted with an error. |
Error |
| 8 |
Completed |
The activity instance was executed normally and then terminated. |
Completed |
| 9 |
Completed (Wait) |
The scope activity or reply activity instance was executed normally and might be re-executed in future. |
Completedwait |
| 10 |
Cancelled |
A fault occurred and execution of the activity instance was cancelled. |
Canceled |
| 11 |
Terminated with fault |
A fault occurred during execution of the activity instance, and the activity instance was terminated. |
Faulted |
| 12 |
Execution omitted |
Execution of the activity instance was omitted and terminated. |
Omitted |
(f) Link status
| No. |
Name |
Description |
Value in database |
| 1 |
True |
Indicates true active status. |
1 |
| 2 |
False |
Indicates false active status. |
0 |
(g) Correlation set status
| No. |
Name |
Description |
Value in database |
| 1 |
Valid |
Indicates valid status. |
1 |
| 2 |
Invalid |
Indicates invalid status. |
0 |
(h) Value of Boolean variable
| No. |
Name |
Description |
Value in database |
| 1 |
True |
Indicates true. |
1 |
| 2 |
False |
Indicates false. |
0 |
(i) Send/receive flag for the message
| No. |
Name |
Description |
Value in database |
| 1 |
receive reception |
Flag indicating that the message was received by a receive activity. |
R |
| 2 |
invoke transmission |
Flag indicating that the message was sent by an invoke service activity. |
O |
(j) Identification number of the dependent repetition process (RepeatNumber)
- Sets the local activity instance identification number, when parent activity definition is a repetition process.
- Sets the parent activity instance repetition process identification number, when parent activity definition is not a repetition process.
(k) Smallest and largest identification numbers of child activity instances (FirstChildNumber/LastChildNumber)
- Default value indicates local activity instance identification number.
- When child activity instances are created, sets the smallest or largest identification number for them.
(3) Index information
The following table describes the information of index to be given in respective tables:
- Index for the CSCBP_<cluster name>_PROCESS table
| No. |
Index name |
UNIQUE attribute |
Order in index |
Column name |
| 1 |
CSCBP_<cluster name>_PROCESS_IDX1 |
Yes |
1 |
ProcessID |
| 2 |
SplitKey# |
| 2 |
CSCBP_<cluster name >_PROCESS_IDX2 |
No |
1 |
ProcessDefinitionName |
| 2 |
State |
| 3 |
StartTime |
| 3 |
CSCBP_<cluster name >_PROCESS_IDX3 |
No |
1 |
ProcessDefinitionName |
| 2 |
State |
| 3 |
EndTime |
| 4 |
CSCBP_<cluster name >_PROCESS_IDX4 |
No |
1 |
CSCServerName |
| 2 |
ProcessDefinitionName |
| 3 |
State |
- Note#
- This column is included in SQL script, if you split the range as per the date data (set up by specifying a value other than "NONE" for db-tbl-split-key in HCSC server setup definition file). For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
- Index for the CSCBP_<cluster name>_ACTIVITY table
| No. |
Index name |
UNIQUE attribute |
Order in index |
Column name |
| 1 |
CSCBP_<cluster name>_ACTIVITY_IDX |
Yes |
1 |
ProcessID |
| 2 |
ActivityNumber |
| 3 |
SplitKey# |
- Note#
- This column is included in SQL script, if you split the range as per the date data (set up by specifying a value other than "NONE" for db-tbl-split-key in HCSC server setup definition file). For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
- Index for the CSCBP_<cluster name>_LINK table
| No. |
Index name |
UNIQUE attribute |
Order in index |
Column name |
| 1 |
CSCBP_< luster name >_LINK_IDX |
Yes |
1 |
ProcessID |
| 2 |
LinkDefinitionName |
| 3 |
RepeatNumber |
| 4 |
SplitKey# |
- Note#
- This column is included in SQL script, if you split the range as per the date data (set up by specifying a value other than "NONE" for db-tbl-split-key in HCSC server setup definition file). For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
- Index for the SCBP_<cluster name>_CORRELATIONSET table
| No. |
Index name |
UNIQUE attribute |
Order in index |
Column name |
| 1 |
CSCBP_<cluster name >_CORREL_IDX1 |
Yes |
1 |
ProcessID |
| 2 |
ScopeNumber |
| 3 |
CorrelationSetName |
| 4 |
SplitKey#2 |
| 2 |
CSCBP_<cluster name >_CORREL_IDX2 |
Yes |
1 |
ProcessDefinitionName |
| 2 |
ScopeDefinitionName |
| 3 |
CorrelationSetName |
| 4 |
CorrelationSetValue |
| 5 |
ProcessID#1 |
| 6 |
SplitKey#2 |
- Note#1
- This column is to be included in SQL script file, when performing hash partitioning as per ProcessID.
- Note#2
- This column is included in SQL script, if you split the range as per the date data (set up by specifying a value other than "NONE" for db-tbl-split-key in HCSC server setup definition file). For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
- Index for the CSCBP_<cluster name>_STR_VARIABLE table
| No. |
Index name |
UNIQUE attribute |
Order in index |
Column name |
| 1 |
CSCBP_<cluster name>_STR_VAR_IDX |
Yes |
1 |
ProcessID |
| 2 |
ScopeNumber |
| 3 |
VariableName |
| 4 |
SplitKey# |
- #
- This column is included in SQL script, if you split the range as per the date data (set up by specifying a value other than "NONE" for db-tbl-split-key in HCSC server setup definition file). For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
- Index for the CSCBP_<cluster name>_NUM_VARIABLE table
| No. |
Index name |
UNIQUE attribute |
Order in index |
Column name |
| 1 |
CSCBP_<cluster name>_NUM_VAR_IDX |
Yes |
1 |
ProcessID |
| 2 |
ScopeNumber |
| 3 |
VariableName |
| 4 |
SplitKey# |
- Note#
- This column is included in SQL script, if you split the range as per the date data (set up by specifying a value other than "NONE" for db-tbl-split-key in HCSC server setup definition file). For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
- Index for the CSCBP_<cluster name>_BOOL_VARIABLE table
| No. |
Index name |
UNIQUE attribute |
Order in index |
Column name |
| 1 |
CSCBP_<cluster name>_BOOL_VAR_IDX |
Yes |
1 |
ProcessID |
| 2 |
ScopeNumber |
| 3 |
VariableName |
| 4 |
SplitKey# |
- Note#
- This column is included in SQL script, if you split the range as per the date data (set up by specifying a value other than "NONE" for db-tbl-split-key in HCSC server setup definition file). For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
- Index for the CSCBP_<cluster name>_MSG_VARIABLE table
| No. |
Index name |
UNIQUE attribute |
Order in index |
Column name |
| 1 |
CSCBP_<cluster name>_MSG_VAR_IDX |
Yes |
1 |
ProcessID |
| 2 |
ScopeNumber |
| 3 |
VariableName |
| 4 |
SplitKey# |
- Note#
- This column is included in SQL script, if you split the range as per the date data (set up by specifying a value other than "NONE" for db-tbl-split-key in HCSC server setup definition file). For details on db-tbl-split-key, see "HCSC server setup definition fil" in "Service Platform Reference Guide".
- Index for the CSCBP_<cluster name>_MSG_RELATION table
| No. |
Index name |
UNIQUE attribute |
Order in index |
Column name |
| 1 |
CSCBP_<cluster name>_MSG_REL_IDX1 |
None |
1 |
MessageID |
| 2 |
CSCBP_<cluster name >_MSG_REL_IDX2 |
Yes |
1 |
ProcessID |
| 2 |
ActivityNumber |
| 3 |
SendOrReceive |
| 4 |
SplitKey# |
| 3 |
CSCBP_<cluster name >_MSG_REL_IDX3 |
None |
1 |
AsynchronousMessagingID |
- Note#
- This column is included in SQL script, if you split the range as per the date data (set up by specifying a value other than "NONE" for db-tbl-split-key in HCSC server setup definition file). For details on db-tbl-split-key, see "HCSC server setup definition file" in "Service Platform Reference Guide".
(4) View table information
The following table describes information of the View table:
- CSCBP_<cluster name>_V_ACTIVITY view table
| No. |
Column name |
Reference table |
Reference column |
| 1 |
ProcessID |
ACTIVITY |
ProcessID |
| 2 |
ActivityNumber |
ACTIVITY |
ActivityNumber |
| 3 |
ProcessDefinitionName |
PROCESS |
ProcessDefinitionName |
| 4 |
ProcessDefinitionVersion |
PROCESS |
ProcessDefinitionVersion |
| 5 |
ActivityDefinitionName |
ACTIVITY |
ActivityDefinitionName |
| 6 |
ActivityKind |
ACTIVITY |
ActivityKind |
| 7 |
ParentNumber#1 |
ACTIVITY |
ParentNumber |
| 8 |
ScopeNumber |
ACTIVITY |
ScopeNumber |
| 9 |
RepeatNumber#1 |
ACTIVITY |
RepeatNumber |
| 10 |
State |
ACTIVITY |
State |
| 11 |
FirstChildNumber#1 |
ACTIVITY |
FirstChildNumber |
| 12 |
LastChildNumber#1 |
ACTIVITY |
LastChildNumber |
| 13 |
StartTime |
ACTIVITY |
StartTime |
| 14 |
EndTime |
ACTIVITY |
EndTime |
| 15 |
WaitTime |
ACTIVITY |
WaitTime |
| 16 |
CSCServerName |
PROCESS |
CSCServerName |
| 17 |
SplitKey#2 |
PROCESS |
SplitKey |
- Note#1
- There is no need to know the value, since this item is used for internal management during execution.
- Note#2
- This column is included in view only when you specify activity in the -table option of the cscpiselect command and specify SplitKey column in the -where or -wherefile option.
-
- CSCBP_<cluster name>_V_LINK view table
| No. |
Column name |
Reference table |
Reference column |
| 1 |
ProcessID |
LINK |
ProcessID |
| 2 |
ProcessDefinitionName |
PROCESS |
ProcessDefinitionName |
| 3 |
ProcessDefinitionVersion |
PROCESS |
ProcessDefinitionVersion |
| 4 |
LinkDefinitionName |
LINK |
LinkDefinitionName |
| 5 |
RepeatNumber#1 |
LINK |
RepeatNumber |
| 6 |
State |
LINK |
State |
| 7 |
SplitKey#2 |
PROCESS |
SplitKey |
- Note#1
- There is no need to know the value, since this item is used for internal management during execution.
- Note#2
- This column is included in view only when you specify link in the -table option of the cscpiselect command and specify SplitKey column in the -where or -wherefile option.
-
- CSCBP_<cluster name>_V_STR_VARIABLE view table
| No. |
Column name |
Reference table |
Reference column |
| 1 |
ProcessID |
STR_VARIABLE |
ProcessID |
| 2 |
ProcessDefinitionName |
PROCESS |
ProcessDefinitionName |
| 3 |
ProcessDefinitionVersion |
PROCESS |
ProcessDefinitionVersion |
| 4 |
ScopeDefinitionName |
ACTIVITY |
ActivityDefinitionName |
| 5 |
ScopeNumber |
STR_VARIABLE |
ScopeNumber |
| 6 |
VariableName |
STR_VARIABLE |
VariableName |
| 7 |
VariableValue |
STR_VARIABLE |
VariableValue |
| 8 |
SplitKey# |
PROCESS |
SplitKey |
- Note#
- This column is included in view only when you specify string in the -table option of the cscpiselect command and specify SplitKey column in the -where or -wherefile option.
-
- CSCBP_<cluster name>_V_NUM_VARIABLE view table
| No. |
Column name |
Reference table |
Reference column |
| 1 |
ProcessID |
NUM_VARIABLE |
ProcessID |
| 2 |
ProcessDefinitionName |
PROCESS |
ProcessDefinitionName |
| 3 |
ProcessDefinitionVersion |
PROCESS |
ProcessDefinitionVersion |
| 4 |
ScopeDefinitionName |
ACTIVITY |
ActivityDefinitionName |
| 5 |
ScopeNumber |
NUM_VARIABLE |
ScopeNumber |
| 6 |
VariableName |
NUM_VARIABLE |
VariableName |
| 7 |
VariableValue |
NUM_VARIABLE |
VariableValue |
| 8 |
SplitKey# |
PROCESS |
SplitKey |
- Note#
- This column is included in view only when you specify numeric in the -table option of the cscpiselect command and specify SplitKey column in the -where or -wherefile option.
-
- CSCBP_<cluster name>_V_BOOL_VARIABLE view table
| No. |
Column name |
Reference table |
Reference column |
| 1 |
ProcessID |
BOOL_VARIABLE |
ProcessID |
| 2 |
ProcessDefinitionName |
PROCESS |
ProcessDefinitionName |
| 3 |
ProcessDefinitionVersion |
PROCESS |
ProcessDefinitionVersion |
| 4 |
ScopeDefinitionName |
ACTIVITY |
ActivityDefinitionName |
| 5 |
ScopeNumber |
BOOL_VARIABLE |
ScopeNumber |
| 6 |
VariableName |
BOOL_VARIABLE |
VariableName |
| 7 |
VariableValue |
BOOL_VARIABLE |
VariableValue |
| 8 |
SplitKey# |
PROCESS |
SplitKey |
- Note#
- This column is included in view only when you specify boolean in the -table option of the cscpiselect command and specify SplitKey column in the -where or -wherefile option.
-
- CSCBP_<cluster name>_V_MSG_VARIABLE view table
| No. |
Column name |
Reference table |
Reference column |
| 1 |
ProcessID |
MSG_VARIABLE |
ProcessID |
| 2 |
ProcessDefinitionName |
PROCESS |
ProcessDefinitionName |
| 3 |
ProcessDefinitionVersion |
PROCESS |
ProcessDefinitionVersion |
| 4 |
ScopeDefinitionName |
ACTIVITY |
ActivityDefinitionName |
| 5 |
ScopeNumber |
MSG_VARIABLE |
ScopeNumber |
| 6 |
VariableName |
MSG_VARIABLE |
VariableName |
| 7 |
VariableValue |
MSG_VARIABLE |
VariableValue |
| 8 |
SplitKey# |
PROCESS |
SplitKey |
- Note#
- This column is included in view only when you specify message in the -table option of the cscpiselect command and specify SplitKey column in the -where or -wherefile option.
All Rights Reserved. Copyright (C) 2015, Hitachi, Ltd.