Dropping a Memory Pool

To completely remove a pool, set its size to 0.

This example removes the 16K pool and places all space in the default pool:

sp_poolconfig "default data cache", "0", "16K"

Cache Name               Status    Type     Config Value Run Value
------------------------ --------- -------- ------------ ------------
default data cache       Active    Default      25.00 Mb     29.28 Mb
                                            ------------ ------------
                                     Total      25.00 Mb     29.28 Mb
=======================================================================
Cache: default data cache,   Status: Active,   Type: Default
     Config Size: 25.00 Mb,   Run Size: 29.28 Mb
     Config Replacement: strict LRU,   Run Replacement: strict LRU
     Config Partition:            1,   Run Partition:            1

IO Size  Wash Size Config Size  Run Size     APF Percent
-------- --------- ------------ ------------ -----------
    2 Kb   3844 Kb      6.50 Mb     25.28 Mb     10
    4 Kb    512 Kb      4.00 Mb      4.00 Mb     10

If you do not specify the affected pool size (16K in the example above), all the space is placed in the default pool. You cannot delete the default pool in any cache.

When Pools Cannot Be Dropped Due to Page Use
If the pool you are trying to delete contains pages that are in use, or pages that have dirty reads, but are not written to disk, SAP ASE moves as many pages as possible to the specified pool and prints an informational message telling you the size of the remaining pool.

Parent topic: Configuring Data Caches