Export Marketing Statistics utility

This utility exports marketing statistics to an XML file.

Attention: Instead of following the procedure in this topic, you can use the DownloadStatistics scheduled job to transfer your marketing and search rule statistical data from your production server to your staging server. For more information, see Scheduling the DownloadStatistics job to copy marketing and search statistics.

Export Marketing Statistics

ID Resolve Syntax Diagram

For IBM i OS operating system

Export Marketing Statistics


ID Resolve Syntax Diagram
Notes:
  1. The preceding diagram is intended primarily as a reference for the command parameters. The command file or script that is provided for this command and listed in Copying statistical data from the production server acts as a wrapper to the actual Java command and accepts the same parameters; therefore, it is recommended that you use the command file or script rather than invoke the Java command directly.
  2. File names that are specified as parameters for this command can be preceded by relative or absolute paths.

Parameter values

database_type
The type of database you are using, either DB2 or Oracle.
For IBM i OS operating system Must be DB400.
database_name

AIXLinuxWindowsThe name of your database. DB2 users enter the simple name of their database.

OracleIdentify the database by using the following format: hostname:port:sid. This name identifies the host name of the database server, the port number of the server, and the system ID

For IBM i OS operating system The relational database name. This name must match the name that found when you run the Work with Relational Database Directory Entries (WRKRDBDIRE) command.

database_user_id
The user ID of the database owner.
For IBM i OS operating systemThis Id is also known as the instance user profile.
database_password
The password for the database owner ID.
output_file_name
The path and name of the output file with an .xml extension (if no path is specified, the default is the current directory).
table_name
The name of the database table that you want to export.