Setting QMF options for threads

You can change the impact that QMF has on the performance of Db2 by specifying certain options in QMF.

Procedure

To set QMF performance options:

Specify the following options:
  • The DSQSIROW parameter of the ISPSTART command
  • SPACE parameter of the user QMF profile (Q.PROFILES)
  • QMF region size and the spill file attributes
  • TRACE parameter of the user QMF profile (Q.PROFILES)