This fifth part of the DB2 11 for z/OS Developer certification test requires the knowledge of processing options you use when preparing and running your programs.
The DB2 landscape is changing quickly, and sometimes things can quietly sneak in before you even realize it. Maybe you have heard IBMers talking about JSON support in DB2, but have you heard about the mobile DB2 access and DB2 RESTful API that is now available for DB2 for z/OS?
This week we continue our theme of improving application performance by reducing the number of calls to DB2. In addition to using DB2 techniques, we look at programs that retrieve more data than they really need, retrieve data sooner than it is needed, and retrieve the same data multiple times.
Sometimes we forget. It isn’t so much getting older (I hope) but more that we continue to get busier and busier. With the rush to pick up and handle the new tasks that are thrown our way we sometimes miss the basics. Application design that takes into account performance is one of those basics...
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 o