?
Solved

How to capture "Explain SQL" output

Posted on 2008-09-30
3
Medium Priority
?
339 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

Stressed Out?

Watch some penguins on the livecam!

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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

777 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