473,324 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Explain history

Does anybody have a tool to store/retrieve explained sql? We're running
DB2 8.2 on AIX. We would like to be able to compare old saved explains
to the current ones and see if anything changed.
Thanks,
Yuri
Feb 20 '06 #1
3 1732
The ncurrent expalin facility does that for you in the explain tables.
Look at the db2exfmt command and you can specify how to retrieve what you
need.
The first of the explain table EXPLAIN_INSTANCE has a primary key based on
timestamp so that the same package, section names can be kept by date.
Follows the PK on that table.
D:\SQLLIB\BIN>db2 describe table explain_instance

Column Type Type
name schema name
Length Scale Nulls
------------------------------ --------- ------------------
-------- ----- ------
EXPLAIN_REQUESTER SYSIBM VARCHAR 128 0
No
EXPLAIN_TIME SYSIBM TIMESTAMP 10 0
No
SOURCE_NAME SYSIBM VARCHAR 128 0
No
SOURCE_SCHEMA SYSIBM VARCHAR 128 0
No
SOURCE_VERSION SYSIBM VARCHAR 64 0
No

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Yuri" <yu**@prodigy.net> a écrit dans le message de news:
Uw***************@newssvr33.news.prodigy.com...
Does anybody have a tool to store/retrieve explained sql? We're running
DB2 8.2 on AIX. We would like to be able to compare old saved explains to
the current ones and see if anything changed.
Thanks,
Yuri


Feb 20 '06 #2
If you will, the same is available from the DB2 Control Center GUI as
Show Explained Statements History for a selected database (by right
click :-), but you have to create the explain tables in your schema
prior to using that tool anyways.

-Eugene

Feb 21 '06 #3
Eugene F wrote:
If you will, the same is available from the DB2 Control Center GUI as
Show Explained Statements History for a selected database (by right
click :-), but you have to create the explain tables in your schema
prior to using that tool anyways.

-Eugene

I understand that I can run db2exfmt. I wanted to find out if anybody
developed some system that would allow to look at old explain using some
kind of search mechanism. If access path for particular sql changed and
I need to compare the current access path with the old one I need to be
able to find it (for particular sql). Don't see how I can do it with
just explain_tables.
Yuri
Feb 21 '06 #4

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

Similar topics

15
by: Ashot | last post by:
This is sort of both Python and Vim related (which is why I've posted to both newsgroups). Python related: ---------------------- I have been frustrated for quite some time with a lack of a...
10
by: pmelanso | last post by:
Hello, How can I tell if there is a page to go back to in the history or not??? Same with forward??? say something like/// if (there is a page to go back to ) { // DO something }else { }
14
by: Ina Schmitz | last post by:
Hello all, I don't succeed in displaying the explain plan. I use IBM DB2 Universal Database 8.2. I tried to do the example given in the online help for "Visual Explain". The tables...
20
by: Dan | last post by:
Is there a way to obtain the last page visited? I don't want to go to that page, I just want to be able find out what page they came from, the url of that page. Is this possible?
4
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 ...
3
by: pentisia | last post by:
Hi there, We are using history.go(integer) to go back to the certain page directly. Because there are some pages interaction in between. For example, starting from page 1 to page 2. From page...
10
Ajm113
by: Ajm113 | last post by:
Making a History Page for BIG Sites Intro: Ok, let's say after a while your website has grown massive. We're talking search engine, forum and video hosting -- you've got a LOT of content. And you...
7
by: skaushik | last post by:
Hi all, I was working on a SQL query where a history table is joined with a small table to get some information. There is an index on the history table column but the explain plan tells that there...
2
by: Max | last post by:
I recently moved to ASPnet Ext 3.5 What I can't get with Ajax and History browser managemet is this: User fills some fields (dropdown and textbox) on page 1 (all are in an update panel) User...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.