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)