To set cache and control options :

  1. Click on the Setup button in the Start Database window. The Start Database Advanced Settings window appears.

  2. Click the Cache and Control tab in the Start Database Advanced Settings window.

  3. Enter the number of journal buffer pages to allocate from memory in the Size of Journal Buffer field.

  4. Enter the number of data buffer pages to allocate from memory in the Size of Data Buffer field.

  5. Enter the number of pages to allocate from memory for the System Control Area in the Size of System Control Area field.

  6. Enter the maximum number of users that can connect to the database in the Maximum number of Connections field.

  7. To enable catalog cache turbo mode click on the check box next to Catalog Cache Turbo Mode.

  8. Enter the number of pages at which a page lock will escalate to a table lock in the Threshold of lock Escalation form Page to Table field.

  9. Enter the number of rows at which a row lock will escalate to a page lock in the Threshold of lock Escalation form Row to Page field.

  10. To change the display content of the SQL_CMD and TIME_OF_SQL_CMD columns in the SYSUSER system table, select one of the three option buttons.

  11. To change the lock mode of "Select .for Update" SQL commands, select one of the two option buttons.

  12. Click the Save button to save al changes to the dmconfig.ini file.

  13. Click the Cancel button to return to the Start Database window, and click Start to start the database.


Related Topics:

Setting Cache and Control Options
Cache and Control