By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,432 Members | 790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,432 IT Pros & Developers. It's quick & easy.

Cognos Cube and DB2 "UOW Waiting"

P: n/a
I'm trying 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.

Jul 24 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.