Write a little routine that snaps the DSC and EXPLAINS all the
statements within. Then you have the data you need. Start with
EXPLAIN STMTCACHE ALL and then loop through the output doing
EXPLAIN STMTCACHE STMTID xxxxx read from the first EXPLAIN. If this
looks too difficult, scary, not all the data can be processed
quickly enough, it can’t be done [delete what is not
applicable] then contact a few vendors as they all can do this as
SOFTWARE ENGINEERING GMBH and SEGUS Inc.
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich
From: John SooHoo [mailto:[login to unmask email]
Sent: Friday, July 6, 2018 12:41 AM
To: [login to unmask email]
Subject: [DB2-L] - DB2 z/OS - Any way to create a sysSQLdep for
Dear Esteemed Listers,
Has anyone ever found a way to develop the SQL equivalent of a
syspackdep for dynamic SQL (a sort of sysSQLdep)? I'm thinking
specifically of trying to analyze all the SQL (which is mostly
dynamic) for a particular application's service ID, what the SQL is
and what indexes they use.
If there is a way to do that, I would appreciate if someone could
illuminate the steps taken to get there.
Thanks in advance for any help in this matter.
-----End Original Message-----