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...
Introduction This article is one in a series that focuses on improving performance in Db2 Warehouse. The first part provides some background information and lays out the first and most important aspect of query optimization, namely, cardinality estimation or estimating the number of rows that...
The evolution of technology has driven the necessity for highly available systems and applications. Customer loyalty is directly related to their user experience which includes application functionality, performance and availability. Customer interfacing applications are often held to System...
DB2 LUW Version 11.1.1.1 Preview Features It's inevitable that you see a couple of DB2 Fix Packs every year and place the readme document in a drawer somewhere for perusal later when you are not busy. While the Fix Packs may contain fixes (well that is what they are primarily meant for,...
1 Comment - no search term matches found in comments.
Understanding DB2 for LUW Buffer Pool I/O You will get virtually no argument from anybody that buffer pool management is important to good DB2 and application performance. Large buffer pools are a well known wisdom. There are many ideas on buffer pool management, including the number of...
Analytics using R is often driven from client side applications such as RStudio and generally involves transmission of the large amounts of data from the database server to the clients for analysis. This method of doing the analysis can be slow given the limited resources on database client...
Disclaimer: Information regarding potential future products is intended to outline IBM’s general product direction and it should not be relied on in making a purchasing decision. The information mentioned regarding potential future products is not a commitment, promise, or legal obligation to...
The IBM DB2 Analytics Accelerator (IDAA) has proven to be a big success in enabling analytics on DB2 z/OS data. Roberta Barnabè gave a well-received presentation at IDUG EMEA 2015 in Dublin on how her company implemented IDAA. This presentation is full of practical advice and can help any shop...
This month we will be focusing on temporal table design and Archive tables. DB2 11 for z/OS brought many interesting improvements for temporal tables, which will be addressed during the upcoming month. On top of that in gave us archive tables, which we can use for “transparent archiving”. As a...