MaxPackages

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 the 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 0, 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 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.
• 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.