Re: Is there a way to step through an SQL from Run SQL Scripts on PC

It sounds like you are asking for a visual debug got SQL, but really SQL
doesn't work that way. It performs the whole query in one atomic bite, not
exactly, but the steps aren't laid out in the SQL, as others have
mentioned, you can look ate the visual explain to see what it is doing, but
not what each step returns.

The way I go through an SQL looking for problems is to comment out
everything but one table, and the clauses that reference it. then one by
one, I add tables and associated references until I see just what it is
that is causing the problem.

On Tue, Sep 25, 2018 at 1:20 PM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

Kendall,

Run your script using ACS's RUN SQL and select the Visual Explain option.
It can show you what the Db2 engine is doing and give you suggestions for
optimizing your data access (eg. create an index9.

Regards,

Luis Rodriguez

--



On Tue, 25 Sep 2018 at 13:14, Kendall Kinnear <Kendall.Kinnear@xxxxxxxxxxx

wrote:

I have a Business Intelligence developer who has created a SQL query that
is acting weird. When they run it against production it takes a few

seconds

and works perfectly. When he changes the SQL to use a copy of one table

in

another library the SQL runs forever and has to be canceled. I'm trying

to

figure out where it is going haywire but I'm not seeing anything.

I'd really like to step through the SQL somehow and see what is what is
happening. Is that an option somehow?

Any suggestions?

Respectfully,
Kendall Kinnear
System Analyst
Standard Motor Products, Inc.
Work: 972-316-8169
Mobile: 940-293-7541
________________________________

Please consider the environment before printing this email.

The content of this e-mail (including any attached files) is confidential
and may be privileged and protected by law. It is intended solely for the
purpose of the person to whom it is addressed. If you are not the

intended

recipient of this message, please notify the sender immediately and

delete

the message (inclusive of any attached files). In addition, if you are

not

the intended recipient of this message, any disclosure, copying,
distribution or taking any action in reliance of the contents of this

email

is strictly prohibited.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD