I totally agree, that's why such task works only if you have more than N months of statistics.
Changing point of view, another way is to have all the tables with AUDIT and start the AUDIT trace to catch (DB2 IFCID 143/144) all the accesses to the tables. It can (or cannot) a problem for performances, as usually in DB2 "it depends". >From IFCID before mentioned you can get the jobname and stepname and then you can find the main program. Don't shoot to me ! :D Best regards. Max Il giorno gio 19 feb 2026 alle ore 14:01 Seymour J Metz <[email protected]> ha scritto: > Even with tracing it's hard; there may be code that is rarely exercised. > > > -- > Shmuel (Seymour J.) Metz > http://mason.gmu.edu/~smetz3 > עַם יִשְׂרָאֵל חַי > נֵ֣צַח יִשְׂרָאֵ֔ל לֹ֥א יְשַׁקֵּ֖ר > > > > > ________________________________________ > From: IBM Mainframe Discussion List <[email protected]> on behalf > of Massimo Biancucci <[email protected]> > Sent: Thursday, February 19, 2026 1:32 AM > To: [email protected] <[email protected]> > Subject: Re: Need xref of load modules to find called submods (around > 10000) > > > External Message: Use Caution > > > Thomas, > > in my understanding what you're looking for is not so simple to do with a > job. > Dynamically called means that load module name could be read from an > external source or built by a prefix and so on. > Last but not least, some modules could be referenced in source and never > called (dead code) > The shops where I work, we use a mix of tools to collect items. > For instance, P-Tracker (from UBS Hainer) to catch all load modules used by > every single job and a home made tool to do the same in CICS at transaction > level. > So, after that, we know in which process (batch or CICS transaction) a > given module has been used and query for the others as needed. > Maybe your shop has a "simpler" installation so reading source can be > enough. > > Best regards. > Max > > Il giorno gio 19 feb 2026 alle ore 00:21 Farley, Peter < > [email protected]> ha scritto: > > > If bringing in a new product is possible, the XREF utility used by my > > employer is pretty good for what I believe is a reasonable price (or was > > when I first brought in the product some years ago). > > > > XREF from DCMS, Inc. ( > https://secure-web.cisco.com/1kpiQEG6eQ87QCXlcnvq-vCBp_NRUUEHEVXZxpobaMcdn6oc-q76deGpW1VhPmtDF90vdb78ugX6Kt4cEmAhSG43mwmf4stMWl0UxiGyJcNUdoq_YX9F3qlgah_3UjFN-EqFiYoO1meO-eRX21hefN-gVMMcy4Fz7Jbl6rJVYyWL7tl9UkyQOe0-3UOKBMBKm67v_BQNo8TEU6oPLqEfGZIoUMyEjTpXVvhdkn7sDcAVDOQJx7Cqb0oVeJ9LnRLBg8FiJwY43bfNYXtW0GuBS4cjxfOUboB80v5JLJBf4Kv9AduJ8xoD6tpFn975Dd7bfKPoRLsRx_FGWD10lw3kQBV2FoGYZRZLco9lKBh9K9n10Qlq_3ONd2Gx_pJOiwbUisbfzsVDkQLd2Tuwy-dCypudGaapCy6sK7UpBV-aaVflSuGPKbnP3PVi3TaGVShYV/https%3A%2F%2Fwww.dcmsi.com%2F > ). > > > > Does source and copybooks, called programs (static and dynamic), batch > and > > CICS, and DB2 SQL as well. Also does PROC’s and JCL and datasets in > batch > > and FILEID’s in CICS. Good support from my experience with them. > > > > HTH > > > > Peter > > > > From: IBM Mainframe Discussion List <[email protected]> On Behalf > > Of <Thomas> <Berg> > > Sent: Wednesday, February 18, 2026 7:35 AM > > To: [email protected] > > Subject: Need xref of load modules to find called submods (around 10000) > > > > > > I have a need to get all called submodules in around 10000 loadmodules, > > both static and dynamic. > > > > I had such program(s) and job to do that 10 years ago but lost it when I > > retired (began working again 2024). > > > > > > > > Any way to do that (easily) with typical zOS tools or maybe downloadable > > user tools? > > > > (I'm not able to do any installs outside of my userid.) > > > > > > > > For those interested: I need to find all main programs that uses a DB2 > > table (data from). > > > > The chain is: > > > > DB2 table <-- known sub modules <-- calling modules in other applications > > (many hundreds of applications, potentially thousends of programs). > > > > > > > > (This is not a one time usage, I will do similar things further on.) > > > > > > > > -- > > > > This message and any attachments are intended only for the use of the > > addressee and may contain information that is privileged and > confidential. > > If the reader of the message is not the intended recipient or an > authorized > > representative of the intended recipient, you are hereby notified that > any > > dissemination of this communication is strictly prohibited. If you have > > received this communication in error, please notify us immediately by > > e-mail and delete the message and any attachments from your system. > > > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to [email protected] with the message: INFO IBM-MAIN > > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > > > > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
