Minimize your trips to DB2 and reduce your DB2 elapsed and CPU times

Most relational tuning experts agree that the majority of performance problems with applications that access DB2 are caused by poorly coded programs or improperly coded SQL. A great deal of time is spent on tuning your SQL but how much time are you spending tuning or conducting performance reviews of your application code? This session takes a close look at reducing the total number of SQL statement and reducing your trips to DB2 by implementing coding techniques that can reduce multiple SQL statements to single requests.

This video presentation is available on the IDUG DB2 Tech Talk Channel. Select ON24 or YouTube.

ON24

YouTube

Recent Stories
Db2 for z/OS locking basics

A Beginners Guide to Locks, Latches, Claims and Drains in DB2 for z/OS by Steve Thomas

Fun with Date Ranges