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.
Articles tagged #performance — 4 results
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.
Seeing which jobs use the most CPU
What WRKACTJOB shows on screen, but queryable and sortable.
The indexes the system suggests, and which to create
Db2 for i records which indexes it would have wanted, one query at a time. Creating them all is the quickest way to slow the database down.