[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

How to capture "Explain SQL" output

Posted on 2008-09-30
3
Medium Priority
?
348 Views
Last Modified: 2008-09-30
How do I capture ALL of a StoredProcs "Explain SQL" output?

When I run "Explain SQL", I get a listbox-like display.
When I try to Highlight, Copy and Paste ...
the capture stops at a line with little squares embedded in the line and the remaining text is NOT captured.

little squares appear where I have X's below

          SQL402B Table 3XXXXXX used in hash join step 1.

And capture stops ...

I'm using iSeries Navigator V5R3M0
0
Comment
Question by:volking
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22606968
all explain output is inserted into a table called plan_table
you can find it there
0
 
LVL 5

Author Comment

by:volking
ID: 22607135
@Momi
Thanks!
... is PLAN_TABLE in a specific Schema/Library?
0
 
LVL 37

Accepted Solution

by:
momi_sabag earned 2000 total points
ID: 22607235
its in the schema of the user you used to run the explain statement
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question