Dynamic SQL opened up some great opportunities facing today‚Äôs dynamic business needs. However, the downside is that dynamic SQL by nature is difficult to manage and to control. Especially in comparison to the capabilities we have for our static world, we lost control! There is no BIND, there is no REBIND and a RUNSTATS invalidates access paths even if it doesn‚Äôt touch the DB2 catalog. This presentation shows how you get back control of what happens in your environment. You get introduced to the various monitoring options that DB2 already provides out of the box, procedures you can implement to gain the same control and quality that we know from the static world and lots of hands-on tips and tricks that make your life in a dynamic world much easier.
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504