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.

Note

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:

Related topic

Using the Index Component

 

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