Page 1 of 1

DB2 batch SELECT taking too long

Posted: Sat Aug 01, 2026 1:30 pm
by Aakash Kochar
I have a situation in which A report SELECT keeps escalating CPU. How do you profile COBOL+DB2 queries—EXPLAIN, RUNSTATS, indexes—what’s your go‑to sequence? Thanks in advance for any pointers.