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
Before you begin:- The custom table spaces must exist prior to the execution
of database transfer.
- To see which table spaces can be
customized in each domain, refer to the wp_profile_root/PortalServer/config/tablespaces/dbdomain.space_mapping.properties file.
- For details on creating table spaces refer to the
documentation for the database.
About this task
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:
Procedure
- Determine the names of your custom table
spaces.
- Open the mapping file wp_profile_root /PortalServer/config/tablespaces/dbdomain.space_mapping.properties that
specifies the table space and index space property pairs for each
database table:
- dbdomain.table_name.tablespace
- dbdomain.table_name.index_name.indexspace
For the file name and each table space and index space property
pair, dbdomain can be any one of the following
values:- release
- community
- customization
- jcr
- feedback
- likeminds
Note: For jcr, you need to open an additional maping file:
wp_profile_root/PortalServer/jcr/config/jcr.space_mapping.properties.
This mapping file contains additional table space and index space
property pairs for each jcr.table_name.tablespace database table.
- Assign a table space to each entry
in the mapping file. The table space name must be prepended by the
keyword TABLESPACE and a space. For example: community.COMP_INST.tablespace=TABLESPACE
COMM8KSPACE
Repeat this step for
each domain that you are transferring.
- Save and close dbdomain.space_mapping.properties.
- From a command prompt, specify the
option -DuseCustomTablespaceMapping=true when starting
the database transfer. For example,
- Windows: ConfigEngine.bat
database-transfer -DuseCustomTablespaceMapping=true
- UNIX: ./ConfigEngine.sh
database-transfer -DuseCustomTablespaceMapping=true
- IBM® i: ConfigEngine.sh
database-transfer -DuseCustomTablespaceMapping=true