Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    18

    Unanswered: How to rebind SQL stored procedure

    When SQL stored procedure is created, it do the bind and created the package file automatically, and thus access plan are generated at that point. Is there a way I can update the access plan without dropping and recreating the SQL stored procedure? I want to rebind my SQL stored procedure but don't know where the bnd file is kept. I am using DB2 V7.2 windows client on V7.2 DB2 UDB on Linux. Thx.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I think you can just rebind the package-name. You don't need to know where it is. See the rebind command.

  3. #3
    Join Date
    Nov 2003
    Posts
    18
    Thanks for your help. I will try db2rbind <dbname> all.

Posting Permissions

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