Search

1 to 10 of 57
Sort by

Blog Entry
More on Microservice Architectures and Performance

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...

John Maenpaa's profile image

Blog Entry
Microservice Architectures and Performance Models

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...

John Maenpaa's profile image

Blog Entry
Improving Performance in Your Data Warehouse – Part 1

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...


Blog Entry
“Guilty Until Proven Innocent”

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...


Blog Entry
DB2 LUW Version 11.1.1.1 Preview Features by George Baklarz

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,...


Blog Entry
Understanding DB2 for LUW Buffer Pool I/O

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...

Martin Hubel's profile image

Blog Entry
IDUG Tech Talk: Advanced In-Database Analytics Using R

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...


Blog Entry
Dynamic Plan Stability in DB2 12 ESP for z/OS

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...

Joe Geller's profile image

Blog Entry
Our Road to Success with the DB2 Analytics Accelerator

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...


Blog Entry
Temporal and Archive - How to Manage Data Over Time

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...

Kurt Struyf's profile image