I'm try tuning a SELECT statement which is used by a Cognos cube on a
DB2 V7.2 +FP13. After I did the tuning, the "dynexpln" shows the
"total cost" is down to 8214567 from 37345265, also I try to run the
SQL in the cmd line, it now only took several minutes to return about
50M rows instead of +10 hours.
The cube is re-built after the tuning, and I could see the same SQL
running by "get snapshot for application.." , also the "list
application" shows that it is in "executing" status; after a short
while, the status changed to "UOW waiting" status. Sevral hours
passed, the SQL is still in "UOW waiting" status, and the "rows
read/fetched" from "get snapshot" is keeping growth continiously.
I'm confused, what does the "UOW waiting" really means, maybe just
waiting for the Cognos processing the data? Why the "rows
read/fetched" is growing?
Anyone can explain this? Thanks.