Bufferpools
Go Up to Supported Objects
Bufferpools are areas of system memory to cache table and index data pages. DBArtisan retrieves table and index data pages from their physical storage location and places them in the bufferpool so that when you modify or access data, you can retrieve the data from memory rather than a physical device or file. Bufferpools improve database system performance because DBArtisan can retrieve the data quickly from memory.
Creating and editing
- Bufferpools Wizard for IBM DB2 (DB2 LUW) and Bufferpool Editor (IBM DB2 LUW)
- Buffer Pools Editor (IBM DB2 Z/OS)
DBMS platform availability and object actions/operations supported
The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.
| DB2 LUW | DB2 z/OS | |
|---|---|---|
|
✓ |
✓ | |
|
✓ |
✓ | |
|
✓ |
✓ |