|
|
|
The environmental descriptor manager (EDM) pool functions as a system buffer pool and is the main memory area of DB2. It minimizes I/O against the DB2 directory (DSNDB01) and catalog (DSNDB06). It is also used by dynamic SQL processing.
In addition to increased directory and catalog I/O, an insufficient EDM pool increases PREPARE activity for dynamic SQL, and may limit concurrent thread usage. Specify the biggest EDM pool you can afford.
| Copyright © 2012 CA. All rights reserved. |
|