Finding the indexes the system suggests
Db2 for i records which indexes it would have wanted: you only have to ask.
Articles tagged #performance — 4 results
Seeing which jobs use the most CPU
What WRKACTJOB shows on screen, but queryable and sortable.
Monitoring performance with WRKSYSSTS
A screen full of numbers of which, usually, only two get read. Which ones actually help, how to read them, and what to do when they say something is wrong.
Optimizing SQL Queries on DB2 for i
When a query slows down, the cause is almost always a missing index or a condition written in a way the database cannot use. Here is how to find out instead of guessing.