The introduction of Dynamic SQL opened up some great possibilities for conquering high-paced, dynamic business demands. But, by the very nature of its flexibility, Dynamic SQL is challenging to manage & control – especially when compared to its „static“ cousin.
Maintaining control can be problematic: There is no BIND, there is no REBIND and RUNSTATs invalidates access paths – even when it doesn’t touch the DB2 catalog.
Don’t miss this 45 minute presentation, which will show you how to take charge of your dynamic environment. You will be introduced to the various out-of-the-box DB2 monitoring options, learn about procedures you can implement to gain the same control and quality you love in the static world, and take away lots of tips and tricks to make your dynamic life much easier.