You can create a group and then add one or more tenants to it.
1. Select Database Administration > New > Group. in the management console.
The New Group page appears.
2. Provide the following information:
Group name — The name of the group, which must be unique within the database. Do not use spaces or special characters such as an asterisk (*), ampersand (&), or period ( . ) in this field. You can include the underscore (_).
Description — An optional description of the group.
3. In the Database connection name, enter a database connection name to which you want to add the new group. By default, the last used database connection name appears in the Database connection field.
Note: If you type the name of the database connection, follow the format used by OpenEdge Management/OpenEdge Explorer to define a connection: AdminServer-name.database-name. A database server must be running for you to connect to the database.
You can also click the Search icon to choose a database for which you are creating the tenant from the Connection Selection dialog.
The Connection Selection dialog displays the connections details in a grid. You can perform the following:
Filter the connections in the grid by a Connection name, AdminServer, and/or Category.
Select the column heading and click the drop-down to choose the order (ascending or descending alphabetically) for the connections to appear in the grid.
4. Choose the Table you want to place in the group by either typing the table name or clicking the Search icon to select the table from the Table Selection dialog.
Note: There is one table per group and one or more tenants per group.
5. Select the default data area, default index area, and default LOB area. For each of the areas, you can either type the area name or click the Search icon to select the area from the Area Selection dialog.
The Area Selection dialog displays the storage area names in a grid. You can perform the following:
Filter the storage area name in the grid by Area name, Records per block, and/or Cluster size.
Move forward or backward a page, or specify a particular page, in the list of domains by using the Page feature at the bottom of the list.
Select the column heading and click the drop-down to choose the order (ascending or descending alphabetically) for the area names to appear in the grid.
6. On the Partitions tab, select an item in the table schema to view its properties, which include name, type, area, buffer pool assignment, and allocation state.
7. Set the area for each partition individually by clicking the Search icon and choosing an area from the list.
8. Select a buffer pool assignment of Primary or Alternate.
9. To modify theallocation state, choose from either of the options.
10. You can perform the following actions:
To add one or more tenants to the group and then create the group immediately:
1. Click the Tenants tab.
2. Click Add Tenant.
3. From the list of tenants that appears, select one or more tenants.
4. Click OK. The newly added tenants are listed as belonging to the group.
5. Click Save to save the group. If the partition in the group has already been allocated for a newly added tenant, an error message appears and the group is not created.
To save the group without adding tenants:
1. Click Save.
2. Click Yes to the message confirming that the group has no tenants.
11. To create a group creation script, click Generate group program.
12. From the list of groups, click Refresh. The new group appears in the list of groups.
Group name — The name of the group, which must be unique within the database. Do not use spaces or special characters such as an asterisk (*), ampersand (&), or period ( . ) in this field. You can include the underscore (_).