Administer > Transforming, loading, and extracting data > Overview of the mass load utilities > Configure 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:
- setenv script
WC_INSTALL/bin/setenv.sh
- setenv.db2 script
- WC_INSTALL/bin/setdbenv.db2.sh
- setenv.oracle script
- WC_INSTALL/bin/setdbenv.oracle.sh
To change the environment variable setting scripts:
Procedure
- Open the script in a text editor.
- Confirm that the values set for environment variables in the script are correct for the system on which you plan to run the loading utilities.
- Save any changes.
- Verify these scripts have the correct permissions to run.
For example, you may need to change the values for one or more of the following paths in the setenv scripts:
- JAVA_HOME
- DB2_DRIVER
- ORACLE_HOME
- ORACLE_DRIVER
- ORACLE_CLASSPATH
- CLASSPATH
Next topic: Configure tracing and logging for the loading utilities
Related concepts
Overview of the mass load utilities
Transforming, loading, and extracting data using the WebSphere Commerce loading utilities
Related tasks
Configure tracing and logging for the loading utilities
a href="../tasks/tml_config_idresgen.htm" >Configure the idresgen utility
a href="../tasks/tml_config_massload.htm" >Configure the massload utility
a href="../tasks/tml_extract.htm" >Extract data
a href="../tasks/tml_gen_dtd.htm" >Generate a DTD
a href="../tasks/tml_load_data.htm" >Load data using the mass load utility
a href="../tasks/tmlresid.htm" >Resolve identifiers
a href="../tasks/tml_transform_xml.htm" >Transforming XML data
h3>Related reference
dtdgen utility
massextract utility
idresgen utility
massload utility (Server environment)