Deprecated featureWebSphere Commerce Developer

massload utility (Development environment)

This utility loads an XML input file into a target database. Loading the XML file for populate and updates the WebSphere Commerce database. The massload utility allows column-level updates to a table. It also allows you to delete data from a database.

Note: The massload utility loads only one file at a time.

Feature Pack 6 or laterThe massload utility is deprecated for WebSphere Commerce Version 7 Feature Pack 6. The Data Load utility is the recommended command-line loading utility. If you are currently using the mass load utility, you are recommended to switch to the Data Load utility to load your CSV and XML input files into your target database. If your system contains scheduled and automated processes that use massload, it is recommended that you update these processes to use the Data Load utility. Other WebSphere Commerce utilities that use the massload utility, such as the acpload utility, continue to use the massload utility in WebSphere Commerce Version 7 Feature Pack 6. If you have business reasons to continue using the massload utility, you can continue to use this utility. For more information about the Data Load utility, see Overview of the Data Load utility. You can switch to the Data Load utility by using the TableObjectMediator to load your data when no business object mediator exists for the data that you are loading. For more about the TableObjectMediator formation, see Data Load utility table-based mediator and builder.

SolarisLinuxWindowsAIXFor IBM i OS operating systemThe page covers the massload utility in the WebSphere Commerce development environment. For the massload utility in the WebSphere Commerce server environment, see massload utility (Server environment).

The massload utility required valid and well-formed XML as input to the database. In this input, element names correspond to table names and attributes of the element correspond to column names in the table.

The massload utility includes the following features:

Error reporter
The massload utility includes an error reporter that generates an exception document if there is an error.
Product Advisor search-space synchronization
If you enable the loading utilities' Product Advisor search-space synchronization feature, you can maintain near real-time synchronicity of Product Advisor search spaces and WebSphere Commerce catalog tables that are being updated by the massload utility.

Before you run this utility, ensure that you have complete the required configuration tasks:

  1. Configure the loading utilities.
  2. Configure tracing and logging for the loading utilities.
  3. Configure the massload utility.
  4. Optional: Configure the file.


The syntax for the massload utility depends on which database you are using as the development database:

  • Apache Derby Mass load syntax diagram
  • DB2 Mass load syntax diagram
  • For IBM i OS operating system Mass load syntax diagram
  • Oracle Mass load syntax diagram

Parameter values

XML file name
The full path to the XML file that contains the data to be loaded into the development database.
For IBM i OS operating systemHost name
For IBM i OS operating systemThe fully qualified host name of the machine that is hosting the development database.
DB name
The name of the database into which you are loading data.
DB2Note: For DB2 UDB databases, the DB2 Type 4 JDBC driver is used, where the Type 4 database name is prefixed with the database server and port. For example, db_server:db_port/db_name.
DB user
The ID of a database user authorized to connect to the database.
DB pwd
The password for the database user.
DB schema
The name of the database schema into which you are loading data. Specify the schema name in uppercase letters.