Re: Program explosion report

[Jeff Young <jyoung0950@xxxxxxxxx>]

Jonathan,
I also experienced this problem this problem using your example.

Jeff Young
Sr. Programmer Analyst

On Fri, May 8, 2015 at 10:37 AM, Dan <dan27649@xxxxxxxxx> wrote:

> Jonathan,
>
> Are there any scenarios of which you're aware that would cause this query
> to loop endlessly?  I just tried this on another program, and let the query
> run for a good 10 minutes before I killed it.  The job had no halts; the
> CPU was running, and the temp storage on the job was climbing into the tens
> of gigabytes.  I'm not sure how I would debug this.  The other five
> programs I tried with this finished within 5 seconds.  I would expect the
> depth on this program to be no more than 10 levels, probably closer to 5.
>
> Also, the example DSPPGMREF in the comments of the SQL source shows
> "OBJTYPE(*PGM)".  Is there any reason you're not including *SRVPGM?
>
> Thanks again for sharing!
>
> - Dan
> --
> 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: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>