Copyright © Cloud Software Group, Inc. All rights reserved.

process_attributes

The process_attributes table stores process attribute definitions, which provide configuration information for iProcess Engine server processes.

Structure

The process_attributes table is structured as follows:

TABLE process_attributes (
logical_machine_id INTEGER NOT NULL,
logical_process_name VARCHAR(10) NOT NULL,
logical_process_instance INTEGER NOT NULL,
attribute_name VARCHAR(50) NOT NULL,
attribute_value VARCHAR(1024) NOT NULL,
attribute_type VARCHAR(2) NOT NULL)

Column	Description
logical_machine_id	ID of the server where the process instance that this attribute applies to is running, as defined in the node_cluster table. A value of 0 means that this attribute applies to all servers that are part of this node.
logical_process_name	Logical name of the process that this attribute applies to. A value of ALL means that this attribute applies to all processes on the indicated server. Note: See "Administering iProcess Engine Server Processes" in TIBCO iProcess Engine Administrator's Guide for a list of logical process names.
logical_process_ instance	ID of the process instance that this attribute applies to, as defined in the process_config table. A value of 0 means that this attribute applies to all instances of the indicated process.
attribute_name	Name of this process attribute. Note: See "Administering Process Attributes" in TIBCO iProcess Engine Administrator's Guide for a list of the available process attributes.
attribute_values	Value of this process attribute. Note: See "Administering Process Attributes" in TIBCO iProcess Engine Administrator's Guide for a list of the valid values for each process attributes.
attribute_type	Type of this process attribute: either I (Integer), C (Character) or S (String). Note: All attribute_values are stored as strings in this table. This value determines how the value is returned to the SWDIR\bin\swadm interface.

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)
pk_process_attributes	logical_machine_id logical_process_name logical_process_instance attribute_name

Foreign Keys

None.

Indexes

None.

Table Activity

The process_attribute table contains one row for each unique definition of a process attribute on the system.

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

A row is...	When...
added	a new process attribute definition is added, either at installation or by using the SWDIR\util\swadm utility.
updated	a process attribute definition is updated, using the SWDIR\util\swadm utility.
deleted	a process attribute definition is deleted, using the SWDIR\util\swadm utility.

This table can contain orphan rows in which data can exist that does not apply to any process currently being used.

Copyright © Cloud Software Group, Inc. All rights reserved.