Tuning the package cache (pckcachesz).
调优包缓存器(pckcachesz)。
Catalog cache, package cache, and log buffer.
目录缓存器、包缓存器和日志缓冲区。
M - Section is obtained from the in-memory package cache.
M—片段是从内存中的包缓存获得的。
Examining frequently used SQL statements from the package cache.
检查来自包缓存的常用sql语句。
The package cache hit ratio can be calculated using the following formula.
可使用下列公式计算包缓存器的命中率。
When the statement is compiled, its access plan is stored in the package cache.
在编译语句时，语句的访问计划被存储在包缓存中。
Package and catalog caches, and workspaces (for example, package cache hit ratio)
包与目录缓存，以及工作空间（如包高速缓冲区命中率）。
Therefore, the sizes for package cache and catalog can vary depending on the value of maxappls.
因此，包缓存和编目的大小可以随着 maxappls的值而变化。
Set the catalog cache, package cache, and log buffer size to an appropriate size to improve performance.
要设置大小适当的目录缓存器、包缓存器和日志缓冲区以提高性能。
Identify problems with memory, including low buffer pool hit ratios, catalog cache hit ratios, and package cache hit ratios.
识别内存问题，包括较低的缓冲池命中率、较低的目录缓存命中率和较低的包缓存命中率。
The package cache sets the amount of database global memory to be used for caching a package's static and dynamic SQL statements.
包缓存器设置数据库全局内存的总量以用于缓存程序包的静态和动态sql语句。
If the same INSERT statement is executed repeatedly, its access plan will (usually) be found in the package cache and the compilation cost is avoided.
如果重复地执行相同的insert语句，则该语句的访问计划(通常)会进入到包缓存中，这样就免除了编译的开销。
The DB2 optimizer stores the access plan created in the prepare phase in the SQL statement cache (also called package cache in DB2) for reuse purposes.
DB 2优化器将准备阶段中创建的访问计划存储在sql语句缓存(在DB 2中也称为包缓存)中以便重用。
You can also run a report based on the recently executed queries that still reside in the package cache using the following form of the db2advis utility.
还可以使用如下形式的db2advis实用工具基于尚处于包缓存中的最新执行的查询运行一个报告。
Use the FLUSH package command to remove all cached dynamic SQL statements currently in the package cache and force the next request to be implicitly compiled.
使用FLUSHPACKAGE命令来删除包缓存器中当前所有缓存的动态sql语句，并强制隐式地编译下一请求。
Package cache (controlled by the pckcachesz configuration parameter).
包缓存(由pckcachesz配置参数控制)。
Package Cache - Memory allocated to store both static and dynamic SQL statements.
包缓存——为存储静态和动态sql语句而分配的内存。
Package Cache - Memory allocated to store both static and dynamic SQL statements.
包缓存——为存储静态和动态sql语句而分配的内存。
应用推荐