Administering the Sun Business Process Manager Database

Installing the Purge and Archive Database Components

Before you can run the purge and archive scripts you need to install the stored procedures and tables to support the processes. Make sure you have created the database and downloaded the compressed database scripts as described in Downloading the Compressed Script Files before beginning this procedure.

ProcedureTo install the purge and archive database components

  1. Open a command window and navigate to the directory where you downloaded the scripts.

  2. Do one of the following:

    • For Oracle and DB2 databases, enter the following command:

      install_arch_and_purge_scripts user password database

    • For Sybase and SQL Server databases, enter the following command:

      install_arch_and_purge_scripts user password server database