Db2 Tools

 View Only
  • 1.  Packages preforming FULL TABLE SCAN on a given DB2 table

    Posted Feb 17, 2019 04:09 AM

    Hi community members.
    I would like to use CA Plan Analyzer 20.0 for creating a report of all packages preforming FULL TABLE SCAN on a given DB2 table. Is it possible?
    We use DB2 V11 and z/OS 02.02



  • 2.  Re: Packages preforming FULL TABLE SCAN on a given DB2 table

    Posted Feb 18, 2019 09:52 AM

    CA Support will research this question and get an answer to you soon.



  • 3.  Re: Packages preforming FULL TABLE SCAN on a given DB2 table
    Best Answer

    Broadcom Employee
    Posted Feb 19, 2019 01:42 PM

    Hi Eugene, I'm creating an issue(case) and will send you an email from the case. Thanks