The difference between SANLDATA and SANLPARM

The Db2 SQL Performance Analyzer ISPF interface is intended to use the hiqual.SANLPARM library for its parameter values, leaving the hiqual.SANLDATA library available for different values that can be used for the batch interface.

Either interface can specify the members from either library. However, there are certain parameter values that are only valid for batch use and are ignored when using ISPF.

When setting up the Db2 SQL Performance Analyzer stored procedure, a copy of the SANLPARM member ssidCNTL is recommended. The copy can be allocated to the stored procedure address space so that it does not prevent other users from accessing those parameters.