473,385 Members | 1,814 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,385 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 !

Juliane

Nov 12 '05 #1
0 1166

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...
2
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 "BUCK.DIM_SENSOR" is an undefined name. SQLSTATE=42704...
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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.