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
- Open a console with Administrator privileges.
- Navigate to $onedb_Directory location.
- 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
- Navigate to $onedb_Directory>cd bin.
- 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.
- Navigate to $onedb_Directory/bin> onmode -ky. This shuts down the OneDB database server.
- 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
- Open a console with administrator privileges.
- Navigate to $>cd %onedb_Directory%. This sets the OneDB environment for this console.
- Navigate to $onedb_Directory>cd bin.
- 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
- Open
% onedb_Directory %\etc\onconfig.onedb'
file. - . Search for 'Dbspace and sbspace Configuration Parameters' and not 'Temporary dbspace and sbspace configuration parameters.
- Add created sbspace name (for example:
<
Sb_Space_Name
>) in front ofSBSPACENAME
configuration parameter. - In the command prompt, run
$onedb_Directory/bin> onmode -ky
. This shuts down the OneDB database server. - 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.
|
-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. |