uCosminexus Service Platform, Setup and Operation Guide

[Contents][Glossary][Index][Back][Next]

Appendix C.3 Table information about execution environment setup

Organization of this subsection
(1) Table information

(1) Table information

The following tables are required for each HCSC server or cluster.

(a) HCSC basic information table

[Figure]CSCMSG_S<HCSC server name>_CSC_PERSIST table
The contents of the CSCMSG_S<HCSC server name>_CSC_PERSIST table are as follows:
No. Column name Description HiRDB type ORACLE type Existence of index NULL UNIQUE attribute
1 CSC_SERVER_NAME Name of local HCSC server VARCHAR(8) VARCHAR2(8) No Not possible No
2 CSC_SERVER_STATUS Status of the HCSC server (unused)
  • 1: Starting
  • 2: Active
  • 3: Start failed
  • 4: Inactive
  • 5: Stopping
  • 6: Stop failed
 INTEGER NUMBER(10,0) No Not possible No
3 CSC_REQUEST_STATUS Status of synchronous reception
  • 1: Starting
  • 2: Active
  • 3: Start failed
  • 4: Inactive
  • 5: Stopping
  • 6: Stop failed
 INTEGER NUMBER(10,0) No Not possible No
4 CSC_CONNECT_STATUS Status of linkage reception
  • 1: Starting
  • 2: Active
  • 3: Start failed
  • 4: Inactive
  • 5: Stopping
  • 6: Stop failed
 INTEGER NUMBER(10,0) No Not possible No
5 CSC_TABLE_VERSION Table version number for entire HCSC INTEGER NUMBER(10,0) No Not possible No
6 CSC_TABLE_REVISION Table revision number for entire HCSC INTEGER NUMBER(10,0) No Not possible No
7 OPTION1 Reserve 1 BINARY(2000) RAW(2000) No Possible No
8 OPTION2 Reserve 2 BINARY(2000) RAW(2000) No Possible No
9 OPTION3 Reserve 3 BINARY(2000) RAW(2000) No Possible No

Note:
By default, INDEX is not used.

(b) HCSC linkage directory information table

[Figure]CSCMSG_C<cluster name>_CSC_CONNECT table
The contents of the CSCMSG_C<cluster name>_CSC_CONNECT table are as follows:
No. Column name Description HiRDB type ORACLE type Existence of index NULL UNIQUE attribute
1 CONNECT_CLUSTER_NAME# Linked cluster name VARCHAR(8) VARCHAR2(8) No Not possible Yes
2 CONNECT_VERSION Request source HCSC server version number INTEGER NUMBER(10,0) No Not possible No
3 CONNECT_REVISION Request source HCSC server revision number INTEGER NUMBER(10,0) No Not possible No
4 CONNECT_ID Linkage start timestamp for linkage at the request source HCSC server TIMESTAMP(4) NUMBER(20,0) No Not possible No
5 CONNECT_STATUS Status of linkage with HCSC server
  • 1: OFFLINE (Not linked)
  • 2: ONLINE (Linked)
 INTEGER NUMBER(10,0) No Not possible No
6 CONNECT_OPTION Synchronization type (Which of the following is used for synchronous interface)
  • SOAP
  • EJB
 VARCHAR(16) VARCHAR2(16) No Possible No
7 CONNECT_WEB_URL URL of Web Services for SOAP transfer VARCHAR(2086) VARCHAR2(2086) No Possible No
8 CONNECT_WEB_USER_ID User ID for SOAP transfer VARCHAR(256) VARCHAR2(256) No Possible No
9 CONNECT_WEB_PASSWORD Password for SOAP transfer VARCHAR(256) VARCHAR2(256) No Possible No
10 CONNECT_J2EE_NAME Name of the J2EE server used for invoking EJB used for transfer VARCHAR(255) VARCHAR2(255) No Possible No
11 CONNECT_NAMING_HOST Host name of Naming Service used for invoking EJB used for transfer VARCHAR(255) VARCHAR2(255) No Possible No
12 CONNECT_NAMING_PORT Port number of Naming Service used for invoking EJB used for transfer VARCHAR(5) VARCHAR2(5) No Possible No
13 OPTION1 Reserve 1 BINARY(2000) RAW(2000) No Possible No
14 OPTION2 Reserve 2 BINARY(2000) RAW(2000) No Possible No
15 OPTION3 Reserve 3 BINARY(2000) RAW(2000) No Possible No

Note#
CONNECT_CLUSTER_NAME is defined by UNIQUE CLUSTER KEY (indexes are created automatically).

(c) Location directory information table

[Figure]CSCMSG_S<HCSC server name>_LC_DIRECTORY table
The contents of the CSCMSG_S<HCSC server name>_LC_DIRECTORY table are as follows:
No. Column name Description HiRDB type ORACLE type Existence of index NULL UNIQUE attribute
1 SERVICE_NAME# Service name (Target service component)
  • Service name of service adapter
  • Service name of business process
  • Service group name
 MVARCHAR(64) NVARCHAR2(64) No Not possible Yes
