472,338 Members | 1,720 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

(Visual) Explain for z/OS

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 estimation.
Anybody experienced this as well ?

I am not sure this is related to that we use V7 and the product has
been designed for V8 database.
Since already in V7 documentation I find that I should see much more I
tried to get an older version, but this is unfortunately not available
for download anymore.

Second: Does anybody have a real good paper or so on the explain tables
? I know where the documentation is, I am looking for something that
points me quickly to what I need: type of joins and their predicates
and which join introduces high costs.

Thank you !


Nov 12 '05 #1
0 1129

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

Similar topics

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...
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...
by: Buck Nuggets | last post by:
Since upgrading to db2 8.2.1 I've been having odd problems with visual explain: 1. tables appear to require schema prefixes: SQL0204N ...
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...
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...
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...
by: mantaintai | last post by:
Proof of visual consciousness visual consciousness image formation by a plane mirror , visual consciousness, transform, virtual image ,...
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...
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...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

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.