Db2 Tools

Expand all | Collapse all

Sysview/DB2 - Display SQL host variables

Jump to Best Answer
  • 1.  Sysview/DB2 - Display SQL host variables

    Broadcom Employee
    Posted 11-17-2017 09:47 AM

    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.



  • 2.  Re: Sysview/DB2 - Display SQL host variables
    Best Answer

    Posted 11-20-2017 10:45 AM

    Colin,

     

    Yes, this is possible with the Detector product.  I do not think so with the Sysview for DB2.  

     

    Jeff 



  • 3.  Re: Sysview/DB2 - Display SQL host variables

    Broadcom Employee
    Posted 11-21-2017 05:02 AM

    Thanks Jeff.

    I was wondering whether PDTSQL would provide this level of detail in the THRDDETL display, but I don't think that's possible either.



  • 4.  Re: Sysview/DB2 - Display SQL host variables

    Posted 11-21-2017 06:26 PM

    Colin,

     

    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.  

     

    Jeff