MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2012

Re: SQL db2 usage/overhead on your system questions.



fixed

Dieter

I don't believe that the database monitor records any activity for RLA - I'd love to know that this has changed. But all seems focused on SQL. I could easily have msised this, but here's some info from the documentation.

From the 7.1 "Database and query optimization" manual, this statement -

The database monitor provides the same information that is provided with the query optimizer debug messages (Start Debug (STRDBG)) and the Print SQL information (PRTSQLINF) command.

And this statement -

The STRDBMON command allows you to collect statistic records for a specific set or subset of the queries running on any job.

The collection does include both CQE and SQE - perhaps that is what you are thinking about. These are easily distinguished in Navigator;s Visual Explain in the details on the right.

Reading the output of the monitor yourself is possible, albeit fairly difficult at first glance - several columns are heavily overloaded, with different data based on a record ID code - there are several helpful SQL views listed in that same manual that can help with this analysis.

But Visual Explain is the better option, very nicely presented and all.


On 12/2/2012 1:12 AM, D*B wrote:
most important is the database monitor (STRDBMON with all details). To analyze the results, you would have to use Ooops Nerv. This will show up all informations about all SQL workload you did run the monitor.
SQL running from clients (ODBC, JDBC, ADO, DRDA and SQLCLI in server mode), you will see the serverjobs QZDASOINIT and one of the QPWxxx Jobs.
Local access to the database via embedded SQL STRSQL, QMQRY are hard to seperate from RLA accessat the first glance.

D*B






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact