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

Thanks everyone. I was hoping for something to help with the review but I'll do the manual process. Unfortunately the visual explain view of this query looks like a 100 year old oak tree, a whole lot of branches!!!

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


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Murphy
Sent: Tuesday, September 25, 2018 12:39 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: 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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.
com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&
r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=2M6wHIdVjYeWmII5afrX
qVsUjDPwwljcOuAbO18AzxI&s=Hy8Lqlw07lX4eqpbjTmUnGKm-iC4Xtebkha7b1NZFd
k&e= or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=2M6wHIdVjYeWmII5afrXqVsUjDPwwljcOuAbO18AzxI&s=SlB81LgPrcsNZBL6pczXJtqG90r8Up9gkCE258h_K-s&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&;
d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ9
2efsKAWQMBM&m=2M6wHIdVjYeWmII5afrXqVsUjDPwwljcOuAbO18AzxI&s=UrG-W5Jn
jYppRXtttRhk4WN-UBJ9nmG0lLbr_mw1W1c&e=

--
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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pO
vNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=2M6wHIdVjYeWmII5afrXqVsUjD
PwwljcOuAbO18AzxI&s=Hy8Lqlw07lX4eqpbjTmUnGKm-iC4Xtebkha7b1NZFdk&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=2M6wHIdVjYeWmII5afrXqVsUjDPwwljcOuAbO18AzxI&s=SlB81LgPrcsNZBL6pczXJtqG90r8Up9gkCE258h_K-s&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=
DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efs
KAWQMBM&m=2M6wHIdVjYeWmII5afrXqVsUjDPwwljcOuAbO18AzxI&s=UrG-W5JnjYppRX
tttRhk4WN-UBJ9nmG0lLbr_mw1W1c&e=

--
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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=2M6wHIdVjYeWmII5afrXqVsUjDPwwljcOuAbO18AzxI&s=Hy8Lqlw07lX4eqpbjTmUnGKm-iC4Xtebkha7b1NZFdk&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=2M6wHIdVjYeWmII5afrXqVsUjDPwwljcOuAbO18AzxI&s=SlB81LgPrcsNZBL6pczXJtqG90r8Up9gkCE258h_K-s&e=.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=2M6wHIdVjYeWmII5afrXqVsUjDPwwljcOuAbO18AzxI&s=UrG-W5JnjYppRXtttRhk4WN-UBJ9nmG0lLbr_mw1W1c&e=
________________________________

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.