472,805 Members | 1,008 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

visual explain

Since upgrading to db2 8.2.1 I've been having odd problems with visual
explain:

1. tables appear to require schema prefixes:
[IBM][CLI Driver][DB2/AIX64] SQL0204N "BUCK.DIM_SENSOR"
is an undefined name. SQLSTATE=42704

I had already set the schema to dw - where queries can find
dw.dim_sensor

Now, this isn't a killer - I can always modify the sql before
explaining it - but it seems like an unnecessary further PITA.
2. DBA3065E Snapshot cannot be processed due to a CLI error.
Explanation:
A CLI error has occurred during snapshot processing. An
access plan cannot be displayed.

DBA3037E The explain snapshot has been corrupted. Your request
cannot be completed.
Explanation: The explain snapshot that is requested has been
corrupted in the explain tables.

Ok, no idea how to handle this one. So, I guess I just won't be
using this tool to get an explain on this query. And if this
happens more than every now & then - I've got ZERO chance on
getting the developers to use it.

You know, there are quite a few different new bells & whistles being
added to db2 these days. Some of them are really terrific. But why
can't we make sure the basic components are nearly bulletproof before
adding new gewgaws?

And no, I'm really not interested in calling support unless absolutely
necessary - I expect this kind of thing to work perfectly out of the
box, and don't appreciate having to waste my time on the phone to
fiddle with the product to get it to work. At a certain point support
lines become crutches to allow vendors to release an inferior product,
and get it fixed in the field.

So, is there a simple fix? Do I have to ugrade to v8.2.2?

buck

Nov 12 '05 #1
2 3836
"Buck Nuggets" <bu*********@yahoo.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Since upgrading to db2 8.2.1 I've been having odd problems with visual
explain:

1. tables appear to require schema prefixes:
[IBM][CLI Driver][DB2/AIX64] SQL0204N "BUCK.DIM_SENSOR"
is an undefined name. SQLSTATE=42704

I had already set the schema to dw - where queries can find
dw.dim_sensor

Now, this isn't a killer - I can always modify the sql before
explaining it - but it seems like an unnecessary further PITA.
2. DBA3065E Snapshot cannot be processed due to a CLI error.
Explanation:
A CLI error has occurred during snapshot processing. An
access plan cannot be displayed.

DBA3037E The explain snapshot has been corrupted. Your request
cannot be completed.
Explanation: The explain snapshot that is requested has been
corrupted in the explain tables.

Ok, no idea how to handle this one. So, I guess I just won't be
using this tool to get an explain on this query. And if this
happens more than every now & then - I've got ZERO chance on
getting the developers to use it.

You know, there are quite a few different new bells & whistles being
added to db2 these days. Some of them are really terrific. But why
can't we make sure the basic components are nearly bulletproof before
adding new gewgaws?

And no, I'm really not interested in calling support unless absolutely
necessary - I expect this kind of thing to work perfectly out of the
box, and don't appreciate having to waste my time on the phone to
fiddle with the product to get it to work. At a certain point support
lines become crutches to allow vendors to release an inferior product,
and get it fixed in the field.

So, is there a simple fix? Do I have to ugrade to v8.2.2?

buck

You should upgrade to FP10 before you do anything else. Also, make sure you
upgrade your databases with db2updv8 (see Command Reference) after applying
the FP and upgrading the instances. This procedure is not included in the
earlier FP readme installation instructions (erroniously), but is for FP10.
Nov 12 '05 #2
Mark A wrote:
You should upgrade to FP10 before you do anything else. Also, make sure you
upgrade your databases with db2updv8 (see Command Reference) after applying
the FP and upgrading the instances. This procedure is not included in the
earlier FP readme installation instructions (erroniously), but is for FP10.


Thanks Mark.

I just reviewed the apars for this fp and see that FP10 will fix the
visual explain problem with merges and comments. I hadn't gotten to
the problem with unions yet. But it doesn't list the problem with
requiring schema prefixes.

Still, it looks like a lot of code was cleaned up, so maybe they've got
both of these problems fixed.

Buck

Nov 12 '05 #3

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

Similar topics

1
by: Ranganath M V | last post by:
Hi, How do i get an explain report of a UDB DB2 stored procedure. DB2 is installed on Unix Currently i am copying each SQL in my stored procedure on to the comman cneter and geting the visual...
1
by: bruce_milner | last post by:
I am having a problem using DB2 for z/OS Visual Explain V8 for Windows. The error message is: Fail to load JDBC driver COM.ibm.db2.jdbc.app.DB2Driver I have un-installed/re-installed DB...
0
by: juliane26 | last post by:
Being new on z/OS for some time I do have some problems with Explain. I tried the Visual Explain for z/OS, but since we use Version 7 database I can't even see the join predicates or any cost...
10
by: Jeff Boes | last post by:
I'm hoping there's someone here with experience in building the Visual Explain tool from Red Hat. I downloaded it and the J2 SDK, but when I attempt to follow the build instructions, I get messages...
0
by: jfnorris | last post by:
I'm having some difficulty with Visual Explain. When I explain reletively simple sql, VE will generate an access plan. If I try to explain sql with several joins both outer and inner, or anthing more...
0
by: new | last post by:
No matter whether I do a explain or a run and explain i get times only for the full query and not for the indivdual steps that are shown in the icons. Is there some way to do this? Also do you...
0
by: mantaintai | last post by:
Proof of visual consciousness visual consciousness image formation by a plane mirror , visual consciousness, transform, virtual image , overlap(superpose), dual identities, seeing an object ...
1
by: mantaintai | last post by:
I uncover the secret of visual consciousness Proof of visual consciousness visual consciousness image formation by a plane mirror , visual consciousness, transform, virtual image ,...
0
by: vrama11 | last post by:
Hi, I am using DB2 V9.1.300.257 on Windows. When I try to get the visual explain plan for a query from the command editor, it gives the following error: SQL0104N An unexpected token "WITH...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: lllomh | last post by:
How does React native implement an English player?
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

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.