Customer trying to view active SQL statements that include host variable values (not just :HV) for static bound CICS programs.
Is this possible ?
Same question for SQL History displays.
Yes, this is possible with the Detector product. I do not think so with the Sysview for DB2.
I was wondering whether PDTSQL would provide this level of detail in the THRDDETL display, but I don't think that's possible either.
I misspoke. For an Active SQL, the Thread Terminator product has the capability to see the Host Variables. Detector would only see this when it is an Exception. (A metric exceed a predefined threshold). Let's talk more about this use case.