Planning for performance of Db2

When you install or migrate Db2, consider your performance goals for your subsystem or data sharing member. Use z/OS® Workload Manager (WLM) to define these goals.

Also, consider the following guidance:

• Monitoring and managing performance are more difficult with few plans.
• Never-ending threads and plans reuse accumulate thread storage and working storage.
• Each distributed COMMIT statement needs package accounting.
• Consider reusing threads.
• Finding unused packages and cleaning up mistakes are difficult unless ownership is known.
• Performance monitoring may require analyzing everything in a CICS® region instead of just one plan.
• Plan is a required short name.
• Package name is optional, long, multipart, and not always easy to find.
• Consider differentiating by plan within a CICS region and having at least 5 to 20 plans within a region. You can work faster and make changes on a more granular basis.
• Eligible processes can be offloaded to IBM® z Integrated Information Processor (zIIP) specialty engines to reduce the load on general purpose processors.