Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Location
    New Jersey
    Posts
    2

    Unanswered: DB2 BIND Manager

    Correction : the last post I posted I meant DB2 BIND Manager not IMS.

    Hello,
    Can someone out there share their experience with the DB2 BIND Manager tool. We are a development shop and our application folks rebuild their environment every night and ofcourse it also includes the BINDs. I think this is an overkill...but they always get back to me saying that they cannot figure out what changed etc. and to keep track of the changes it will be an administrative nightmare. These jobs are single threaded and they put a lot of strain on the system.


    Thanks,
    Umesh

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    In this forum you can edit your own existing posts, or delete your own posts.

  3. #3
    Join Date
    May 2003
    Location
    Amsterdam
    Posts
    65
    (re)-Binding can also be useful if you are using static SQL and you have very volatile tables in your database.
    DB2 will calculate access plans based on the table and index statistics. Rebinding is also necessary if you changed application code, altered the database design, etc.
    Anton Versteeg
    IBM Netherlands

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •