Re: STRDBMON

[jpcarr@xxxxxxxxxxxx]

Look into Ops Nav's   SQL Visual Explain.   It takes in the output from
DBMON

Look at the help text within Ops Nav

Here's a section of the text

---------------------------

An SQL Performance Monitor lets you keep track of the resources that SQL
statements use.  You can monitor specific resources or many resources.  The
information on resource use can help you determine whether your system and
your SQL statements are performing as they should, or whether they need
fine tuning.

What can I do in SQL Performance Monitors?

·    Create a summary SQL monitor
·    Delete an SQL monitor
·    End an SQL monitor

·    Analyze results for an SQL monitor
·    Import an SQL monitor
·    Create a detailed SQL monitor
·    Run a Visual Explain with detailed performance monitor data

·    Saving SQL monitor data

-----------------

Analyzing SQL performance monitor results

Once you have gathered resources using your performance monitor, you will
want to analyze the data that the monitor has collected.  If you are using
a Summary performance monitor, you will first need to Pause the monitor or
End the monitor.  A Detailed performance monitor can still be running.

1    In the Operations Navigator window, expand the system you want to use.
2    Expand Database.
3    Click SQL Performance Monitor.
4    Right-click on a performance monitor in the right pane, and select
Analyze Results.
----------------------------------------


John


---------------------------------
I am not sure how to read and understand the output of STRDBMON.   I am
trying to monitor the performance of the SQL but how do I read the file and
what should I interpret?  Is there a manual from where I can learn more
this.  I search IBM and only got some vague information.

TIA,
Sudha