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.
- 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:
- 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.
- 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.
- Configure the massload utility
Before using the massload utility you might want to change the following to suit the environment.
- Configure the MassLoadCustomizer.properties file
Configure the MassLoadCustomizer.properties files to change the massload utility's behavior.
- 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.
- 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
Load data using the mass load utility
Related reference
massload utility (Development environment)