Re: Analyzing RUNSQLSTMT jobs

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

Alan, search on SQE and plan cache.

https://www.ibm.com/docs/en/ssw_ibm_i_73/rzajq/rzajqpdf.pdf



On Mon, Jul 5, 2021 at 8:20 AM Alan Shore via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> Hi everyone
> We are on V7r3
> I have asked this in the past, and I saved the e-mails for when I needed
> them
> Unfortunately, i can no longer find the e-mails
> Google search doesn't give me anything
>
> So - here we go again
> I have a program that runs a few RUNSQLSTMT commands
> It takes approximately 1 hour or so because there is a LOT of data in
> numerous files
> Last night run was still running after 9 hours
> WRKACTJOB option 5 doesn't really help
> No locks on any files etc.
>
> How can I analyze RUNSQLSTMT while they are running?
>
>
> Alan Shore
> Solutions Architect
> IT Supply Chain Execution
>
> [cid:image001.png@01D77176.A1083BF0]
>
> 60 Orville Drive
> Bohemia, NY 11716
> Phone [O] : (631) 200-5019
> Phone [C] : (631) 880-8640
> E-mail : ASHORE@xxxxxxxxxxxxxxxxxxxx
>
> 'If you're going through hell, keep going.'
> Winston Churchill
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com