For static SQL in a package (like SQL stored procedures), use of parameter markers while still allowing optimization by value can be accomplished through the REOPT ALWAYS bind or precompile options.
对于一个包中的静态SQL(比如s QL存储过程),通过REOPT ALWAYS绑定或预编译选项,可以使用参数标记同时允许通过值进行优化。
Without design mode enabled you can still make copies of existing perspectives and change them in your Custom perspectives package.
在没有启用设计模式的情况下,您仍然可以对现有透视图进行复制,并在您的Custom perspectives包中更改它们。
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实用工具基于尚处于包缓存中的最新执行的查询运行一个报告。
应用推荐