Using the Case Data Normalization Utility

The Case Data Normalization Utility allows you to normalize existing case data; either system-wide or on a per-procedure basis. For example, you may have disabled case data during an upgrade because of the large amount of case data involved. After the upgrade, you can use the Case Data Normalization Utility to convert the case data during off-peak hours.

Note: You can also disable or enable case data normalization on a per-procedure basis with the "Normalise Case Data" check box on the Status tab of the Procedure Properties dialog box.

Before using the Case Data Normalization Utility, ensure that the global process attribute NORMALISE_CASE_DATA is set to 1, using the swadm utility if necessary (see Using SWDIR\util\swadm to Administer Process Attributes). This enables case data normalization and allows you to use the Case Data Normalization Utility.

The Case Data Normalization Utility is located in the following directory:

SWDIR\util

The command you enter to use the utility has the following format:

swnormcd [/U] [/T nnn] /A | procedure_list | /F control_file

where:

• /U indicates that you want to disable case data normalization. Note that disabling case data normalization does not delete the data held in the field_value_N column in the case_data table. New cases of procedures will not use case data normalization and if you are using TIBCO iProcess Objects, new cases will not appear in case data searches.
• /T nnn specifies the number (nnn) of concurrent threads for case data normalization. The default is 10. Use this parameter to improve performance when normalizing large amounts of data.
• /A indicates that existing case data should be normalized for all procedures. The normalise_data column on the proc_index table is set to 1 and new cases of procedures are normalized.
Warning: Normalizing large amounts of case data can take a significant amount of time.
• procedure_list is either the name of a procedure or a list of procedures separated by white space.
• /F control_file specifies the name of a file that contains procedure names separated by white space.

Examples

This command disables case data normalization for the hiring procedure. Any new cases of this procedure will not use case data normalization and will not appear in searches using TIBCO iProcess Objects.

swnormcd /U hiring

This command enables case data normalization for all procedures and normalizes existing case data.

swnormcd /A

This command enables case data normalization for the procedures listed in the file proclist.txt and converts any existing case data.

swnormcd /F proclist.txt