1 to 10 of 15
Sort by

Blog Entry
July Spotlight – Db2 LUW: Types of I/O

July Spotlight – Db2 LUW: Types of I/O Since the beginning of commercial applications, input/output (I/O) has been one of the main determining factors for overall performance. In the world of relational database, I/O can easily surpass all other considerations, particularly if an SQL...

Martin Hubel's profile image

Blog Entry
Machine Learning with IBM Db2: Building and Deploying a Linear Regression Model

In this demonstration, we’ll use a Jupyter Notebook from IBM Watson Studio to show how you can build a Linear Regression model inside Db2. We will use the GoSales dataset where the Machine Learning task is to predict the purchase amount for each customer based on demographic information and...

Les King's profile image

Blog Entry
Migrating a database using continuous rolling forward

In most traditional migrations towards a new environment, one will most probably come up with the most current ideas to get the job done, but what about migrating a multi-terabyte sized database with a minimal down time? First, we opted to set up HADR, but that would imply a second down time...

Eddy Coppens's profile image

Blog Entry
DBADM can maintain all database objects … but not really?

As many other I got challenged to set up a database architecture. Not only database objects related, describing the different environments was also asked and there was an urgent need for a decent security setup to support rollouts in general. First thing on my agenda was to move the...

Eddy Coppens's profile image

Blog Entry
SQL Tuning for Developers – Part 2 Explain Output

Introduction In Db2 the best way for any developer writing SQL queries to know how a query is gathering the data for a result set is through the Db2 explain tool. I find too many developers do not know what to do or where to start when it comes to SQL tuning, program tuning, or application...

Tony Andrews's profile image

Blog Entry
IDUG Tech Talk: Zen and the Art of Database Performance

Performance problems can be tough to solve, especially if you've not had to deal with them much before. In this session, we'll go through a step-by-step, decision tree-based approach for tackling performance problems. We start by identifying the core area of the bottleneck - is it time spent...

Steve Rees's profile image

Blog Entry
Implementing Logging in a DB2 Native SQL Stored Procedure

Introduction If you have ever done any development in the .NET or JAVA you may have been exposed to a logging utility from a company called Apache called log4net™, for more information there is a link at the end of this article. This is an open source logging utility which can be used to...

Blog Entry
IBM Cloud Data Services Introduces IBM DB2 on Cloud

IBM Cloud Data Services Introduces Infrastructure Flexibility with On-Premises Accessibility with IBM DB2 on Cloud, a Scalable Multi-Workload Relational Database The IBM Cloud Data Services team is happy to announce the introduction of IBM DB2 on Cloud, a hosted version of IBM’s famous multi...

Blog Entry
How Up to Date is Your IBM Data Studio? by Phil Nelson

At the time of writing (July 2015) the latest version of Data Studio is and it is common thinking that with that version installed that you have the latest public version of IBM Data Studio. Going into IBM Installation Manager and searching for updates would also give this impression,...

Philip Nelson's profile image

Blog Entry
Using Physical Data Models in IBM Data Studio - by Ludovic Janssens and Dan Luksetich

Why Data Studio? IBM’s Data Studio holds a lot of features that are not really commonly known by the DB2 audience. Many people regard it as the replacement of the old Control Center, but as such this isn’t true, as Control Center held features that are no longer in Data Studio and Data Studio...