Starting a Database Server with an AWE Cache

Start a database with an AWE cache to take advantage of the large cache sizes available with Windows 2000, Windows XP, and Windows Server 2003. You can instruct Sybase IQ to use AWE using the start_iq server option -cw.

Prerequisites
Prerequisites:

  • You must have at least 130MB of memory available on your system.

  • If your system has between 2GB and 16GB of memory, add the /3GB option to the Windows boot line in the boot.ini file.

    If your system has more than 16GB of memory, do not add the /3GB option to the Windows boot line in the boot.ini file because Windows cannot address memory beyond 16GB.

  • If your system has more than 4GB of memory, add the /PAE option to the Windows boot line in the boot.ini file.

Task
  1. Log in to Windows as Administrator
  2. Select Start | Settings | Control Panel.
  3. Open the Administrative Tools folder.
  4. Double-click Local Security Policy.
  5. In the left pane, open Local Policies.
  6. In the left pane, double-click User Rights Assignment.
  7. In the right pane, double-click the Lock Pages In Memory policy.
  8. In the Local Security Policy Setting dialog, click Add.
  9. Select the user ID and click Add.
  10. In the Local Security Policy Setting dialog, click OK.
  11. Restart the computer.
Parent topic: start_iq Server Options
Related concepts
Initial Catalog Store Cache Size when start_iq Server Option -c is not Specified
Database Server Naming Restrictions
AWE Cache Allocation
Related reference
start_iq Server Options
AWE Cache Sizes per Operating System