Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Implementing Siebel Business Applications on DB2 UDB for z/OS > Maintenance Considerations for z/OS > Enabling DB2 Dynamic Statement Caching > About Managing the Dynamic Statement CacheBecause DB2 uses the Environmental Descriptor Manager (EDM) component to manage the dynamic statement cache, it is important that you set EDM-related system parameters to appropriate values. Prior to DB2 for z/OS V8, the cached SQL statements were stored in either the primary EDM Pool, or in a data space. In DB2 for z/OS V8, the cached SQL statements are always stored in a dedicated area above the 2 GB bar. For guidance on setting the EDM system parameters, see your IBM documentation. NOTE: Monitor and adjust the EDM Pool and the related cache storage areas based on your workload. System parameters associated with dynamic statement caching are described in Table 14.
|
![]() |
![]() ![]() |
Implementing Siebel Business Applications on DB2 UDB for z/OS | Copyright © 2008, Oracle. All rights reserved. | |