How to Separate Database Configuration (auditing, snapshots (reporting), workflow, and task persistence).
search cancel

How to Separate Database Configuration (auditing, snapshots (reporting), workflow, and task persistence).


Article ID: 40280


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On


I would like to separate my database stores into separate database instances.  How can this be accomplished?


Release: CAIDMB99000-12.6.7-Identity Manager-B to B


For scalability purposes, you may want to create a separate database to replace any one of the existing database schemas initially created by CA Identity Manager during installation.

You can create a separate database instance for each of the following:

  • Workflow

    CA Identity Manager includes SQL scripts for setting up a new workflow database instance.

    To run the CreateDatabase script:

    Follow these steps:

    1. Add the path to the sqljdbc.jar to the DB_CLASSPATH attribute in the CreateDatabase.bat or .sh script before you run it.
    2. From a command prompt, run CreateDatabase.bat or sh. The default location for this script is:
      Windows: C:\Program Files\CA\Identity Manager\IAM Suite\Identity\tools\Workpoint\install.
      UNIX: /opt/CA/IdentityManager/IAM_Suite/Identity_Manager/tools/Workpoint/install.
      A command prompt window and the WorkPoint application open.
    3. Select the database type from the drop-down.
    4. Use the following guidelines to fill in fields in the configuration utility:
      • For the JDBC Class parameter, enter:
        Oracle: oracle.jdbc.driver.OracleDriver
        SQL Server:
      • For the JDBC URL, enter:
        Oracle: jdbc:oracle:thin:@wf_db_system:1521:wf_oracle_SID
        SQL Server: jdbc:sqlserver://wf_db_system:1433; databaseName=wf_db_name
      • For the Database User ID parameter, enter the workflow user you created when creating the workflow database.
      • For the Password parameter, enter the password you created for the workflow user.
      • For the Database ID, enter WPDS
    5. Accept the default check box selections.
    6. Click the Initialize button.
      When the configuration is complete, a message that resembles the following appears in the Command Prompt window:

      The create database process finished with 0 errors.
    7. Restart the application server.
  • Auditing
    C:\Program Files\CA\Identity Manager\IAM Suite\Identity\tools\db
  • Task Persistence
    C:\Program Files\CA\Identity Manager\IAM Suite\Identity\tools\db
  • Object Store:
    C:\Program Files\CA\Identity Manager\IAM Suite\Identity\tools\db
  • Snapshots (reporting):
    C:\Program Files\CA\Identity Manager\IAM Suite\Identity\imrexport\tools\db
  • Archive (task persistence archive):
    C:\Program Files\CA\Identity Manager\IAM Suite\Identity\tools\db