Creating a default sbspace

If the access method supports sbspaces, the user, typically the database server administrator, can create a default sbspace.

About this task

To create a default sbspace:

Procedure

  1. Create a named sbspace with the onspaces utility.

    When you create the default sbspace, you can turn on transaction logging.

  2. Assign that name as the default sbspace in SBSPACENAME parameter of the onconfig file.
  3. Initialize the database server with the oninit utility.

Example

For example, you create a default sbspace named vspace with the following steps.
  1. From the command line, create the sbspace with logging turned on: 
    onspaces -c -S vspace -p path -o offset -s size -Df "LOGGING=ON"
  2. Edit the onconfig file to insert the following line:
    SBSPACENAME vspace # Default sbspace name
  3. Take the database server offline and then bring it online again to initialize memory with the updated configuration. 
    onmode -ky
oninit