473,659 Members | 3,082 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Explain of update-statement without commit

Hi,

the following sequence:

set current explain mode yes;
set current explain snapshot yes;

update ...;

set current explain mode no;
set current explain snapshot no;

rollback;

Will result in that the explain tables are not written (rolled back).

Is there a way to explain an update statement without commit?

BTW: It is not an option to just use "explain mode explain", because
I'm creating temporary tables, so I have to set "explain yes".
Nov 18 '08 #1
1 3573
I use the db2expln facility for generating the plan without executing
it Try here:
http://publib.boulder.ibm.com/infoce...c/r0005736.htm
On Nov 18, 7:31*am, w.l.fisc...@goo glemail.com wrote:
Hi,

the following sequence:

set current explain mode yes;
set current explain snapshot yes;

update ...;

set current explain mode no;
set current explain snapshot no;

rollback;

Will result in that the explain tables are not written (rolled back).

Is there a way to explain an update statement without commit?

BTW: It is not an option to just use "explain mode explain", because
I'm creating temporary tables, so I have to set "explain yes".
Nov 18 '08 #2

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

Similar topics

5
3599
by: KathyB | last post by:
If someone could just explain this to me...I just don't get it! I have an aspx page where I retrieve several session variables and use xmlDocument to transform xml file with xsl file into an instruction document (not data based) - same as using an xml web control. The resulting html is on the client? but what about the server side of things? Trying to figure out how to change and save the xmlDocument. It I put a button OUTSIDE of the...
3
2069
by: Bruce Pullen | last post by:
DB2 UDB 7.2 on AIX5.2 I'm running (VISUAL) EXPLAIN from DB2 Control Center on various SQL statements, but am restricted to using unrealistically small data volumes. I've heard that it is possible to kid the EXPLAIN into thinking it's dealing with much larger data volumes. Assuming that this would be productive, can anyone tell me how I can do this? Many thanks Bruce.
2
1368
by: Bob | last post by:
I am adding managed code to a project that I created under Visual 7.0 C++ because I want to utilize parts of the framework. The project runs fine when I am under Visual 7.0 and the Managed Code extensions are turned off. When I turn them off, one of my views terminates on the "UpdateData" call for the dialog. In the past when I have had this it was generally do to a resource problem and I was able to track it down on the data exchange side or...
4
2094
by: manochavishal | last post by:
Why would a signal handler cannot in general call standard library functions. I have read whats is said in Standard but needs an explaination on that as i couldn't uunderstand it. Thanx in advance
3
1398
by: Chris H | last post by:
I have been looking through this script and came across something that I dont quite understand how it functions or is used. Basically its brackets that are added on at the end of a form field value. EXAMPLE: <input name="eid" type="hidden" id="eid" value="<? echo $ses_id; ?>"> in other words what does the brackets pass to the function thats processing the form, basically how is the used.
2
1496
by: heming_g | last post by:
two tables with the same table structure : tb_xxx and tb_xxx_tmp in table tb_xxx , column "listno" is the primary key of itself and foreign key of dozen of tables . here is my sql .. " update tb_xxx set ( listno ) = (select listno from tb_xxx_tmp where listno = 11 ) where listno = 11 " the explain result (use db2expln ) is amazing ... about a thousand lines !!!! ,refering all of the dozen of tables . but when i try
11
1803
by: Faisal Vali | last post by:
Hi - I'm new to javascript and I was reading the book Javascript Professional Projects - there is a fragment that has me a little perplexed, and I was wondering if anyone could explain why and how it works. How is it that setting a property to null alters another property? For example setting optionObject.options = null; seems to set optionObject.selectedIndex to -1 automagically. Can you attach "hooks" in javascript that get called...
4
1704
by: Bruno Alexandre | last post by:
Hi guys, I'm using the asp:menu component and everything worked great in my machine, but when I upload the files to our Hosting I got this: http://portal.filterqueen.dk/portal2.fq/test.aspx please see the in IE and Firefox... can anyone tell me why in FF I don't get the CSS to work?
5
8095
by: kabotnet | last post by:
Hi, I'm new in db2, I'm trying to execute EXPLAIN command on some queries but i have error like: And message similar to: Token EXPLAIN is not valid, valid tokens ( END GET SET CALL DROP FREE HOLD LOCK OPEN WITH ALTER. I've created tables explain_* How can I start to find solution? Is it possible that my db2 doesn't support explain?
3
1146
by: Angus | last post by:
Wondering how this code worked I have a base class called eg MyBase. It has a private member called myprivatemember which is of course not accessible from users of the class. But I suddenly need to update the variable myprivate and I am not allowed to edit the original source code so I create a new class, MyNewToAllowChange which implements a public function called SetMyPrivate which allows me to change the variable.
0
8428
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
8747
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8528
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,...
0
8627
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7356
agi2029
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5649
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
4335
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2752
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
1737
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.