2 ADAPTER_NAME Service ID of service adapter or Service ID of business process VARCHAR(8) VARCHAR2(8) No Possible No
3 SERVICE_KIND Type of service component
  • Single service component
  • Business process
  • Service group
  • User-defined reception
 INTEGER NUMBER(10,0) No Not possible No
4 SERVICE_PROTOCOL_KIND Type of service adapter
  • 1: MDB_WSR (Asynchronous)
  • 2: MDB_DBQ (Asynchronous)
  • 3: SessionBean (Synchronous)
  • 4: WebService (Synchronous)
  • 5: Custom (Other than 1~4 given above)
 INTEGER NUMBER(10,0) No Not possible No
5 SERVICE_STATUS Status of HCSC component or service group
  • 1: Active ACTIVE
  • 2: Inactive INACTIVE
  • 3: Stop failed STOP_FAILED
  • 4: Stopping STOPPING
  • 5: Start failed START_FAILED
  • 6: Starting STARTING
  • 7: Deleting DELETING
 INTEGER NUMBER(10,0) No Not possible No
6 ADAPTER_ENTRY_TIME Time at which the adapter definition was added TIMESTAMP(4) NUMBER(20,0) No Not possible No
7 LC_VERSION Location directory version number INTEGER NUMBER(10,0) No Not possible No
8 LC_REVISION Location directory revision number INTEGER NUMBER(10,0) No Not possible No
9 ADAPTER_LOCAL_CALL Value specified for parameter (local-call) in adapter definition file INTEGER NUMBER(10,0) No Not possible No
10 ADAPTER_MODIFIED_TIME Service adapter or business process update time TIMESTAMP(4) NUMBER(20,0) No Not possible No
11 OPTION1 Reception-related information of a user-specified interface BINARY(2000) RAW(2000) No Possible No
12 OPTION2 Reserve 2 BINARY(2000) RAW(2000) No Possible No
13 OPTION3 Reserve 3 BINARY(2000) RAW(2000) No Possible No

Note#
SERVICE_NAME is defined by UNIQUE CLUSTER KEY (indexes are created automatically).

[Figure]CSCMSG_S<HCSC server name>_LC_BPFORMAT table
The contents of the CSCMSG_S<HCSC server name>_LC_BPFORMAT table are as follows:
No. Column name Description HiRDB type ORACLE type Existence of index NULL UNIQUE attribute
1 SERVICE_NAME Service name (target service component)
  • Service name of business process
 MVARCHAR(64) NVARCHAR2(64) No Not possible No
2 OPERATION_NAME Operation name of service definition file MVARCHAR(255) NVARCHAR2(255) No Not possible No
3 REQ_FORMAT_ID Request format ID of service definition file VARCHAR(1024) VARCHAR2(1024) No Possible No
4 RES_FORMAT_ID Response format ID of service definition file VARCHAR(1024) VARCHAR2(1024) No Possible No
5 OPTION1 Reserve 1 BINARY(2000) RAW(2000) No Possible No
6 OPTION2 Reserve 2 BINARY(2000) RAW(2000) No Possible No
7 OPTION3 Reserve 3 BINARY(2000) RAW(2000) No Possible No

Note:
By default, INDEX is not used.

(d) Routing rule directory information table

[Figure]CSCMSG_S<HCSC server name>_RT_RULE table
The contents of the CSCMSG_S<HCSC server name>_RT_RULE table are as follows:
No. Column name Description HiRDB type ORACLE type Existence of index NULL UNIQUE attribute
1 SERVICE_GROUP_NAME# Service group name MVARCHAR(64) NVARCHAR2(64) No Not possible Yes
2 RULES Byte string of XML routing definition BINARY(2147483639) LONG RAW No Possible No
3 OPTION1 Reserve 1 BINARY(2000) RAW(2000) No Possible No
4 OPTION2 Reserve 2 BINARY(2000) RAW(2000) No Possible No
5 OPTION3 Reserve 3 BINARY(2000) RAW(2000) No Possible No

Note#
SERVICE_NAME is defined by UNIQUE CLUSTER KEY (indexes are created automatically).

(e) Data transformation definition directory information table

[Figure]CSCMSG_S<HCSC server name>_CV_MAPPING table
The contents of the CSCMSG_S<HCSC server name>_CV_MAPPING table are as follows:
No. Column name Description HiRDB type ORACLE type Existence of index NULL UNIQUE attribute
1 BEF_FORMAT_ID Message format ID (For conversion source) VARCHAR(1024) VARCHAR2(1024) No Possible No
2 AFT_FORMAT_ID Message format ID (For conversion destination) VARCHAR(1024) VARCHAR2(1024) No Possible No
3 ENTRY_TIME Time at which the data transformation definition was added TIMESTAMP(4) NUMBER(20,0) No Possible No
4 ROOT_FILE Flag indicating whether or not this is the root
  • 0: false
  • 1: true
 INTEGER NUMBER(10,0) No Possible No
