• 1 reply
  • Latest Post - ‏2013-05-14T12:11:35Z by bdh002
2 Posts

Pinned topic is no rebind on migration technically feasible?

‏2013-05-14T11:28:48Z |

At migration time (say 9.5 to 10.1) the static packages are marked invalid. 

So a rebind has to be done either before application usage ore at runtime.

This has 2 drawbacks:

           - access plan can change at migration if APREUSE is not set

            - rebind all can take too much time 

Does the design allow to leave the package unchanged and is a manner of being sure it is 'supported'? 

Or could there be something between:  a tool scanning the packages of 9.5 and reporting those that (for some reason) must be rebound?


Bernard Dhooghe


PS: Auto-rebind at runtime is not an option, it's transaction boundary being the same as the application transaction boundary. 




  • bdh002
    2 Posts

    Re: is no rebind on migration technically feasible?


    Remark: apreuse only possible from 9.7