Version 5
|
|
Version 5
|
You can now create multiple buffer pools of various sizes (number of pages) and assign table spaces to them using the CREATE BUFFERPOOL SQL statement. This provides the database administrator greater control of the data in memory. See the Administration Guide for details.
Extended storage provides a secondary level of storage for buffer pools. This allows a user to access memory beyond the maximum allowed for each process. Support now exists for very large physical memory (64-bit memory support). DB2 exploits 64-bit systems and 32-bit systems capable of supporting greater than 4 GB of real memory. See the Administration Guide for details.
 |
Version 5.2
|
DB2 Universal Database supports the storage of information on page sizes of 4 KB and 8 KB (see "Multiple Page Size Support"). In order to use the new 8K page size a buffer pool and attached table space with a page size of 8K must be created. See the CREATE BUFFERPOOL and CREATE TABLESPACE statements in the SQL Reference for details.
The DB2_FORCE_FCM_BP environment variable allows DB2 Extended Enterprise Edition for AIX customers to create their FCM buffers in a separate shared memory segment. This allows for faster communications (see "Multiple Logical Nodes").