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

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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