Assigning custom table spaces



Search Tips   |   Advanced Search


The repository of WebSphere Portal consists of many tables and indices that are created in default table spaces. When using an existing set of table spaces for the objects of the repository, specify this when executing the database transfer to the target database system. Before you begin:


Prepare the Windows operating system

Installing WebSphere Portal on Windows

Installing DB2 on the same server as WebSphere Portal

Configure JCR collation support

Modifying database properties

Set up databases

If custom table spaces are assigned, each must be assigned explicitly. The default table spaces can be used to contain database objects; however the name of the default table space must be specified in the corresponding mapping files. This applies to all database domains that are transferred in a single database transfer.

To configure custom table space assignments:

  1. Determine the names of custom table spaces.

  2. Open the mapping file...


    ...that specifies the table space and index space property pairs for each database table:

    • database_domain.table_name.tablespace

    • database_domain.table_name.index_name.indexspace

    For each table space and index space property pair, The database_domain can be any one of the following values:

    • release
    • community
    • customization
    • feedback
    • likeminds

  3. Assign a table space to each entry in the mapping file. The table space name must be prepended by the keyword IN and a space.

    For example:

      community.comp_inst.tablespace=in comm8kspace

    Repeat this step for each domain that you are transferring.

  4. Save and close

  5. From a command prompt, specify the option...


    ...when starting the database transfer.

Parent topic:

Set up a single server

Previous topic:

Set up databases

Next topic:

Configure WebSphere Portal to use DB2