Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Using a database monitor

In my system, we have a huge database activity. When I run the WRKSYSSTS command, I can see my CPU percent with a high utilization. A big CPU percentage is coming from the database data. I run the database monitor, but what type of record do I have to look into for the job/database activity that is consuming my CPU?

I'd suggest looking for the 3000 and 3002 record types. You can find more education on using database monitor data here.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this Search400.com Featured Topic: Database issues resolved


Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close