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.
The flag_table table has the following structure:
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).