MaxPackages
For Db2 and Db2 LUW, the MaxPackages parameter specifies the maximum number of additional packages that the High-speed Apply Engine can add to the base plan.
Attributes
This parameter has the following attributes:
Attribute | Value |
|---|---|
Section | [BindTuning] |
Abbreviation | None |
DBMS | Db2, Db2 LUW |
Required? | No |
Valid values | An integer from 0 to 9999 |
Default value | 25 |
Usage
Use this parameter to expand or limit the amount of static SQL that High-speed Apply Engine can bind and process. The PackageUsage, StatementCount, and StatementUsage parameters determine how many distinct statement types High-speed Apply Engine includes in a package. The MaxPackages parameter determines how many packages High-speed Apply Engine can bind.
Specify a number of packages. Take into consideration the number of distinct input statement types and how quickly you want High-speed Apply Engine to start processing statically rather than dynamically.
- If you set this parameter to zero, High-speed Apply Engine cannot process any static SQL. In general, the lower you set this parameter, the smaller the number of distinct statement types High-speed Apply Engine can process as static SQL (subject to the values of the PackageUsage, StatementCount, and StatementUsage parameters).
- When High-speed Apply Engine has bound the number of packages specified by MaxPackages, it stops binding static SQL. High-speed Apply Engine continues processing. If an input statement type has not already been bound, High-speed Apply Engine processes it using dynamic SQL (either with prepared statements or EXECUTE IMMEDIATE).
- If you set the PackageUsage, StatementCount, and StatementUsage parameters to lower values, High-speed Apply Engine will perform more bind actions more frequently, with fewer distinct statement types in each bind. In this situation, set the The MaxPackages parameter to a higher value to accommodate the higher number of bind actions.
- If your SQL input includes a template file generated by BMC AMI Log Master for Db2, High-speed Apply Engine can bind a package or packages for all distinct statement types at the beginning of the apply request. The packages that High-speed Apply Engine binds as it processes the template file count against the MaxPackages limit.
- For Db2, the DBRM library must be large enough to hold the DBRM members. High-speed Apply Engine will factor in the MaxPackages parameter if you use a temporary DBRM library. For more information about the use of temporary data sets, see Library.
Related topics