Configuring the massextract utility

Before you use the massextract utility, configure the settings for the utility to meet your environment.

Procedure

  1. Change the Java virtual machine (JVM) heap size that is used for the massextract utility.

    By default, the maximum amount of memory that is allocated to the JVM heap is 64 MB. If this memory size is not increased, the JVM can eventually run out of memory during the extract process. The maximum amount of memory that is allocated to the Java heap can be varied by using the JVM -mx option in the Java command. If you are loading files that are more than 500 MB, then increase the JVM heap size to 512 MB or 1024 MB.

    To modify the JVM heap size for the massextract utility:

    1. Open the massextract utility file for editing.
      • For IBM i OS operating systemSolarisLinuxAIX WC_installdir/bin/ massextract.sh
      • WindowsWC_installdir\bin\ massextract.cmd
      • WebSphere Commerce DeveloperWCDE_installdir\bin\ massextract.bat
    2. Change the JVM heap size to 1024 MB by specifying the -Xms and -Xmx options of the Java command:
      • If the -Xms and -Xmx parameters are already specified in the file, change the values to the heap size that you want. Ensure that you update all occurrences of -Xms and -Xmx.
      • If the -Xms and -Xmx parameters are not specified in the file, change all occurrences of %JAVA_HOME%\bin\java in the utility command file to %JAVA_HOME%\bin\java -Xms1024M -Xmx1024M.
    3. Save your changes.
  2. Optional: OracleBy default, the massextract utility uses the Oracle thick JDBC client. To change the massextract utility to use the Oracle thin JDBC client:
    1. Open the following file in a text editor:

      WC_installdir/properties/OracleConnectionCustomizer.properties

    2. Locate the following text:

      DBURL = jdbc:oracle:oci8:@

    3. Change the text to match the following text:

      DBURL = jdbc:oracle:thin:@

    4. Save your changes.