Correlation Search Feature Installation

Edit online

This useNewCorrelationSearch property is set by the Sterling B2B Integrator patch install as follows:

  • If you are using a MySQL database, the Sterling B2B Integrator patch install process occurs in offline mode (that is, the Sterling B2B Integrator is shut down during the patch install process), and the value of the new useNewCorrelationSearch property is set to True after the patch install (meaning the new correlation search functionality is enabled).
  • If you are using a non-MySQL database and you have less than the threshold number of rows in the CORRELATION_SET table, the patch installs all items and the value of the new useNewCorrelationSearch property is set to True after the patch install (meaning the new correlation search functionality is enabled). For users with relatively smaller databases, the patch install process occurs in offline mode.
    Note: The threshold is 10 million rows for Oracle and MSSQL databases, and 5 million for other databases, such as DB2® UNIX.
  • If you are using a non-MySQL database and you have more than the threshold number of rows in the CORRELATION_SET table, the patch process is two-step process. The value of the useNewCorrelationSearch property is False after the first step in this process and it is True after the second step.
    • The first step in this process is to install the patch, which applies the minimal items required and displays a message prompting you to run a command-line based tool called cs_conversion_tool.sh or cs_conversion_tool.cmd. This tool is run from the install_dir/bin/ directory.
    • The second step is to run the command-line based tool and, once the command-line based tool completes, you must restart the Sterling B2B Integrator. For relatively large enterprise databases, the Sterling B2B Integrator will be shut down for the minimal tasks, but other patch install tasks are performed in online mode.

You do not need to take any action in regard to this property unless you want to use the old functionality for some reason. In that case, you need to access the install_dir/properties/cssearch.properties file and set the useNewCorrelationSearch property to False. This will enable you to return to the previous state (using the old correlation search functionality), without impacting your system.