Topic
No replies
Deepak1216
Deepak1216
1 Post
ACCEPTED ANSWER

Pinned topic Memory Utilization Problem in DB2

‏2012-06-06T18:52:01Z |
Hi All,

I am running a query in db2 v9.7 in Linux-6 with 16gb memory and 4 cpus.
I waited for 15 min, still i did not get the output.
I am Copying the db2top screen shot of Bottlenecks when i tried to run that query.

Server Top Resource Resource Application
Resource Agent Usage Value Name
--
--------
----------------
=> Cpu 87 100.00% 83.290661 db2jcc_application
=> SessionCpu 87 99.66% 115.745154 db2jcc_application
=> IO r/w 87 100.00% 5,570 db2jcc_application
=> Memory 59 16.36% 1.1M Toad.exe
=> Locks 87 99.95% 1,979 db2jcc_application
=> Sorts 87 100.00% 982 db2jcc_application
=> Sort Time 87 100.00% 4,388 db2jcc_application
=> Log Used N/A 0% 0 N/A
=> Overflows 87 100.00% 3 db2jcc_application
=> RowsRead 87 100.00% 442,800 db2jcc_application
=> RowsWritten 87 100.00% 126 db2jcc_application
=> TQ r/w N/A 0% 0 N/A
=> MaxQueryCost 87 99.92% 1,321 db2jcc_application
=> XDAPages N/A 0% 0 N/A

Please suggest me , how to overcome this problem.