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.

HCSC basic information table
HCSC linkage directory information table
Location directory information table
Routing rule directory information table
Data transformation definition directory information table
Cluster basic information management table
Asynchronous adapter service ID management table

(a) HCSC basic information table

•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

•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

•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).

•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

•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

•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.

•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

•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

•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.

To Page Top