Copying statistical data from the production server

To copy Marketing Event statistical data from a production machine to a development or staging server, do the following:

  1. From a command line, change to the following directory on the production server:
    AIXiSeriesLinuxSun Solaris Operating EnvironmentWC_installdir/bin
    WindowsWC_installdir\bin
  2. Run the ExportStats command by entering the following (Note: All of the parameters are mandatory):
    AIX ExportStats -Ddatabase_type -Ndatabase_name -Udatabase_user_id
           -Pdatabase_password -Foutput_file_name-Ttable_name
    iSeriesExportStats.sh -Ddatabase_type -Ndatabase_name -Udatabase_user_id
          
    -Pdatabase_password -Foutput_file_name -Ttable_name
    Sun Solaris Operating Environment ExportStats -Ddatabase_type -Ndatabase_name -Udatabase_user_id
           -Pdatabase_password -Foutput_file_name -Ttable_name
    Linux ExportStats.sh -Ddatabase_type -Ndatabase_name -Udatabase_user_id
          
    -Pdatabase_password -Foutput_file_name -Ttable_name
    Windows ExportStats -Ddatabase_type -Ndatabase_name -Udatabase_user_id
           -Pdatabase_password -Foutput_file_name -Ttable_name

    where:

    AIXLinuxSun Solaris Operating EnvironmentWindows database_type
    is the type of database you are using, either DB2 or Oracle.
    is the type of database you are using, DB2.
    iSeries database_type
    on iSeries must be DB400.
    database_nameAIXLinuxSun Solaris Operating EnvironmentWindows
    The name of your database. DB2 users enter the simple name of their database. Oracle users identify their database using the following format: hostname:port:sid identifying the hostname of the database server, the port number of the server, and the system ID.
    database_user_id
    is the user ID of the database owner. iSeries This is also known as the instance user profile.
    database_password
    is the password for the database owner ID.
    output_file_name
    is 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
    is the name of the database table that you want to export.

    This will create an XML file.

  3. Transfer the XML file to the development or staging server.
  4. Place the XML file in the following directory on the development or staging server:
    AIXiSeriesLinuxSun Solaris Operating EnvironmentWC_installdir/bin
    WindowsWC_installdir\bin
  5. Run the ImportStats command by entering the following:
    AIX ImportStats -Ddatabase_type -Ndatabase_name -Udatabase_user_id -Pdatabase_password
              -Finput_file_name
    iSeriesImportStats.sh -Ddatabase_type -Ndatabase_name -Udatabase_user_id -Pdatabase_password
              -Finput_file_name
    Sun Solaris Operating Environment ImportStats -Ddatabase_type -Ndatabase_name -Udatabase_user_id -Pdatabase_password
              -Finput_file_name
    Linux ImportStats.sh -Ddatabase_type -Ndatabase_name -Udatabase_user_id -Pdatabase_password
              -Finput_file_name

    Windows ImportStats -Ddatabase_type -Ndatabase_name -Udatabase_user_id -Pdatabase_password
              -Finput_file_name where:
    AIXSun Solaris Operating EnvironmentLinuxWindows database_type
    is the type of database you are using, either DB2 or Oracle.
    is the type of database you are using, DB2.
    iSeries database_type
    on iSeries must be DB400.
    database_name
    AIXSun Solaris Operating EnvironmentLinuxWindows The name of your database. DB2 users enter the simple name of their database. Oracle users identify their database using the following format: hostname:port:sid identifying the hostname of the database server, the port number of the server, and the system ID.
    database_user_id
    is the user ID of the database owner. iSeries This is also known as the instance user profile.
    database_password
    is the password for the database owner ID.
    input_file_name
     is the path and name of the output file created with the ExportStats utility in step 2 (if no path is specified, the default is the current directory).

    This will delete any statistical information in the development or staging server database, and import the statistics.