A Review of BIND and REBIND parameters for DB2

Over the past few releases many new features have been added to DB2 which can be used to enhance the Performance and Availability of your Applications. Many of these are controlled by new keywords and parameters that have been added to the BIND and REBIND commands. This presentation will provide a useful summary and review of the most important newer capabilities, as well as taking another look at some of the more critical older options where the recommended settings may have changed since you started using DB2 for z/OS. 

Topics to be covered will include setting appropriate Isolation Levels and when to acquire and release resources, High Performance DBATs, Controlling when Optimization occurs, providing hints to the Optimizer and managing access path degradation using Plan Stability and/or the new APREUSE and APCOMPARE functionality.