Automatic rebind with Db2 roles

If you execute a package that is marked invalid, Db2 will attempt to rebind it.

Begin program-specific programming interface information.If the package contains static SQL statements, Db2 will check the owner for the required authorization for a successful rebind. If RACF® access control is used and if the owner of the plan or package is a Db2 role, Db2 will be able to complete the rebind.

Start of changeIf the AUTHEXIT_CHECK system parameter is set to DB2, Db2 provides the ACEE of the package owner to perform authorization checking when processing autobinds or BIND and REBIND commands. Db2 provides the ACEE of the authorization ID as determined by the DYNAMICRULES option to perform dynamic SQL authorization checking. The access control authorization exit uses the ACEE for XAPLUCHK for authorization checking. The XAPLUCHK authorization ID can be a user or a group in RACF. To ensure successful authorization checks with the owner ACEE, the owner authorization ID in XAPLUCHK must be permitted access to the resources in RACF. End program-specific programming interface information.End of change