Configuration for OneDB database

DBspace

Create a new dbspace with page size 16K or greater.
Note: If the page is less than 16K then while executing $campaign_installation_home_path/Campaign/ddl/Unicode/ac_systab_OneDb.sql DDL scripts, it displays an error message "Total length of columns in constraint is too long". This DDL has a unique constraint on five columns with same data types. The constraints are on the number of columns, total size of the index, and page size. By default, both the buffer pool and the root dbspace on Windows is created with 4K page size and on Linux it is 2K only.

Create a new DBSpace with custom size

Prerequisites: You must have installed OneDB database server.

OneDB software bundle

  • OneDB database server must be up and running.
  • Create a <some_name>.dat file on the system, preferably under onedb_Directory directory structure.
Steps for Windows
  1. Open a console with Administrator privileges.
  2. Navigate to $onedb_Directory location.
  3. In the command prompt, run $onedb_Directory>onedb.cmd. This sets the OneDB environment for this console. you have installed, this may be ‘ol_onedb'. Set the following variables for Plan.
    • DB_LOCALE=en_US.utf8
    • CLIENT_LOCALE=en_US.utf8
    • SERVER_LOCALE=en_US.utf8
  4. Navigate to $onedb_Directory>cd bin.
  5. In the command prompt, run $onedb_Directory/bin> onspaces -c -d <Db_Space_Name> -k 16 -p "<absolute-path-till>\ onedb_Directory\data\<.dat file name>" -o 0 -s 2000000. The following is the expected output for this command.
    • Verifying physical disk space, please wait
    • Space successfully added.
    • ** WARNING ** A level 0 archive of Root DBSpace will need to be done.
  6. Navigate to $onedb_Directory/bin> onmode -ky. This shuts down the OneDB database server.
  7. In the command prompt, run $onedb_Directory/bin>oninit -vy. This restarts the OneDB database server.

SBspace

Create a new sbspace for OneDB database. This space is specifically used to store smart large objects and few of the Campaign system tables, which include column types BLOB or CLOB. When data is entered into this table, OneDb uses SBspace to store the information in BLOBs/CLOBs. You must have atleast one SBspace created in addition to the system SBspace.

Prerequisites

  • You must have installed OneDB database server. For instance, onedb_Directory is C:/program files/.
  • OneDB database server must be up and running.
  • You must create a <xyz>.dat file on the system, preferably under <onedb_Directory> directory structure.

Create a new SBspace

Steps for Windows
  1. Open a console with administrator privileges.
  2. Navigate to $>cd %onedb_Directory%. This sets the OneDB environment for this console.
  3. Navigate to $onedb_Directory>cd bin.
  4. In the command prompt, run $onedb_Directory/bin> onspaces -c -S <Sb_Space_Name> -p "<absolute-path-till>\onedb_Directory \data\<.dbs file name>" -o 0 -s 10240
    <offset> -s <size>. The following is the expected output of the above command.
    • Verifying physical disk space, please wait ...
    • Space successfully added.
    • ** WARNING ** A level 0 archive of Root SBSpace will need to be done
  5. Open % onedb_Directory %\etc\onconfig.onedb' file.
  6. . Search for 'Dbspace and sbspace Configuration Parameters' and not 'Temporary dbspace and sbspace configuration parameters.
  7. Add created sbspace name (for example: <Sb_Space_Name>) in front of SBSPACENAME configuration parameter.
  8. In the command prompt, run $onedb_Directory/bin> onmode -ky. This shuts down the OneDB database server.
  9. In the command prompt, run $onedb_Directory/bin>oninit -vy. This restarts the OneDB database server.

Appendix

Element Purpose
-c Creates a dbspace

You can create upto 2047 storage space of any type.
-d dbspace Names the dbspace to be created.
-k Indicates in KB, the non-default page size for the new dbspace. For systems with sufficient storage, performance advantages of a larger size can include the following.
  • Reduced depths of B-tree indexes, even for smaller index types
  • You can group on the same page long rows that currently span.
  • Checkpoint time is typically reduced with larger pages.
  • You can define a different page size for temporary tables so that they can have a separate buffer pool
-o offset Indicates, in KB, the offset into the disk partition or into the device to reach the initial chunk of the new dbspace.
-p Indicates the disk partition or device of the initial chunk of the dbspace that you are creating.
-s Indicates in KB, the size of the initial chunk of the new dbspace.