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.

I think you can just rebind the package-name. You don't need to know where it is. See the rebind command.

Thanks for your help. I will try db2rbind <dbname> all.