Creating and modifying distributed pools

To create distributed pools

1. In Developer Studio, select File > New > Distributed Pool.
2. Select the server on which to create the pool, and click Finish.

3. In the Basic panel of the Distributed Pool editor, enter this information:

   Field	Description
   State	Specifies whether the pool is active (enabled) or inactive (disabled). Select the appropriate value: Enabled (default) Disabled
   Default Pool	Specifies whether the pool is the default pool. The default pool is used when no pool is specified for a distributed operation. For more information, see Default distributed pool.
   Polling	Specifies whether the pool is a polling pool. Selected—It is a polling pool. (Default)Not selected—It is not a polling pool. For more information, see Setting polling intervals for distributed pools below.
   Interval (mins)	If the Polling check box is selected, specifies the interval, in minutes, at which the pool queries the distributed pending queue. The minimum interval is 5 minutes (default). The maximum interval is 1440 minutes (24 hours). If you enter values outside these limits, the system uses the limit closest to your value. Important: When setting a polling interval, consider the number of requests processed by the pool. For example, if a pool processes 2 million requests each day and has a 720-minute (12-hour) polling interval, the pool will be deluged with 1 million requests to process every 12 hours. For more information, see Setting polling intervals for distributed pools.

4. Select File > Save.

5. In the New Name field, enter a name for the pool, then click OK.
   Distributed pool names can have up to 80 characters, including blank spaces. Do not use special characters, such as a forward slash (/), a colon (:), or a question mark (?). Use alphanumeric characters only. (See Distributed-Server-Option-logging.)

   Important

   DSO recognizes only one distributed pool for each pool name and creates a log file for that pool (see Configuring-Distributed-Server-Option-logging). Thus, you cannot use the same name for multiple pools, even if you use a different case. For example, DSO considers pool names HIKE4, Hike4, and hike4 to be the same and creates only one pool with these values.

6. (Optional) In the Properties tab, select the Help Text property, click its ellipsis button, enter any appropriate Help text for the pool, and click OK.
7. (Optional) In the Properties tab, select the change history New Description property, click its ellipsis button, enter any appropriate change history information for the pool, and click OK.
   See the definition for Change History in Field-Properties.
8. Select File > Save, then restart the DSO server.

To modify distributed pools

1. Open Developer Studio.
2. In AR System Navigator, expand the appropriate server tree.
3. In the server tree, expand the All Objects node.
4. In the All Objects list, double-click Distributed Pools.
   The Distributed Pools tab appears in the object lists area. The tab lists the distributed mappings defined on the server.
5. Double-click the distributed pool that you want to modify.
   The distributed pool appears in the Distributed Pool editor.
6. Modify the pool as necessary.
7. Select File > Save, then restart the DSO server.

To copy distributed pools

1. Open Developer Studio.
2. In AR System Navigator, expand the appropriate server tree.
3. In the server tree, expand the All Objects node.
4. In the All Objects list, double-click Distributed Pools.
   The Distributed Pools tab appears in the object lists area. The tab lists the distributed pools defined on the server.
5. Double-click the distributed pool that you want to copy.
   The distributed pool appears in the Distributed Pool editor.
6. Select File > Save As.
7. In the Save Distributed Pool As dialog box, enter a name for the new distributed pool.
8. Click OK.
   The new distributed pool is listed on the Distributed Pools tab.
9. Restart the DSO server.

To delete a distributed pool

1. Open Developer Studio.
2. In AR System Navigator, expand the appropriate server tree.
3. In the server tree, expand the All Objects node.
4. In the All Objects list, double-click Distributed Pools.
   The Distributed Pools tab appears in the object lists area. The tab lists the distributed pools defined on the server.
5. Select the distributed pool that you want to delete.
6. Select Edit > Delete.
   You cannot delete enabled distributed pools.
7. In the confirmation message, click OK.
   The distributed pool is deleted from the server, and its name is removed from the Distributed Pools tab.

Setting polling intervals for distributed pools

By default, all distributed pools are nonpolling pools—they query the distributed pending queue in real-time whenever a request associated with the pool is submitted to the queue.

For pools with heavy activity, make them polling pools, which query the distributed pending queue at specified intervals. For example, suppose a pool is configured to query the queue every 12 hours. If a request associated with the pool is submitted to the queue 1 hour after the pool's last query, the request is not processed for 11 hours. Use this option to shift the processing of noncritical requests to periods of low database activity.

To set a polling interval for a distributed pool, use the Distributed Pool editor. See the table in To create distributed pools.

When a distributed pool is disabled, the operations associated with it are processed by the default pool. If the default pool is a polling pool, the operations are not immediately processed. Consider this when setting up your pools.