Default Cache Size Per isql Connection

Go Up to Configuring the Database Cache

To configure the number of cache pages for the duration of one isql connection, invoke isql with the following option:

isql -c n database_name

<n> is the number of cache pages to be used as the default for the session; <n> is trimmed to the database-specific cache setting if it is greater than that value.

A CONNECT statement entered in an isql query accepts the argument CACHE n. (Refer to the discussion of CONNECT in the Language Reference manual for a full description of the CONNECT function). For example:

isql> CONNECT database_name CACHE n;

The value <n> can be any positive integer number of database pages. If a database cache already exists in the server because of another attachment to the database, the cache size is increased only if <n> is greater than current cache size.