Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 11 Administrative Tables : flag_table

flag_table
The flag_table table provides a locking mechanism which controls access to the four areas of iProcess administrative data - users, lists, roles and TIBCO iProcess Engine tables. iProcess administrative data is maintained in two sets of tables:
The flag_table table contains a row for each area of iProcess administrative data, and is used to prevent multiple users from editing the same data at the same time.
When a user edits the data in a particular row (for example, using User Manager to edit user data), the area_locked flag is set while editing takes place. On completion of the edit, the area_locked flag is cleared. If changes have been made, the area_changed flag is set.
When a user requests a Move System Information, the move_req flag is set on any rows that have the area_changed flag set. When the background process sees a row with move_req flagged that is not locked, it locks the area and updates the main system data tables from the tsys_ tables. When the Move System Information operation completes, all the flags are cleared.
Structure
The flag_table table has the following structure:
TABLE flag_table (
area_id
number(5) NOT NULL,
area_locked number(1) NOT NULL,
area_changed number(1) NOT NULL,
move_req number(1) NOT NULL,
user_name varchar2(64) NULL)
Unique ID of this area of iProcess administrative data: Either Users (1), iProcess Tables (2), Lists (3) or Roles (4).
Flag that defines whether (1) or not (0) the specified area_id is locked. The flag is set by:
Flag that defines whether (1) or not (0) the tsys_ tables for the specified area_id contain modified data.
Flag that defines whether (1) or not (0) the specified area_id needs to be updated by a Move System Information operation.
swpro if the background process has the area locked.
Primary Key
The following primary key is defined for this table.
Foreign Keys
None.
Indexes
None.
Storage
The following STORAGE values are defined for this table.
Table Activity
The flag_table table always contains 4 rows - one row for each area of iProcess administrative data (users, lists, roles and TIBCO iProcess Engine tables).
The table is populated when the iProcess Engine is installed.
Rows are added, updated and deleted in the following situations.

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.