Creating the DB2® database and table spaces for a Content Platform Engine object store

Create a database and table spaces for a Content Platform Engine object store on Db2® for Linux®, UNIX and Windows. Each additional object store will require an additional table space and a unique table space user.

  • Do not share the database used for the GCD with object stores or IBM® Content Navigator configuration data.
  • The database name needs to be unique and from 1 to 8 characters long. The table space name must be at most 18 characters long.

    Any table space that is used by the workflow system must have an all upper-case name. If you plan to use the Content Platform Engine object store table space for the workflow system, use an upper-case name for that table space.

  • Drop the default user [regular] table space - USERSPACE1 after creating the database.
  • Update the following configuration parameter. Set the value, minimally, to the value indicated here:
    APPLHEAPSZ 2560

If you want to add a workflow system to an object store that does not already have one, the workflow system can use the table spaces that are used by the object store. Alternatively, you can create new table spaces for the workflow system, according to the rules on table space types and minimum sizes that are documented here.

If you are creating a table space for a new object store on an existing system, define the new table space with the same table space type and storage method used for existing object store table spaces.

The following table shows the recommended table space names, types, and minimum sizes:
Table 1. Recommended table space names, types, and minimum sizes
table spaces Minimum Size (MB) Minimum Page Size (KB) Description
DATA_TS

Configure as LARGE type and automatic storage.

 768 32 (required) This is the default name of the data table space used by Content Platform Engine.
Icon representing the worksheet
Record this value in your customized Installation and Upgrade Worksheet. To find this property, use the Autofilter drop-down arrow in Column F, Property or Parameter (in user interface), to select Data table space name.
index_ts

(optional)

Configure as LARGE type and automatic storage.

 512 32 (required) This is the default name of the optional default index table space used by Content Platform Engine. If you do not create an index table space, the data table space will be used for indexes.
Icon representing the worksheet
Record this value in your customized Installation and Upgrade Worksheet. To find this property, use the Autofilter drop-down arrow in Column F, Property or Parameter (in user interface), to select Index table space name.
lob_ts

(optional )

Configure as LARGE type and automatic storage.

 512 32 (required) This is the default name of the optional default LOB table space used by Content Platform Engine. If you do not create a LOB table space, the data table space will be used for LOB data.
Icon representing the worksheet
Record this value in your customized Installation and Upgrade Worksheet. To find this property, use the Autofilter drop-down arrow in Column F, Property or Parameter (in user interface), to select LOB table space name.
user temporary ts 80 32 (required) This is the default user temporary table space, required for Content Platform Engine use.
system temporary ts 80 32 (required) This is the default system temporary table space, required for Content Platform Engine use.