Db2 for z/OS & Db2ZAI

Db2 for z/OS and its ecosystem

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Runstat profiles/ Rebinds question

    Posted Fri January 29, 2021 01:35 PM




  • 2.  RE: Runstat profiles/ Rebinds question

    Posted Mon February 01, 2021 10:37 AM
    Hello Carol,

    You only have a subject but no question.

    Regards,

    Gareth Copplestone-Jones
    Triton Consulting
    IBM Gold Consultant, IBM Champion

    ------------------------------
    Gareth Copplestone-Jones
    ------------------------------

    Original Message


  • 3.  RE: Runstat profiles/ Rebinds question

    Posted Mon February 01, 2021 01:36 PM
    You might want to build a table that you cat store the old bind with or store multiple binds with versioning. Then compare and see if you need to vert any back.

    I mostly use auto runstats for dynamically accessed tables. And only rebind application objects on release boundaries after a table has been stabilized.

    Don’t forget has part of the auto runstats, you should be using Acox to determine if a runstats is even needs to be done.


    Sent from my iPad


    Original Message