Question & Answer
Question
How can I determine what SQL SELECT or DB2 Stored Procedure call is being made by the CICS Interdependency Analyzer (CICS IA) Explorer Plug-in? For example, if I run a scanner query with no filters and run the scanner view with no filters, I get different results. It would help to see the actual query.
Answer
The most recent CICS IA Explorer plug-in has a preference you can set under 'Database Retrieval Parameters'->'Database Retrieval Debug' that allows you to request the SQL messages be logged (click the radio button) and to 'Open Debug View' (click the button)....then click the 'Apply' button and 'OK' buttons.
I ran the 'Scanner' view which returned 32 rows for the GENAPP data set...
If I now run my own test scanner query...
... it returns 31 rows for the GENAPP data set, only 251 LOADLIB members and the LOADLIBE data set is missing from the results....
...the 'DB Retrieval Debug' view shows the difference between the SQL queries. The Scanner view was a UNION of two tables, CIU_SCAN_SUMMARY and CIU_PROGRAM_INFO.
...the Test Query on the scanner used table CIU_CICS_SCAN. The Scanner view includes CSECT information as well by using the CIU_PROGRAM_INFO table.
So you want to see the generated SQL SELECT or the DB2 stored procedure CALL (for example when viewing applications or a threadsafe report), just navigate to the Window>Preferences>Database Retrieval Parameters>Database Retrieval Debug and click the radio button to log SQL messages the the 'Open Debug View' button.
Product Synonym
CICSIA CICS IA
Was this topic helpful?
Document Information
Modified date:
07 May 2015
UID
dwa1176161