To launch the Loader package utilities, use the scripts provided in the WebSphere Commerce directory:
WC_installdir/bin
- Important: To run the scripts, launch a qshell command window by running the STRQSH command.
WC_installdir\bin
WCDE_installdir\bin
The utilities are as follows:
The Loader package utilities, call scripts and batch files containing environment-variable settings. These are the setenv, setdbenv.db2, and setdbenv.oracle files; and they are located in the following directories by default:
WC_installdir/bin
WC_installdir\bin
WCDE_installdir\bin
You may need to modify these files when you customize your system. Here are two examples:
On a Windows operating system, you may need to change the values for one or more of the following paths in setenv.bat:
- JAVA_HOME
- DB2_DRIVER
- ORACLE_HOME
- ORACLE_DRIVER
- ORACLE_CLASSPATH
These environment variables are set in setenv.bat and used in setdbenv.db2.bat or setdbenv.oracle.bat, depending on the database that you are using.
If you want to run the Loader command using Oracle 9 but the environment variables are pointing to your older Oracle 8i drivers, you may need to update three variables in the environment-setting files to point to the Oracle 9i drivers. For the Windows operating system, the new lines would look something like this:
SET ORACLE_CLASSPATH=C:\oracle9\ora9\jdbc\lib\classes12.zip; SET ORACLE_DRIVER=C:\oracle9\ora9\jdbc\lib\classes12.zip; SET ORACLE_HOME=C:\oracle9\ora9