5 DEFINITION_NAME Name of data transformation definition file MVARCHAR(255) NVARCHAR2(255) No Possible No
6 TRANSFORM_DEFINITION Data transformation definition BINARY(2147483639) LONG RAW No Possible No
7 OPTION1 Reserve 1 BINARY(2000) RAW(2000) No Possible No
8 OPTION2 Reserve 2 BINARY(2000) RAW(2000) No Possible No
9 OPTION3 Reserve 3 BINARY(2000) RAW(2000) No Possible No

Note:
By default, INDEX is not used.

[Figure]CSCMSG_S<HCSC server name>_CV_FORMAT table
The contents of the CSCMSG_S<HCSC server name>_CV_FORMAT table are as follows:
No. Column name Description HiRDB type ORACLE type Existence of index NULL UNIQUE attribute
1 FORMAT_ID Message format ID
  • For conversion source
  • For conversion target
 VARCHAR(1024) VARCHAR2(1024) No Possible No
2 FORMAT_TYPE Type of message format
  • 1: XML
  • 2: BINARY
 INTEGER NUMBER(10,0) No Possible No
3 ENTRY_TIME Time when message format definition was added TIMESTAMP(4) NUMBER(20,0) No Possible No
4 ROOT_FILE Flag indicating whether or not this is the root
  • 0: false
  • 1: true
 INTEGER NUMBER(10,0) No Possible No
5 DEFINITION_NAME Format definition file name MVARCHAR(255) NVARCHAR2(255) No Possible No
6 FORMAT_DEFINITION Message format definition (Data definition) BINARY(2147483639) LONG RAW No Possible No
7 OPTION1 Reserve 1 BINARY(2000) RAW(2000) No Possible No
8 OPTION2 Reserve 2 BINARY(2000) RAW(2000) No Possible No
9 OPTION3 Reserve 3 BINARY(2000) RAW(2000) No Possible No

Note:
By default, INDEX is not used.

(f) Cluster basic information management table

[Figure]CSCMSG_C<cluster name>_CLUSTER table
The contents of the CSCMSG_C<cluster name>_CLUSTER table are as follows:
No. Column name Description HiRDB type ORACLE type Existence of index NULL UNIQUE attribute
1 CSC_SERVER_NAME#1 Name of the HCSC server that was set up VARCHAR(8) VARCHAR2(8) No Not possible No
2 CLUSTER_TYPE Cluster type of the HCSC server that was set up VARCHAR(2) VARCHAR2(2) No Not possible No
3 J2EE_NAME Name of the J2EE server on which HCSC server is set up VARCHAR(255) VARCHAR2(255) No Not possible No
4 SOAP_RCP If standard reception (Web service) is set up or not:
  • 0: Not set up
  • 1: Set up
 INTEGER NUMBER(1) No Not possible No
5 EJB_RCP If standard reception (SessionBean) is set up or not:
  • 0: Not set up
  • 1: Set up
 INTEGER NUMBER(1) No Not possible No
6 WSR_RCP If standard reception (MDB (WS-R)) is set up or not:
  • 0: Not set up
  • 1: Set up
 INTEGER NUMBER(1) No Not possible No
7 DBQ_RCP If standard reception (MDB (DB queue)) is set up or not:
  • 0: Not set up
  • 1: Set up
 INTEGER NUMBER(1) No Not possible No
8 RM_SYSNAME RM system name specified at the time of setting up HCSC server
If the RM system name is not specified, "" is specified.		 VARCHAR(3) VARCHAR2(3) No Not possible No
9 CLUSTER_PROPS Retain information in extension column in the format of "Key name=value"#2 VARCHAR(4000) VARCHAR2(4000) No Not possible No

Note:
By default, INDEX is not used.

Note#1
PRIMARY KEY of this table.

Note#2
The information that can be stored in CLUSTER_PROPS in the following manner:

Key name Key description Key value description
db-tbl-split-key Type of key used for split range

NONE
Split range is not used.

MONTH
Uses "Month" for split key
db-tbl-split-corcheck-use Whether the check for correlation set duplication is to be enhanced

ON
Correlation set duplication check is enhanced.

OFF
Correlation set duplication set is not enhanced.
(g) Asynchronous adapter service ID management table

[Figure]CSCMSG_C<cluster name>_HA_ASYNC_ADP table
The contents of the CSCMSG_C<cluster name>_HA_ASYNC_ADP table are as follows:
No. Column name Description HiRDB type ORACLE type Existence of Index NULL UNIQUE attribute
1 CSC_SERVER_NAME# Name of HCSC server on which a component is deployed VARCHAR(8) VARCHAR2(8) No Not possible No
2 ADAPTER_ID# Service ID of service adapter VARCHAR(8) VARCHAR2(8) No Not possible No

Note:
By default, INDEX is not used.

Note#
PRIMARY KEY of this table.

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2015, Hitachi, Ltd.