Export Marketing Statistics utility

This utility exports marketing statistics to an XML file. Attention: Instead of following the procedure in this topic, we can use the DownloadStatistics scheduled job to transfer your marketing and search rule statistical data from your production environment to your staging environment. See Scheduling the DownloadStatistics job to copy marketing and search statistics.

Export Marketing Statistics

(IBM i)

Export Marketing Statistics

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 environment acts as a wrapper to the actual Java command and accepts the same parameters; therefore, IBM recommends using the command file or script rather than invoke the Java command directly.

2. File names specified as parameters for this command can be preceded by relative or absolute paths.

Parameter values

database_type

The type of database we are using, DB2.

(IBM i) Must be DB400.

database_name

(DB2) The name of the database. DB2 users enter the simple name of their database.

(Oracle) Identify the database 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

(IBM i) 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.

(IBM i) This 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 to export.

Related tasks
Running utilities from the Utility server Docker container