Articles & Content

Archives

Application and SQL Design for Performance

Topic: DB2 for z/OS

Subtopic: 2014



This presentation will cover many alternatives to our normal applications in order to achieve performance. Many techniques to minimize overhead and locking will be explored. We will also take a look at techniques coding efficient SQL and minimizing the amount of data we bring back to process in our applications via optimal predicates, less repetition and better use of indexes. We will also look at recent release features in DB2 that can be exploited to achieve best performance.



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.