Maximum What-If Databases

This field applies to APS.

Enter the number of temporary copies of the planner database that can exist in the server's memory at the same time for APS planning functions. When you use the Get ATP or Get CTP functions, the system creates a temporary copy of the planner database in memory, on which it runs the calculations to determine the projected date for the order or line item. If multiple workstations run the Get ATP/CTP function simultaneously, the available memory on the server may be exceeded. Use this field to limit the number of concurrent database copies to within your server's memory capacity.

This field defaults to 2, and you may specify up to 20. If you require a maximum greater than 20, use the Specific APS Options tab on the Planning Parameters form to adjust the maximum amount.

The Availability Results dialog, which displays during a Get ATP/CTP process for a line item, includes a Quantities button, which displays the quantity of the line item that can be completed by the request date. Clicking the Quantities button creates two additional copies of the planner database in memory. These copies remain in memory until the Get ATP/CTP dialog is closed. Therefore, if all your users are likely to use the Quantities button, multiply your base Max What-If Databases figure by three.

EXAMPLE: Suppose you have 5 client machines that will potentially use the Get ATP/CTP feature, and all of those machines will likely use the Quantities button on the Get ATP/CTP dialog. Your worst-case requirement for what-if databases would be 5, plus an additional 15 for clients using the Quantities button, for a total of 20. If you do not anticipate all 5 clients using the Get ATP/CTP feature simultaneously, adjust the figure appropriately.