Re: SQL Plan Cache Statements - NOT LIKE ?

You mean something like
*cl:* *STRDBMON* OUTFILE(ROB/ROBDBMON) JOB(*ALL) FTRFILE((ERPLXF/*ALL));
-- do some sql
*cl:* *ENDDBMON* JOB(*ALL);

CALL QSYS2.DUMP_PLAN_CACHE('ROB','CACHEDUMP');
SELECT *
FROM ROB.CACHEDUMP
WHERE QQTIME > *CURRENT TIMESTAMP* - *1* *HOUR*
AND QQJOB='QZDASOINIT' AND QQUSER='QUSER' AND QQJNUM=*352046*;


On Fri, May 19, 2023 at 9:41 AM Justin Taylor <jtaylor.0ab@xxxxxxxxx> wrote:

I have an issue with SQL Plan Cache Statements (ACS -> SQL Performance
Center -> Show Statements). There are so many statements that I consider
"noise" that I can't see anything else.

Does anyone know a way to access that data directly (e.g. SQL views, SQL
services)? A simple "not like" clause would easily fix my issue.


TIA
--
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.