Administering the Sun Business Process Manager Database

Running the Database Scripts from a Local Directory

This is an alternative method to running the database scripts from Enterprise Designer. You can download the database scripts and run them outside of the Java CAPS environment. Make sure to review the information under Creating the Database Instance, which contains information specific to Oracle and DB2 databases.

The following files are included in the zipped file.

Downloading the Compressed Script Files

In order to work with the compressed script files, you need to export them to a local directory and then extract the compressed files.

ProcedureTo download a compressed script file

  1. In the Project Explorer, expand Sum BPM, and the expand Download Database Scripts.

  2. Right-click the file associated with the appropriate database (oracle.zip, sqlserver.zip, db2.zip, or sybase.zip).

  3. Click Export.

  4. Browse to a local folder to store the database files, and then click Save.

  5. Navigate to the local folder and extract the compressed files.

  6. Follow the instructions in the Readme.txt file.

Running the Downloaded Scripts

Once you download the compressed database scripts and modify them as needed, you can run the scripts from a command line. The database user that executes these scripts must have permission to create tables and users. Review Viewing and Modifying Database Scripts in Enterprise Designer before running the scripts (additional information is also available in the Readme.txt file).

ProcedureTo run a downloaded database script

  1. Open a command window and navigate to the directory where scripts are located.

  2. Do one of the following:

    • For Oracle databases, enter the following command:

      install_db user password database

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

      install_db user password server database

    • For DB2 databases, enter the following command:

      install_db user password database server

    Where:

    • user is the database username.

    • password is the database user password.

    • server is the name of the machine on which the database resides.

    • database is the database or SID name.


      Note –

      The default user and password created from these scripts is "bpm6user". You can modify the user, password, disk space allocated for tables, and user permissions. The table and column definitions should not be modified.