Content Platform Engine, Version 5.2.1   Database:  DB2 LUW          

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.

Start of changeIf 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.End of change

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.


Last updated: March 2016
p8ppi168.htm

© Copyright IBM Corporation 2013, 2016.