In last week's article, I wrote a little about microservice architectures and how that trend can impact performance. Now, I want to dive a bit deeper into an example where an application design that used to be efficient can become overly expensive. Code/Reference Tables I'm sure every one...
Microservice architectures are trending. We need to consider how this impacts the performance of our applications and the databases we build to support them. What is a Microservice? Over the past decade or so, the Service Oriented Architecture (SOA) has been one of the prevalent application...
“As time goes by…..” DB2 for z/OS continues to enhance support for temporal data. Since the availability of the initial temporal support with DB2 10 for z/OS, the functionality has been extended several times. The subject of this article is one of the temporal extensions, the temporal special...
DB2 for z/OS NoSQL Support Update: REST and JSON Daniel Luksetich, DanL Database consulting danl@db2expert.com 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,...
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...
Introduction For the past 30 years, our focus as DB2 for z/OS database administrators has been on the support of COBOL programs with static queries that were relatively easy to control as they were identical throughout the business logic. Static SQL provided persisted access paths in the...
DATE: 2008-05-22 (10:30 AM - 11:30 AM) SPEAKERS: Nogi Simanjuntak (IBM) Today's enterprise architectures often includes stored procedures. This presentation addresses the currrent hot topics in developing and managing stored procedures in DB2 for z/OS: how to avoid common problems, performance...
NA08C14.pdf
DATE: 2008-05-22 (10:30 AM - 11:30 AM) SPEAKERS: Terry Purcell (IBM Silicon Valley Lab) You can always read about the features/enhancements of a new release, such as DB2 9 for z/OS, in the manuals, in redbooks or by attending highlight presentations. But what you generally miss from these...
NA08F14.pdf
DATE: 2008-05-22 (10:30 AM - 11:30 AM) SPEAKERS: Steve Rees (IBM Toronto Lab) There are many good reasons for wanting to measure performance of your DB2 statement, application or system. Maybe you want to track total system load over time for capacity planning, or it could be that you need to...
NA08A14.pdf
DATE: 2008-05-22 (08:00 AM - 09:00 AM) SPEAKERS: Naomi Rafael (MMIM Project, Research Directorate, Melbourne Health) Metadata management is the key to effective integration, presentation and use of heterogeneous data. The Molecular Medicine Informatics Model (MMIM) Project in Melbourne,...
NA08D13.pdf