How to capture "Explain SQL" output

Posted on 2008-09-30
Medium Priority
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
Question by:volking
  • 2
LVL 37

Expert Comment

ID: 22606968
all explain output is inserted into a table called plan_table
you can find it there

Author Comment

ID: 22607135
... is PLAN_TABLE in a specific Schema/Library?
LVL 37

Accepted Solution

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
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…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment. Powered …
Suggested Courses

624 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