Db2 for z/OS

nested-group-icon.png

DB2

Expand all | Collapse all

Runstat profiles/ Rebinds question

  • 1.  Runstat profiles/ Rebinds question

    Posted 28 days ago
    -------------------------------------------
    Original Message:
    Sent: Wed January 27, 2021 12:11 PM
    From: carol goldberg
    Subject: Runstat profiles/ Rebinds question

    I was told that I should post this here, instead of in DB2 




  • 2.  RE: Runstat profiles/ Rebinds question

    Posted 25 days ago
    Hello Carol,

    You only have a subject but no question.

    Regards,

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

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



  • 3.  RE: Runstat profiles/ Rebinds question

    Posted 25 days ago
    -------------------------------------------
    Original Message:
    Sent: Wed January 27, 2021 12:11 PM
    From: carol goldberg
    Subject: Runstat profiles/ Rebinds question

    I was told that I should post this here, instead of in DB2 


    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