473,651 Members | 2,716 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Snapshot problem for dynamic-sql: zero cpu counters

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 STATEMENT monitor switches, resets
the counters, sleeps for a while and
then performs db2 get snapshot for all on...
One frequently executed SELECT statement always
reports exactly zero for the Total Execution time/System Time/CPU Time,
and that is the only such statement in the snapshot (all other SQL
statements will show non-zero counters for the same elements).

The specific SQL statement is a SELECT statement
that usually returns a small number of rows (e.g. 0, 1 or less than a
dozen or so rows in the result-set).
The access-plan looks good, no scanning, correctly indexed.
The query has run almost a million times over the past few months.

The specific SQL statement is the first statement in a multi-statement
distributed transaction (j2ee/jta/WAS4).

Anyone know why DB2 dynamic-sql snapshot can have
zero values for some SQL statements but not others ?

Nov 7 '06 #1
0 1589

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
1703
by: Tejas | last post by:
Hi, I have gone through the snapshot API. I need to use it for finding location of database files, tablespace containers etc on a remote machine. These parameters are present in the response. However, for getting only some paramters, I get a huge response, with many parameters that I do not need (mostly many are performance parameters). How long can the snapshot response be, and can it considerably affect performance?
7
14358
by: Pat | last post by:
I would like to send the Print Preview of a MS Access form to a Snapshot file. The form contains an OLE graph. BACKGROUND A snapshot of a report is possible. If I could I would use a report to display the graph but it is not possible to send query parameters to an OLE graph on a report (or programatically change any properties of an OLE Graph). However with a Form you do have the ability to change the RowSource of
0
1594
by: Soly | last post by:
I would like to use automation to print a snapshot file from an snapshot viewer ActiveX control using the PrintSnapshot method. The argument for this method is True/False to show/hide the Print dialog box. When i hide the dialog box (False), the snapshot is always printed in Portrait, because that is the default settings for my printer, even though the snapshot is landscape. How do I get past this so the snapshot is printed as it...
5
3465
by: tom | last post by:
Hey All- I've exported a report to Access's "snapshot" format and want to put it on a website for users to view. However, when I click on the link to the snapshot file, I notice that my browser (IE6) attempts to open it as if it were a regular html page, thereby displaying a bunch of gobbledygook. Any ideas on what has to be tweeked (in the link/on the website or server) to make the browser know it should either (a) try to launch...
2
1580
by: @ndy | last post by:
When i save my rapport as a snapshot it only saves the helft of the page. I have no idee why this happens. Have somebody allreadt has this problem.
1
1616
by: IkyL234 | last post by:
I have a macro that simply runs a query which produces a report and then attaches it as an email attachment - in a snapshot file format. However, when i send the email, the recipient cannot open the snapshot file. The macro function is the Output one. I have tried to change the output file to a rich text format which is ok as the recipient can naturally open it as a Word document - but the problem is the formating of the document in...
4
2597
by: Salad | last post by:
Hi: I have the following line: DoCmd.SendObject acSendReport, "TestReport", _ "SnapshotFormat (*.snp)", _ "joeblow@nowhere.com", , , "Report Test", _ "Does it open correctly?", True I have a report called TestReport. I dropped an image control in the report, and imported a .BMP file into it as the report's background, and sent it to back. I then dropped my fields on top of the image.
3
2047
by: Steven Thomas | last post by:
I am working on a ASP.NET application using VB.NET. I have a function that creates a snapshot file on a separate server and passes a path back to the webpage. Now I want to display the snapshot. If I cut and paste the path into the browser it opens snapshot viewer. Exactly what I want. However, if I response.redirect to the path, I get a error that the file can not be found. If I response.redirect to "file:"+path It opens the snapshot...
1
2884
by: shenanwei | last post by:
I have db2 v8.2.5 on AIX V5.3 with all the switches on Buffer pool (DFT_MON_BUFPOOL) = ON Lock (DFT_MON_LOCK) = ON Sort (DFT_MON_SORT) = ON Statement (DFT_MON_STMT) = ON Table (DFT_MON_TABLE) = ON Timestamp (DFT_MON_TIMESTAMP) = ON Unit of work ...
8
5472
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, and my testing seems to
0
8352
marktang
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8802
Oralloy
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8465
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 most users, this new feature is actually very convenient. If you want to control the update process,...
1
6158
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5612
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4144
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4283
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2699
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1587
bsmnconsultancy
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.