Resizing the Initial Workstation Database

You can change the initial database size of a workstation. Configure the starting database size and growth pattern (Pre-sized or AutoGrow) for the Simphony client databases, and the Generate XML feature creates the CAL package to be added to the application. The Generate XML function only sets the initial size of the database; it cannot shrink a database that is too large. Use caution with Generate XML to avoid harming operations.

1. Select the Enterprise level, click Setup, and then click CAL Packages.
2. Click the Generate XML tab.
3. From the Sizing Mode drop-down list, select the method for sizing the database:

   • Select AutoGrow for high volume locations where the size of the database on disc grows through a nightly job. AutoGrow mode allows the application to size the database during a nightly job at a specified time. This avoids the lengthy delays of sizing until the application is not in use. Do not select this option for workstations equipped with the 8GB Universal Disk On Chip (UDOC).

   • Select PreSized for workstations with limited disc space where the Simphony default database sizes are not proportionate to the available space. You can set a maximum size for each database and log file, and reserve a percentage of the available disc space for non-database files. In Pre-sized mode, the database is potentially sized every time the workstation Service Host starts, and the database does not grow.

4. In the Non DB Percentage field, enter a percentage (between 0 and 100) of the free space of the disc to reserve for non-database content.
5. In the Resize Time field, enter the amount of time in hours and minutes for the nightly resize job.

   The value in this field determines the time on a 24-hour clock to run the database resize job, which attempts to resize the database outside of business hours. Although this field is required, PreSized mode ignores the value entered as there is no nightly resize job.

6. Select the database to configure from the Alias drop-down list. You can resize the following database configurations:

   • LocalDB (local datastore database)

   • CPServiceDb (CAPS database)

   • KDSServiceDb (KDS database)

   • CMLocal (cash management database)

7. In the Data File and the Log File sections, enter the appropriate values as described in the following table. To set the default database configuration, select Use Default Values.

   Table 1-2 Data File and Log File Database Configuration

   Field	Description
   Initial Size	Enter the initial size of the database file. Define the size with a number followed by M, G, or T suffixes to indicate megabytes, gigabytes, or terabytes.
   Maximum Size (AutoGrow mode only)	Enter the maximum size to which the database can grow. If there is not enough unreserved space to fit the maximum size, the configuration does not validate. The NonDB Percentage value you entered determines how much of the free space is not available for the databases.
   Auto Grow Floor (AutoGrow mode only)	Enter the size of the free space within the database that triggers a nightly grow event. If you set this value to 10M and the free space inside the data file goes below 10M, the nightly resize job attempts to resize the database.
   Auto Grow Increment (AutoGrow mode only)	Enter the auto growth increment for the database. This value is used by the nightly resize job when the database must grow.

8. Click the Add button.
9. Click the ellipsis point (...) button, select the destination folder, and then click OK.
10. Click the Generate button.