Articles & Content

Archives

Can I control a dynamic world? - Dynamic SQL Management for DB2 z/OS (E12)

Topic: 2011 EMEA

Subtopic: Cross Platform DB2 for z/OS & LUW



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.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.