Running SQL PA using the ISPF interface

Db2 SQL Performance Analyzer can run interactively under TSO using standard ISPF panels.

This option allows you to work through several scenarios online, saving and reviewing previous results, while evaluating a number of alternatives and their costs. SQL PA provides the same level of information online under TSO that is generated by a batch run. When SQL PA is run online, you can reset key parameters on the panel and re-evaluate SQL dynamically. You can also choose from among the target host systems defined by your installation, applying the SQL PA costing against various configurations which might be encountered in production.