Administer > Transforming, loading, and extracting data > Overview of the mass load utilities


Configure the loading utilities

Before using any of the loading utilities, you should confirm the settings and configuration of the various scripts and utilities that are part of the loading utilities.

  1. Configure the environment variable setting scripts
    Before you can use the loading utilities, you might have to update some of the environment variables used by the utilities. The environment variables are set by the following scripts that are called by the loading utilities and other WebSphere Commerce utilities:

  2. Configure tracing and logging for the loading utilities
    In addition to the individual logs for some of the loading utilities, you can configure an additional message log file, messages.txt, and a trace file, traces.txt, for the loading utilities. This can be helpful in getting more information to help determine any problems you may encounter. You can configure the contents and location of these files by editing the WCALoggerConfig.xml file.

  3. Configure the idresgen utility
    Configuring the idresgen utility involves changing two property files: DB2ConnectionCustomizer.properties and IDResolveKeys.properties. The DB2ConnectionCustomizer.properties file describes how the idresgen utility handles timestamps, storage, and database drivers. The IDResolveKeys.properties file specifies which columns of a primary entry should be used as lookups for tables that require the identifier of a primary row.

  4. Configure the massload utility
    Before using the massload utility you might want to change the following to suit the environment.

  5. Configure the MassLoadCustomizer.properties file
    Configure the MassLoadCustomizer.properties files to change the massload utility's behavior.

  6. Configure timestamp and date data handling
    When loading data that contains timestamp and date data, you have two options for handing the timestamp and date data: Specify the timestamp and date data as fixed information in the input file, or specify the timestamp and date data relative to when you load the input file into the database.

  7. Configure the massextract utility
    Before using the massextract utility you might want to change the following to suit the environment.


Related concepts

Overview of the mass load utilities


Related tasks

Generate a DTD

Resolve identifiers

Load data using the mass load utility

Load managed files

Extract data

Related reference

txttransform utility

xmltransform utility

idresgen utility

idresgen utility

massload utility (Development environment)

fileloader utility

dtdgen utility


+

Search Tips   |   Advanced Search