Creating an Oracle Database for the Archival Service

Create an Oracle database for the Archival Service by configuring and running the provided scripts.

Procedure

  1. Open $OM_HOME/db/dbscripts/oracle/archival/oracle_archival_db.properties file in a suitable editor and update the following values:
    Property Update the Value for
    ORCL_HOST Oracle database host
    ORCL_PORT Oracle port
    ORCL_USERNAME Oracle superuser name
    ORCL_PASSWORD Oracle superuser password
    ORCL_SERVICENAME Service name of the database
    ORCL_ARCHIVAL_USER New Archival user
    ORCL_ARCHIVAL_PASSWORD Password for the Archival user
    ORCL_ARCHIVAL_TABLESPACE Archival tablespace
    ORCL_TABLESPACE_SIZE Size of the tablespace
    ORCL_MINSIZE Minimum tablespace size
    ORCL_MAXSIZE Maximum tablespace size
    ORCL_DATAFILE_PATH data file path of Oracle
    IS_CLOUD_PLATFORM Default value is false. You need to set it to true if the database is on a cloud platform.
    EXECUTE_DDL_DML_ONLY Default value is false. You need to set it to true if you want to execute only DDL/DML.
  2. Save and close the file.
  3. Run the $OM_HOME/db/dbscripts/oracle/archival/db-setup.sh script.

Creating new partitions to the ORDERS table

The following procedure helps you to create new partitions to the TIBCO Order Management 5.1.0 database ORDERS table.

Prerequisites

You must have the CREATE JOB privilege.

Procedure

  1. Run $OM_HOME/db/dbscripts/oracle/archival/OM_Create_Future_Partitions_SQL_Weekly.sql script and store this procedure in the database.
  2. Run $OM_HOME/db/dbscripts/oracle/archival/OM_Future_Partitions_Weekly_JOB.sql script to create a new job for scheduling autorun of future partition procedure.

What to do next

Verify on the 1st of every month at 1 am, the script is run to create future partitions.
Note: By default partitions till December 2021 get created. Post this time period, you can customize partition interval.