MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2012

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



fixed

The system always captures information on all SQL queries in the SQL Plan
cache
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/rzajq/rzajqdisplayplancache.htm
http://www-03.ibm.com/systems/resources/systems_i_software_db2_PlanCache_Basics.pdf

The plan cache can help you identify problem areas for which you can use
the DB monitor tools to dig into more deeply
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/rzajq/queryopt.htm

I am not aware of any differences between SQE and CQE with respect to the
functionality of the DB tools.

HTH,
Charles



On Sat, Dec 1, 2012 at 12:22 PM, Jack Kingsley <iseriesflorida@xxxxxxxxx>wrote:

Is SQL overhead measured in the performance tools or must you use pex and
or the sql components to setup various versions of monitors and such using
iseries access to gather and report on what is taking place on your system.

What is an easy way to drill down to jobs that are using sql on your
system, I have a tool called wrkodbcjob that somewhat gets you your
odbc/jdbc jobs etc.

Using netstat, how can you quickly determine which jobs are using sql and
by what ports, another words how many jobs/users are currently performing
some sort of sql on my box.

Created a new file as a clob, that has ended up clobbering my system cpu,
anyone seen anything like this, all versions of i5/os and it makes no
difference.

If your designing applications using client side sql and or embedded sql
what are the performance metrics that should be used to determine that
various amount of remote clients and systems performing various types of
sql against your database should be allowed, is this a
model/cpw/memory/processor type situation that could effect this.

I have been reading the sqe vs the cqe information and it seems that most
of what I have going on is sqe based.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.







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