Results 1 to 4 of 4

Thread: Mass rebind

  1. #1
    Join Date
    Aug 2004

    Unanswered: Mass rebind

    What is the easiest way to rebind all the plans in a DB2 subsystem?

  2. #2
    Join Date
    May 2003
    Since you used the word "subsystem" does that mean you are using DB2 for OS/390 and z/OS? Please specify your platform and other info as requested in Must Read Before Posting thread.

    You can build a list of all plans to rebind using the following as a guide (this is not the exact syntax):

    Select 'REBIND PLAN ('||name||' );' from sysibm.sysplan where ...

    You can do something similar for packages if needed.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2004
    look at "db2rbind" if on the distributed...

    db2rbind database-alias -l logfile [all -u userid -p password] [-r {conservative|any}]

  4. #4
    Join Date
    Sep 2003
    I am assuming that your platform is os/390 or Z/os. If it is, then goto DB2I PRIMARY OPTION MENU (where we run our spufi etc) use option 5. which can be used for bind/rebind one or all plans and packages in a subsystem.

Posting Permissions

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