Moving data to the PostgreSQL database on Linux

Use this procedure to migrate data from the DB2 database to the PostgreSQL database on a Linux primary server.
To move data to the PostgreSQL database on Linux:
  1. Log in to the primary computer as the Ricoh ProcessDirector system user (aiw1 is the default).
  2. Open a command prompt and type: ps -ef | grep postgres | grep -v grep and press Enter. If the PostgreSQL database is running, you see multiple lines of output. If the PostgreSQL database is not running, you see no output.
  3. If the database is not running, do these steps to start it:
    1. Go to /aiw/aiw1/config/.
    2. Open the Reports.json file in a text editor.
    3. Enable the capture property of at least one of the three reporting sections in the Reports.json file: jobStepProgress, jobPrinting, or printerStatus.

      • To enable the capture of Ricoh ProcessDirector property values and put them in the database table, set the JSON property value to enable.
      • To disable the capture, set the value to disable.

      In this example, the captureData property is set to enable:

      "captureData": "enable",

    4. Save and close the Reports.json file.
    5. Start the PostgreSQL database by doing one of these actions:
      • If jobStepProgress is enabled, run a job through a step in any workflow. You can submit a new job or continue a current job.
      • If jobPrinting is enabled, print a job to any printer.
      • If printerStatus is enabled, disable or enable any printer.
  4. In the command prompt, type: migrateReports.pl and press Enter. As the script runs, it identifies and displays the tables that are migrating from the DB2 database to the PostgreSQL database.
  5. A prompt is displayed asking you if the rptdb should be removed. To remove the database, type Yes and press Enter. To remove the database later, type No and press Enter.
  6. Verify that the data has been migrated to the PostgreSQL database correctly. Connect to the PostgreSQL database using your business intelligence tool or by using a PostgreSQL command line to verify the database tables contain the correct entries.
    If there is a problem, inspect the files containing the migrated data in the /aiw/aiw1/migrate directory. These files consist of .csv and .sql files. If the files have been migrated successfully, you can delete the /aiw/aiw1/migrate directory.

    If you encounter any problems, contact a Ricoh support representative.