Troubleshooting: Database performance did not change

Symptom

After running the Performance Configuration SmartGuide, the database performance is unchanged.

Possible cause

The database configuration parameters suggested by the Performance Configuration SmartGuide have not been applied to the database.

You have not issued a db2start command since the new parameters were applied to the database.

You did not rebind your packages.

Action

Issue the db2stop command and then the db2start command.

Rebind your packages.