Minor changes are by default collapsed in the page history.
No changes
The page does not exist yet.
Failed to load changes
Version by on
Leave Collaboration
Are you sure you want to leave the realtime collaboration and continue editing alone? The changes you save while editing alone will lead to merge conflicts with the changes auto-saved by the realtime editing session.
Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.
Explaining and Comparing dynamic SQL from trace data sets
The PSSEXTRC function of
SQL Performance for DB2
can help you to analyze dynamic SQL from
Apptune
archive trace data sets.
Specifically, the PSSEXTRC function uses BMC IFCID 005 records. This function is useful when you plan to migrate to a different version of Db2 and want to find out how your existing data will perform, or when you want to Explain and Compare the access paths for dynamic SQL from subsystems running on different versions of Db2.
The Workload Access Path Compare Component provides an automated process to perform these functions. For more information, see Comparing-access-paths-for-workloads.
