RE: Query "stopped" in its tracks, still "running"

My first thought was that at 5 million you had an error and were in a rollback phase. I don't use commitment activities so I cannot state for certain if you can see the rollback occurring. Or it I happens but presents itself all at one.

-Matt


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Sent: Tuesday, February 13, 2018 3:40 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Query "stopped" in its tracks, still "running"

Who knows what really is going on under the covers? I expect that IBM's got the DB2 (sorry, "Db2") engine tuned to a 'T'. It's just *really* strange that it wrote 5M records to the new table and then, JUST STOPPED.

DASD's only at 41%.

Funny thing is, this particular query is actually the CTE portion of another query that I broke out for this test.

Since it's EOD, I'm going to kill the job and resubmit it.

- Dan

On Tue, Feb 13, 2018 at 5:30 PM, Musselman, Paul < pmusselman@xxxxxxxxxxxxxxxx> wrote:

I'm no SQL expert, but when AS/400 Query did something like that, it
was joining every possible combination of join fields into a massive
work file...

I don't know if SQL does something similar, but how's your disk space
looking??

If all else fails, try just the A-B join by itself; and the B-C by
itself, and see what you get...

--
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=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=EDGHqurgX16V4S8704Kc5n_PQSaoFoZTnYu7P4j5E80&s=yDM7M6_A6Msn3i-t0HJVtziUnPhGckJS2eWR3F84cxU&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=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=EDGHqurgX16V4S8704Kc5n_PQSaoFoZTnYu7P4j5E80&s=lx_FJcW5YzJLeJgbSFiKWG-3JqigybECxEW6D-x2Iw8&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=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=EDGHqurgX16V4S8704Kc5n_PQSaoFoZTnYu7P4j5E80&s=0ZiVNyb51xiu0pPb9bwEatehPJ0MEXdWAtkAfnQJjEg&e=