Configuring a Database with Query Partitions

If a database is to participate in a tiered storage scheme using query partitions, it must have these settings:

• Rebalancer enable set to true

• Rebalancer Assignment Policy set to query

• Locking set to strict

• Indexes established for the elements or properties to be queried

• Query partitions, as described in Creating Query Partitions

For details on the database rebalancer with the query assignment policy, see the sections Query Assignment Policy, Configuring the Rebalancer on a Database, and Configuring the Rebalancer on a Forest.

To configure a database to use the query assignment policy, follow these steps:

1. Click Databases in the left tree menu. A list of databases appears.

2. Click your target database.

3. On the configuration tab for the database, set the Assignment Policy to query. The Default Partition field appears.

4. [OPTIONAL] Enter the partition number for a default query partition in the Default Partition field. If you do not define a default query partition, then your database must have forests that are not part of a query partition. These forests will serve the same role as a default partition.