The parameters that control memory consumption by the database server are divided into two areas, the bufferpool and the SQLPool. The bufferpool contains pages that hold actual database data and various control information about databanks, tables, and transactions in the system.

The SQLPool contains information about users logged into the database system, compiled SQL statements and procedures, and so on. The SQLPool will automatically allocate additional space if needed. The upper limit for this, is the amount of paging file allocated on the machine or the amount of memory a single process may allocate. It is possible to restrict the amount of memory consumed by the database server by specifying a maximum size for these areas.

• Bufferpool parameters
• SQLpool parameters