Troubleshooting: Locating the Performance SmartGuide log file

Symptom

You need to send your service representative a copy of the Performance Configuration SmartGuide log file.

Possible cause

The parameter values suggested by the Performance Configuration SmartGuide have not had the intended effect.

Action

Make a copy of the file confperf.prf stored in the DB2PATH path.

Send the contents of the file by e-mail, fax, or mailed diskette to your service representative.
Note:DB2PATH is an environment variable.

For example, if DB2PATH=X:\SQLLIB, the file will be found in the following location: X:\SQLLIB\confperf.prf.