• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 350
  • Last Modified:

How to capture "Explain SQL" output

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
volking
Asked:
volking
  • 2
1 Solution
 
momi_sabagCommented:
all explain output is inserted into a table called plan_table
you can find it there
0
 
volkingAuthor Commented:
@Momi
Thanks!
... is PLAN_TABLE in a specific Schema/Library?
0
 
momi_sabagCommented:
its in the schema of the user you used to run the explain statement
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now