Previous Topic: Schedule Mart Report SynchronizationNext Topic: Mart Report Data Compression


Use Multiple Threads to Update Mart Models for Reporting

In the Workgroup Edition, the model data and model report data are stored in separate internal tables. The model report data table (m9ReportData) includes only those columns that are required to generate model-specific reports. When you update a model and save the changes, both the tables are updated. Although erwin® Data Modeler displays a message that the model is saved, the corresponding model report data table is still being updated in the background. In this scenario, if you try to generate a report, the report may not include the details that you have just updated. This means, there is a delay in the synchronization of model data and the model report data tables.

This delay happens because, the update process is handled by a single thread in your computer. From this release onward, you can configure a Mart to use multiple threads to update a model. Using multiple threads increases the performance of the update process and improves the time taken for large models to be available for reporting.

Follow these steps:

  1. Log out of the Mart and stop the Mart Server service.
  2. Navigate to the \webapps\MartServer\WEB-INF folder on the computer where erwin Mart Server is installed. Typically, the path for this folder is as follows:
    For a 32-bit version:
    <install folder>\erwin\Mart Server r9\Tomcat\Webapps\MartServer\WEB-INF
    

    For a 64-bit version:

    <install folder>\erwin\Mart Server r9\Tomcat64\Webapps\MartServer\WEB-INF
    
  3. Open the rest-context.xml file in a text editor such as Notepad and navigate to the following line:
    <property name="maxPoolSize" value="8" />
    
  4. Change the value to a number of your choice.

    The maximum number of threads that you can create depends on the system resources of your Mart server. If you enter a number, only the maximum number of threads that can be created per the system resources is created.

    Default: 8

  5. Save the XML file.
  6. Start the Mart Server service and log in to the Mart.