Data Caches Wizard (Sybase ASE)

From DBArtisan
Jump to: navigation, search

Go Up to Sybase ASE Object Wizards

This wizard lets you build and submit an sp_cacheconfig call, creating a new data cache. One or more sp_bindcache calls can also be built and submitted simultaneously, letting you bind databases, tables, indexes, text object, or image object to the new data cache. For each object bound, you can specify sp_cachestrategy parameters, letting you select caching strategies for those objects.

To create a new data cache using a wizard

  1. Open an object creation wizard for a data cache. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

On creating a data cache, all space is allocated to the logical page size memory pool. You can subsequently use the Data Cache Editor to subdivide the data cache into additional pools with larger I/O sizes. For details, see Data Cache Editor (Sybase ASE).

Data Caches (Sybase ASE) - Properties

When creating or editing a data cache, this tab/panel lets you work with settings corresponding to sp_cacheconfig parameters:

Category Setting Description



Lets you provide a name for the cache.



Lets you specify a cache type parameter value of MIXED, INMEMORY, or LOGONLY. The In-memory databases feature is available as of Sybase ASE 15.5.

Policy (not available with a Type of INMEMORY)

Lets you specify a replacement policy of STRICT or RELAXED.


Displays the current status of the cache: ACTIVE, PENDING ACTIVE, or PENDING DELETE. You can only change a mixed data cache if it does not have any non-log objects bound to it.


Lets you specify the number of partitions to be created for the cache. Selecting a legal value (1 - 64, in powers of 2) adds that sp_cacheconfig cache_partition parameter value to the DDL generated to create the data cache.


Configured Size

Lets you specify the size of the cache after the server is restarted. Consult Sybase documentation for details on this property. See Accessing Third Party Documentation.

Run Size

Displays the size that the cache is currently using. For the default cache, this is the amount of all cache space not explicitly configured for another cache

Data Caches (Sybase ASE) - Objects

When creating or editing a data cache, this tab/panel lets you manage the objects bound to the data cache. You use it to bind and unbind objects and to specify the caching strategy for each bound object.

The Objects list on the left displays objects currently bound to the data cache. Specific objects are grouped under the Databases, Tables, and Index subfolders.

The Property/Value list on the right lets you work with caching strategy parameters for a selected table or index. Consult Sybase documentation for information on the Apply to text only (applies to indexes only), Prefetch Strategy, and MRU Replacement Strategy caching strategies. See Accessing Third Party Documentation.

Maintain the Objects list as follows:

  • Adding a new database, table, or index to the bound objects list - click the Bind button. This opens a Bind wizard. For detailed information, see Binding Databases, Indexes, or Tables to a Sybase ASE Data Cache. Use this process repeatedly to bind objects of different types.
  • Enabling or disabling caching strategy options for an object - select an object from the Objects list and use the check box associated with a strategy to enable or disable that strategy.
  • Removing an object from the bound objects list - select the object in the Objects list and click Unbind.

Binding Databases, Indexes, or Tables to a Sybase ASE Data Cache

When creating or editing a data cache, the Bind Wizard lets you select the specific objects that are to be bound to the cache.

To bind one or more databases, tables or indexes to a data cache

  1. Open the Data Cache Wizard or Data Cache Editor and select the Objects tab. For more information, see Data Caches Wizard (DBArtisan - Sybase ASE) or Data Cache Editor (Sybase ASE).
  2. Click Bind to open the Bind Wizard.
  3. From the Objects dropdown select Entire Database, Tables, or Indexes.
  4. If you selected Tables, or Indexes, from the Databases dropdown select the database containing the specific table or index.
  5. If you selected Tables, optionally select the Bind text or image from table objects check box to bind storage of text and images from the table to this cache.
  6. Click Objects in the navigation frame to display the Objects panel.
  7. Select the check box associated with each specific object that is to be bound to the cache.
  8. Click Finish.