× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. September 2018

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

Thanks Luis, I'll review it.

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 Luis Rodriguez
Sent: Tuesday, September 25, 2018 1:45 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

Kendall,

Visual Explain has an Index Advisor option (or words to that effect). Check what would it suggest to you (maybe all you need is a new index).

Regards,
Luis
Luis Rodriguez

--



On Tue, 25 Sep 2018 at 14:04, Kendall Kinnear <Kendall.Kinnear@xxxxxxxxxxx>
wrote:

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-DmyMmSeXzqzAOY98
w&
r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=2M6wHIdVjYeWmII5af
rX
qVsUjDPwwljcOuAbO18AzxI&s=Hy8Lqlw07lX4eqpbjTmUnGKm-iC4Xtebkha7b1NZ
Fd 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=pOvNBD1fQ8EIsnWxC
JIvLGGO-zLgOpZ92efsKAWQMBM&m=2M6wHIdVjYeWmII5afrXqVsUjDPwwljcOuAbO18Az
xI&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_2dEadi
D&
d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOp
Z9
2efsKAWQMBM&m=2M6wHIdVjYeWmII5afrXqVsUjDPwwljcOuAbO18AzxI&s=UrG-W5
Jn 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=2M6wHIdVjYeWmII5afrXqVsU
jD
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=pOvNBD1fQ8EIsnWxC
JIvLGGO-zLgOpZ92efsKAWQMBM&m=2M6wHIdVjYeWmII5afrXqVsUjDPwwljcOuAbO18Az
xI&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-zLgOpZ92e
fs
KAWQMBM&m=2M6wHIdVjYeWmII5afrXqVsUjDPwwljcOuAbO18AzxI&s=UrG-W5JnjYpp
RX
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.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=pOvNBD1fQ8EIsnWxC
JIvLGGO-zLgOpZ92efsKAWQMBM&m=2M6wHIdVjYeWmII5afrXqVsUjDPwwljcOuAbO18Az
xI&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=
________________________________

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.co
m_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pO
vNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=xHsO7Jo6c3QAZk-oahRJIWTWFr
o3snpEC2DHg5I5kyk&s=a6sxH4dKuMDm7S6_LDsjpcVFWvruKDw9wUTtxMJ5xs0&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=xHsO7Jo6c3QAZk-oahRJIWTWFro3snpEC2DHg5I5kyk&s=TcAEHZx9Koxa-KJLkwjZB5k9IIIOqdCC9jpzlepjdLo&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=xHsO7Jo6c3QAZk-oahRJIWTWFro3snpEC2DHg5I5kyk&s=oxa3pzzpbpRQIO
9mXmcRsRv1B7cOEyKVzxL6v6R5Luc&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=xHsO7Jo6c3QAZk-oahRJIWTWFro3snpEC2DHg5I5kyk&s=a6sxH4dKuMDm7S6_LDsjpcVFWvruKDw9wUTtxMJ5xs0&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=xHsO7Jo6c3QAZk-oahRJIWTWFro3snpEC2DHg5I5kyk&s=TcAEHZx9Koxa-KJLkwjZB5k9IIIOqdCC9jpzlepjdLo&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=xHsO7Jo6c3QAZk-oahRJIWTWFro3snpEC2DHg5I5kyk&s=oxa3pzzpbpRQIO9mXmcRsRv1B7cOEyKVzxL6v6R5Luc&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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.