Enable Case Data Normalization
Description
To determine whether case data normalization is enabled.
Database
Oracle, DB2
Value
|
Installation Type |
New Installation |
Upgrade Installation |
|
Value |
|
The current setting, as defined by the value of the If this setting is |
|
Default Value |
|
Notes
Case data normalization is a feature used to make case data searching more efficient, and therefore faster. It uses the field_value_N column in the case_data table in the iProcess Engine database. This column provides a normalized value of the value in the field_value column, allowing the database to do simple string comparisons, instead of having to do type conversions.
|
Warning |
If you intend to use iProcess Objects to perform case data searches, TIBCO strongly recommends that you enable case data normalization. If you do not do this, you will be able to view and start procedures, but you will not be able to view the cases until you normalize the data. You can either enable case data normalization as part of the installation, or upgrade process by setting this menu item. Or, you can do so afterwards by using the |
For the Oracle database, if you are upgrading, note that creating the data for the field_value_N column can significantly increase the time taken to perform the upgrade if the system has a large number of cases. See How Long Will an Upgrade Take for more information.
For the DB2 database, if you are upgrading, before choosing to enable case data normalization, note that the installer will need to populate the field_value_N column for every row in the case_data table, using the values from the field_value column. This can significantly impact the duration of the upgrade process if there are large numbers of cases on the system. See How Long Will an Upgrade Take for more information.