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.

Related topic

Using the Index Component


Important

You can use this process only in batch mode.

The Workload Access Path Compare Component provides an automated process to perform these functions. For more information, see Comparing-access-paths-for-workloads.

 This section contains the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*