Db2 Tools

 View Only
  • 1.  Sysview/DB2 - Display SQL host variables

    Broadcom Employee
    Posted Nov 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 Nov 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 Nov 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 Nov 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