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
Export Marketing Statistics
Notes:
- 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.
- 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.
- Must be DB400.
- database_name
-
The name of your database.
DB2 users enter the simple name of their database.
Identify 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 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.
- 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 that you want to export.