MVSFORUMS.com

[cxvxbx]

I have to analyze a CICS transaction that involves more than a 100 dynamically called modules. The requirement is to identify all modules (invoked in this transaction) which have a database update/insert function.

Are there any tools or utilities which can be used for carrying out this analysis ?

[schintala]

Does your shop have any monitoring tool like DB2MON /OMEGAMON.? If you have any such toos you will be able to identify the SQL functions attched to the CICS thread.

[astro]

Did you think of the option of querying for INSERTAUTH = 'Y' or UPDATEAUTH='Y' in SYSIBM.SYSTABAUTH tables with all your called modules as 'GRANTEE' and 'GRANTEETYPE = 'P'' ?
I am not sure if your requirement is so complex than I think.

[schintala]

DB2 catalogue table SYSIBM.SYSTABAUTH specifies only priviligies of users who can access which SQL function on the table. CXVXBX requirement is to find the SQL functions attached to a CICS transaction.

[astro]

Hello Schintala,
If I assume that CXVXBX is mentioning the programs as modules then it can be very well found out from SYSIBM.SYSTABAUTH, which program is inserting/updating which db2 tables with the query I have posted before.
As you said, you can also find out the privileges of the users. But the GRANTEETYPE associated with the users are space.(' '). If it is program, then its GRANTEETYPE = 'P'.

[cxvxbx]

Thanks for the response schintala & astro.

Our shop does have OMEGAMON and we are exploring the usage for the same.

About using SYSIBM.SYSTABAUTH, there is a small glitch here. We do not have a list of modules that will be invoked in this transaction. Without having this list, it would'nt be possible to use this option.

Thanks again, your inputs have been of great help. Do let me know if there are any other alternatives which can be explored.