Question about parameter ABIND - 01-16-2007 , 09:30 AM
I have a question about Autobind.
Last weekend we make an change in prodution.
We drop two index and one view,
and create it again with some changes.
Some packages where in status of Invalid.
We have ABIND = Yes, and our believe was that auotbind should help us.
I wonder if IBM can help to answer when autobind will help us ?
Re: Question about parameter ABIND - 01-23-2007 , 03:28 PM
You could generate Binds yourself, I suppose.
Autobinding wouldn't happen until the package are
accessed, and then there'd be a delay, and possibly a
failure. I think the DBRMLIB might need to be accessed,
and if the DBRM or the library are missing, that would
be a problem.
Re: Question about parameter ABIND - 02-04-2007 , 11:27 AM
once you make a change (alter / drop an object your package depends on) that makes the package invalid, the next time the package will be rebind (if autobind is enabled) is the next time the application will run and try to access this package.
the autobind process does not need to access the dbrm libraries
if the autobind will fail, the package goes into invalid status and the application will recieve an error message
you can always check in advance which packages will be affected from your sql statements by checking sysibm.syspackdep