After some time you work with IBM Workload Scheduler it could happen that you observe some slight performance degradation while accessing data on the database.
This is normal and due to the continuous update of the Workload Scheduler objects definition.
To be sure to anticipate and prevent performance issues accessing to the DB2 data of the IBM Workload Scheduler product, I suggest to you to regularly follow some simple actions.
After a massive data change, for example a data import or updates:
- Make sure to collect the database statistics on all columns and indexes
- You can also to physically and logically reorganize your tables and indexes of the database
The IBM Workload Scheduler provides you the scripts that allow you to accomplish these actions.
In the <TWS_HOME>/dbtools/db2/scripts folder, you can find the scripts:
- dbrunstats.sh (bat)
- dbreorg.sh (bat)
which will help you to improve performance on your IBM Workload Scheduler database.
You can also create an IBM Workload Scheduler job that runs these scripts as scheduled or submit them ad hoc when you need.
To get more details about these scripts, see the IBM Workload Scheduler Administration Guide -> Data Maintenance -> Administrative tasks - DB2 -> Administering the DB2 maintenance feature