Copyright © Cloud Software Group, Inc. All Rights Reserved

About TIBCO iProcess Tables

Note that there are four sets of related tables, as follows:

Prefix	Description
dbs_	Hold the main system data on installed TIBCO iProcess tables, which iProcess references during normal operation.
str_dbs_	Hold the main system data on uninstalled TIBCO iProcess tables, which iProcess references during normal operation. Note: There is no str_dbs_values table, because no data is associated with uninstalled TIBCO iProcess tables.
tsys_dbs_	Hold a copy of the main (dbs_ and str_dbs_) system data, containing users’ edits that have not yet been released for use by the system.
ttmp_dbs_	Temporary tables used only when importing TIBCO iProcess Engine tables (using SWDIR\bin\swutil IMPORT).

The tsys_dbs_ tables are purged and rewritten whenever a user edits TIBCO iProcess Engine table data (either by saving changes made in the Table Manager utility in the TIBCO iProcess Administrator, modifying data with SWDIR\bin\swutil IMPORT or DELTAB, or by using TIBCO iProcess Objects).

When a Move System Information is performed, if the tsys_dbs_ tables have been changed, the dbs_ and/or str_dbs_ tables are purged and rewritten with the updated information from the tsys_dbs_ tables.

Access to the dbs_ and tsys_dbs_ tables is controlled by a locking mechanism provided by the flag_table table.

Copyright © Cloud Software Group, Inc. All Rights Reserved