IBM Db2 with BLU Acceleration is commonly used in warehouse environments to facilitate industry-leading analytical processing of data. This technology is composed of many valuable pieces, but two that we regularly highlight are extreme compression and advanced query performance. While both...
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...
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...
1 Comment - no search term matches found in comments.
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...
2 Comments - no search term matches found in comments.
IBM DB2 EN LA NUBE DE AMAZON AWS La nube se ha convertido en la nueva moda, los beneficios que brindan esta nueva infraestructura son bastantes, pero este no será el tema principal de este artículo, creemos que si estás aquí es porque ya tienen idea de estos beneficios. Actualmente son...
La historia de IDUG en México comenzó oficialmente el mes pasado en el día 22 de Agosto, en donde tuvo lugar el primer seminario organizado por IDUG y así, atraer a la comunidad de Db2 para unirse a la comunidad que IDUG ha estado promoviendo desde hace varios años, pero tal vez esta historia...
Here is Keri Romanufa with a presentation covering the architecture of Db2, including what is new with Db2 11.5 https://youtu.be/Lkr0Er IhV4
March Spotlight – Db2 Developer C If you are a serious Db2 user, chances are you have downloaded and used free Db2 versions for a few years. Db2 Express-C was a free way to learn Db2 on Linux, Unix and Windows, to practise and test your SQL skills and in later versions even implement or ship...
Dr. Michael Stonebraker's 10 fears about the future of the DBMS field Introduction The performance of Db2 depends on many things. It spreads from the application and the SQL, through the Db2 itself, down to the underlying system configuration. We can even expand it a bit more, I mean a...
Advanced Query Tuning with IBM Data Studio by Tony Andrews Do you make any New Year's resolutions? In case you don't have any Db2 related, we have a suggestion for you. What if you start the New Year with improving the performance of your SQL queries? Learn more about the advanced query tuning...