I need to collect dynamic SQL execution times for a production
database. However, the totals are not being updated, despite setting
the DFT_MON_TIMESTA MP on. The DFT_MON_TIMESTA MP is listed in the V8
documentation as configurable online. However, after setting the
value on, the 'Total execution time' for dynamic SQL is still not
collected. I tried resetting the monitors, etc., but the only thing
that seemed to work is recycling DB2 (which is not an option for my
production environment). Is there anything else I can try, in order to
collect the snapshot information I want? Thanks.
Jennie
4  3957 
Colleciton of Several statement level elements is handled by the
statement switch...when you're doing your snapshots make sure that this
switch is on as well (db2 get monitor switches). Remember that switch
settings are configuratble per attachment, and can be adjusted to be
different than the default settings in the dbm cfg.
Jennie wrote: I need to collect dynamic SQL execution times for a production
database. However, the totals are not being updated, despite setting
the DFT_MON_TIMESTA MP on. The DFT_MON_TIMESTA MP is listed in the V8
documentation as configurable online. However, after setting the
value on, the 'Total execution time' for dynamic SQL is still not
collected. I tried resetting the monitors, etc., but the only thing
that seemed to work is recycling DB2 (which is not an option for my
production environment). Is there anything else I can try, in order to
collect the snapshot information I want? Thanks.
Jennie
Thanks, using the monitor switch does work. However, when the
dft_mon_stmt is set on, and then the dft_mon_timesta mp is subsequently
set to on, the totals are not available until after an instance
restart, it seems. Shouldn't the totals start accumulating without a
restart, since the dft_mon_timesta mp is configurable online?
Thanks again,
Jennie
Sean McKeough <mc******@nospa m.ibm.com> wrote in message news:<41******* *@news3.prserv. net>... Colleciton of Several statement level elements is handled by the
statement switch...when you're doing your snapshots make sure that this
switch is on as well (db2 get monitor switches). Remember that switch
settings are configuratble per attachment, and can be adjusted to be
different than the default settings in the dbm cfg.
Jennie wrote: Thanks, using the monitor switch does work. However, when the
dft_mon_stmt is set on, and then the dft_mon_timesta mp is subsequently
set to on, the totals are not available until after an instance
restart, it seems. Shouldn't the totals start accumulating without a
restart, since the dft_mon_timesta mp is configurable online?
You don't need to restart the instance -- this parameter change is
valid for any new instance attachments. So terminate your current
attachment ('db2 terminate') and the next DB2 commands you execute
will pick up the default values for the monitor switches.
DFT_MON_* just controls whether the monitor switches are enabled
whenever you attach. This is no different than attaching and issuing
'update monitor switches using ...'.
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Another point to note is that when you turn a switch on, all values are
set to 0...you start counting from the point of the switch being turned
on. (And remember that the switch will only be turned on for _that_
monitoring attachment...yo u must issue the snapshot commands from the
same attachment).
Ian wrote: Jennie wrote:
Thanks, using the monitor switch does work. However, when the
dft_mon_stmt is set on, and then the dft_mon_timesta mp is subsequently
set to on, the totals are not available until after an instance
restart, it seems. Shouldn't the totals start accumulating without a
restart, since the dft_mon_timesta mp is configurable online?
You don't need to restart the instance -- this parameter change is
valid for any new instance attachments. So terminate your current
attachment ('db2 terminate') and the next DB2 commands you execute
will pick up the default values for the monitor switches.
DFT_MON_* just controls whether the monitor switches are enabled
whenever you attach. This is no different than attaching and issuing
'update monitor switches using ...'.
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =----- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Lew |
last post by:
Hi,
I am a bit confused about what I'm seeing on my systems. I am
trying to develop a script that will determine what percentage of the
total log space is being used. If it is too high (80%) the on-call DBA
will be paged. First some system information:
get db cfg for ip0
First active log file =...
|
by: JDPope |
last post by:
I have a situation which I cannot get a good lead on how to resolve.
One of the applications I support uses the Hibernate software to
generate SQL. The app is JAVA with JDBC. In testing the users see no
problems and think the app is running okay. I turned a database
monitor on the app and see that the database is getting SQL return
coes of...
|
by: Ina Schmitz |
last post by:
Hello,
I would like to get the logical and physical reads for every sql statement
executed.
Thatfore, I used the command "db2 get snapshot for dynamic sql on
<mydatabase>". There, I could see the logical and physical reads from
bufferpool for every statement monitored. Am I right?
But now, I would like to read these results out of a table...
|
by: Nathan Bloomfield |
last post by:
Does anyone know if there is any documentation which relates to Access2k + ?
or can anyone help adjust the code?
I am having trouble converting the DAO references.
TITLE :INF: How to Create a Dynamic Crosstab Report
PRODUCT :Microsoft Access
PROD/VER:1.00 1.10
OPER/SYS:WINDOWS
|
by: mike |
last post by:
Problem: the snapshot output for dynamic SQL shows some SELECT
statements executed many times but all three CPU counters
(total/system/user) in the dynamic-sql-snapshot are zero,
but most other SQL statements are correctly timed.
Environment: DB2 v7.2 fp13 on AIX all 32-bit.
At this site, a script executes once an hour
which enables...
| | |
by: jefftyzzer |
last post by:
Colleagues,
Consider the following snippets of a snapshot:
Number of executions = 13
Number of compilations = 4294967295
Rows read = 415532
Buffer pool data logical reads = 13741
Buffer pool data physical reads = 0
Buffer pool temporary data logical reads = 0
|
by: grant |
last post by:
Hi
I've copied Stephens code into my db, and can get it to work, but only
on "plain Jane" reports with no images.
Most of my reports has an unbound image obluect in them that I set to
an external image file using on_open code
I've searched through this group and there are a few comments about
snapshots not working with embedded images,...
|
by: %NAME% |
last post by:
Hi,
When collecting snapshot, there is seemingly discrepency between query
running time and some metrics collected.
For example, on a DPF with 8 nodes, I have 8863201 seconds for
"Total buffer pool read time (milliseconds)" from running "db2 get
snapshot for all on bcudb global"
Then without the "global" option, on each node, there...
|
by: aj |
last post by:
DB2 LUW 8.1 FP14
RedHat AS
In "db2 get snapshot for dynamic sql" output I see (amongst other
things):
Number of executions = 235
Number of compilations = 1
Worst preparation time (ms) = 4
Best preparation time (ms) = 4
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
