Windows stand-alone: Assign custom SQL Server filegroups
The repository of WebSphere Portal consists of many tables and indicecreated in default filegroups. When using an existing set of filegroups for the objects of the repository, specify this when executing the database transfer to the target management database system.Before beginning:
- The custom filegroups must exist prior to the execution of the database transfer.
- To see which table spaces can be customized in each domain, reference...
WP_PROFILE/PortalServer/config/tablespaces/dbdomain.space_mapping.properties
- For details on creating filegroups refer to the documentation for the database.
If custom filegroups are assigned, each must be assigned explicitly. The default filegroups can be used to contain database objects; however the name of the default file group 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 filegroups:
- Determine the names of the custom filegroups.
- Open the mapping file WP_PROFILE /PortalServer/config/tablespaces that specifies the table space and index space for each property pairs for each database table:
- dbdomain.table_name.tablespace
- dbdomain.table_name.indexspace.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
For jcr, edit mapping file:
WP_PROFILE/PortalServer/jcr/config/jcr.space_mapping.properties
...which contains additional table space and index space property pairs for each jcr.table_name.tablespace database table.
- Assign a filespace to each entry in the mapping file. The filegroup name must be prepended by the keyword ON and a space.
For example: community.COMP_INST.tablespace=ON COMM8KSPACE
Repeat this step for each domain that we 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,
./ConfigEngine.sh database-transfer -DuseCustomTablespaceMapping=true