Copyright © Cloud Software Group, Inc. All Rights Reserved

nodes

The nodes table holds information about this iProcess Engine node. A node is a single logical iProcess Engine, which may be installed either on a single computer, or spread over several using a node cluster architecture).

Structure

The nodes table has the following structure:

TABLE nodes(
node_id number(5) NOT NULL,
node_name varchar2(24) NOT NULL,
dir_name varchar2(28) NOT NULL,
mail_addr varchar2(149) NULL,
mail_cert varchar2(31) NULL,
mail_type number(5) NOT NULL,
node_public number(1) NOT NULL,
node_slave number(1) NOT NULL,
node_deleted number(1) NOT NULL,
rpc_majvers number(3) NOT NULL,
rpc_minvers number(3) NOT NULL,
server_majvers number(3) NOT NULL,
server_minvers number(3) NOT NULL)

Column	Description
node_id	Unique ID of this iProcess node. Note: This value is always 1.
node_name	Logical name for this node.
dir_name	Name of the directory which holds the node's data (SWDIR).
mail_addr	Not used. Reserved for possible future use.
mail_cert	Not used. Reserved for possible future use.
mail_type	Not used. Reserved for possible future use.
node_public	Not used. Reserved for possible future use.
node_slave	Not used. Reserved for possible future use.
node_deleted	Not used. Reserved for possible future use.
rpc_majvers	Not used. Reserved for possible future use.
rpc_minvers	Not used. Reserved for possible future use.
server_majvers	Not used. Reserved for possible future use.
server_minvers	Not used. Reserved for possible future use.

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)	Index Tablespace
pk_nodes	node_id	TINYINDEXSPACE

Foreign Keys

None.

Indexes

None.

Storage

The following STORAGE values are defined for this table.

Value	Definition
Initial	TINYTABLESIZE
Percentage Increase	TINYTABLEPCTINCREASE
Tablespace	TINYTABLESPACE

Table Activity

The nodes table contains one row, which is the entry for the iProcess Engine.

Rows are added, updated and deleted in the following situations.

A row is...	When...
added	never.
updated	never.
deleted	never.

Copyright © Cloud Software Group, Inc. All Rights Reserved