Copyright © Cloud Software Group, Inc. All Rights Reserved

dbs_values

The dbs_values table holds all field values for all installed TIBCO iProcess Engine tables.

Structure

The dbs_values table has the following structure:

TABLE dbs_values (
node_id number(5) NOT NULL,
dbs_id number(5) NOT NULL,
record_id number(5) NOT NULL,
field_id number(5) NOT NULL,
field_value varchar2(30) NULL)

Column	Description
node_id	ID of the node that this field value is stored on, as defined in the nodes table.
dbs_id	ID of the table that this field value is stored in, as defined in the dbs_names table.
record_id	Unique ID for this record in the iProcess Engine table.
field_id	ID of the field held in this record, as defined in the dbs_fields table.
field_value	Value of the field in this record.

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)	Index Tablespace
pk_dbs_values	dbs_id record_id field_id node_id	MEDIUMINDEXSPACE

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_dbs_values1	dbs_id field_id node_id	dbs_fields

---

1

This key enforces the DELETE CASCADE referential action.

Indexes

The following indexes are defined for this table.

Index Name	Column(s) Indexed	Tablespace
idx_dbs_values_fk	dbs_id field_id node_id	MEDIUMINDEXSPACE
idx_dbs_values	record_id field_id dbs_id	MEDIUMINDEXSPACE

Storage

The following STORAGE values are defined for this table.

Value	Definition
Initial	MEDIUMTABLESIZE
Percentage Increase	MEDIUMTABLEPCTINCREASE
Tablespace	MEDIUMTABLESPACE

Table Activity

The dbs_values table contains one row for each field of each record in each installed TIBCO iProcess table on the system.

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

A row is...	When...
added	a Move System Information is performed, if the flag_table indicates that the Tables data area has been modified. Note: The table is purged and rewritten using the values from the tsys_dbs_values table.
updated	never.
deleted	a Move System Information is performed, if the flag_table indicates that the Tables data area has been modified. Note: The table is purged and rewritten using the values from the tsys_dbs_values table.

Copyright © Cloud Software Group, Inc. All Rights Reserved