Blogs

Be the first person to recommend this.
Today's Member Story features Mateja Jankovič! Mateja works with Informatika d.d. as a senior solution designer, and IBM Champion. Here are a few rapid fire questions and Mateja's replies: Can you explain what you do? Mostly I work on BI & data warehouse projects. Do you play sports? I like skiing, hiking, cycling– spending time in nature. I was born under the mountains and as a teenager I spent many winter weekends skiing in the mountains ski ground nearby. Now I mostly go skiing to the ski ground half an hour away from my home. Slovenia where I live gives us nice opportunities for hiking. What is something we may not know about you? In the summer ...
0 comments
1 person recommends this.
by Shaikh Quader Many Data Scientists start their machine learning (ML) projects on an open-source stack installed on their laptop. They load a comma separated value(csv) file into a Python Dataframe, explore and clean the data, engineer new features, build and tune a few different models, and finally, choose the best model. This mode of machine learning is not an option for enterprise-grade machine learning with massive data. If your dataset fits into any of the following domains, you probably have large data and the challenges that come with it. IBM Db2, equipped with in-database machine learning capabilities, can help enterprises learn from data at scale. ...
0 comments

Ian Bjorhovde, XTIVIA

Be the first person to recommend this.
Today's member story features Ian Bjorhovde! Ian is an IBM Gold Consultant and the Db2 Team Lead at XTIVIA. Here are a few rapid fire questions and Ian’s reply: Who is your favorite team? I love the Red Sox, but before 2020 you could also find me at many DBacks games. FUN FACT: Ian has visited 20 of the 30 MLB parks! Do you have any pets? I’ve got 2 cats, but my home office has become something of an animal refuge – I share it with a tortoise and a hare (literally) Coffee, tea, or other? I’ve been called a coffee snob more than a couple of times. In the before times, I would seek out great local coffee shops in the places I’d travel to for work or ...
0 comments

Les King, IBM

Be the first person to recommend this.
We're excited to start our new series "Member Stories". We'll take a few moments to interview IDUG members. You might be surprised by how much you have in common! Today's Member Story features Les King! Les is IBM's Director of Hybrid Data Management Solutions & a part-time professor at a Canadian college in Toronto. Here are a few rapid fire questions and Les's replies: Who is your favorite team? Toronto Maple Leafs (hockey!!) 🏒 What is your favorite meal? 🦞 Surf & Turf—bone-in ribeye and shellfish Do you play an instrument? Piano and electric guitar (poorly) Do you have any pets? Black lab, a COVID dog 🐾 Got him as a puppy when we ...
0 comments
1 person recommends this.
Tis the season! Hard to believe we are rounding the corner, and this year is about to end—relief? We hope! It has certainly been a trying year and one we will not forget. We, like so many, have experienced a few hardships, yet one must step back and think about all the good things that came out of this year. I, for one, am incredibly grateful for the extra time we got to spend together as a family. It has been years since our boys have been in the same country, state, city, or house for that matter, for any length of time. This year provided us the opportunity to reconnect and really communicate with each other while living and working together under one ...
0 comments
Be the first person to recommend this.
After shifting this year’s IDUG EMEA Db2 Tech Conference from an in-person event to a virtual platform, the Conference Committee was interested to see how the IDUG experience would translate to the screen. With more than 750 attendees and speakers from around the globe, the event brought the Db2 community virtually together for deep explorations of the technology as well as a look ahead to the future. As always, the generous and collaborative spirit of the IDUG community was out in full force. Although we missed having everyone together in person, we were so impressed with the enthusiasm from both attendees and speakers. As usual, the caliber of the technical ...
0 comments
2 people recommend this.
This topic comes from a presentation at IDUG EMEA from Marcel Scheibe that was a part of many topics in his presentation. I thought it was appropriate for SQL Tricks topic. Thanks Marcel! Often times we have all seen duplicate rows in table data that occurred thru some incorrect SQL or program logic. In this example the timestamp column makes up part of the composite key along with the employee number. So how do we delete the duplicates? Write a program and order the data through a cursor by primary key and execute deletes ? Write a single SQL statement to fix the problem? That is what this article is about. 1) Table of data with ...
1 comment
Be the first person to recommend this.
My Seven Magic Years on the EMEA CPC It's autumn and one of the best events is approaching—IDUG EMEA! As a member of the Conference Planning Committee I was involved in the organization of these events for seven years—an unforgetable journey from conference to conference with seven great teams (hello to all my colleagues) . What drives me to be so involved in IDUG as a volunteer? First, I like the energy I feel in the community. It's always inspiring to collaborate with people who like to learn and share knowledge. It's a lot of work, but also a lot of fun. In my experience most of us developed real frienships with folks ...
0 comments

November President's Letter

Be the first person to recommend this.
This past weekend as we set the clocks back for daylight savings, we shifted how light will move through our days. Suddenly night is setting in much earlier and winter feels like it’s right around the corner, if it’s not already here. Although this shift can be a bit hard on the psyche, I think it provides an opportunity to clarify our priorities. With less daylight, we must identify what’s most important to us. Plus, the darkness can inspire us to find the ways we can bring more light into our lives and the lives of those around us. Here at IDUG, we are always focused on the question of how we can best be a source of light for the global Db2 community. ...
0 comments
4 people recommend this.
by Tony Andrews ( @Tony Andrews ) SQL tricks is a rather broad term, and these articles are really about a number of unique / different things that can be done in the SQL programming language that hopefully readers can learn from and possibly use. There are so many in our Db2 industry that are very skilled in the SQL language and many of the examples provided in all of these articles came from them. This article focuses specifically on SQL recursion and pivoting of data from rows to columns. 1) SQL RECURSION Developers have probably used this recursion especially with hierarchical or bill of material tables to dig down within a hierarchy like employee ...
3 comments
1 person recommends this.
With the IDUG EMEA Db2 Tech Conference right around the corner, we caught up with the Conference Planning Committee for some insight about everything the event has in store and what the planning process has been like. Whether you are a first-time attendee or a long-time IDUG member, the team shares some tips that will help you make the most of your conference experience. As a user-driven organization, IDUG puts the emphasis on technical content, which means all the sessions on the agenda have been hand-picked by a group of professionals who are incredibly knowledgeable about the technology. “We have great technical content ...
0 comments
Be the first person to recommend this.
The IDUG team has been busy preparing for the launch of our new website, which will go live next week. We're excited to introduce a new platform with better functionality and more opportunities to engage. Please note that due to the migration, any new forum posts between tomorrow ( Thursday October 22 ) and the launch of the new website may be lost. We'll be in touch soon with more info on the new platform and a tutorial for all the new features
0 comments
Be the first person to recommend this.
The season has started to change here in Cleveland; the trees are turning vibrant reds and oranges, temperatures are dipping low, and it is becoming chilly. It is a reminder to all of us that time moves on and we must adapt to changes in our personal lives as well as with technology and what IDUG can offer to our members and our future. We had a month of change and celebration as my wife and I celebrated our 33 rd wedding anniversary, our oldest son moved to his first apartment, completely independent of us, our youngest son is thriving at the University of Cincinnati, and my wife started a new job after four months of unemployment due to the trade show industry ...
0 comments
2 people recommend this.
When you’re starting out with Data Science and you’re building your skills, sooner or later you’ll want to play with Anomaly Detection, and the first thing you’ll see when you look it up is the number of ways you can begin exploring the topic. We can name some of the general approaches to Anomaly Detection by category (or complexity): Basic exploratory work. Here we see familiar examples like a histogram, or a convenient box plot. Statistical tools (also coming from exploratory tools). Interquartile range and z-score are usually known examples. Machine learning. You will find both supervised and unsupervised algorithms. A common example is k-means clustering. ...
0 comments

Db2 Client Packages

Be the first person to recommend this.
Connecting to Db2 remotely means the use of a client. Sometimes that client is installed software and other times it is as thin as a JDBC driver. In any event, a client talking to a Db2 server will invoke one or more bound packages on the server side. The source for these packages is supplied by IBM with the client software and must be bound against each target Db2 server. Some of these packages are version-specific and others are not. All client packages are bound in a collection called NULLID by default. Read the complete article here: https://www.idug.org/browse/blogs/blogviewer?BlogKey=65cc65f1-6dd0-4a44-b2dd-87519d4ccde
0 comments
1 person recommends this.
Index Compression has been available in Db2 since Version 9. But my impression is that it is under-utilized out in the real world. What is index compression? What is the benefit? Why should it be considered? Read the full article here
0 comments
Be the first person to recommend this.
It is hard to believe that fall is already upon us and kids are headed back to school whether in person, hybrid, or online. Families are challenged with the added stress of working from home or at the office and managing day to day family life and their children’s educational needs. In my home, we are also experiencing the joy and strangely, the stress, of our son going back to the University of Cincinnati. There is constant concern that we will be receiving notice that he has been exposed or has tested positive for COVID-19, which is always on our minds. Social distancing amongst college students is extremely hard to manage but they are trying to get back to ...
0 comments
2 people recommend this.
When the IDUG team decided to shift its marquee North America event to a virtual platform, it meant reimagining the whole conference experience for attendees, speakers, and vendors. As we changed plans, we kept the IDUG mission at the forefront of our thoughts. We wanted to deliver the quality technical education IDUG is known for without sacrificing the sense of community. We wanted to make space for deep exploration into complex topics while giving attendees a chance to interact with expert speakers and our industry partners. Luckily, the shift to a virtual model gave us the chance to do all of this for a record number of attendees. Over 1,100 people joined ...
0 comments
1 person recommends this.
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 of these features are extremely valuable, they are also tightly coupled. In many cases, the amazing query performance is directly tied to the level of compression for the column-organized tables involved in the queries. For this reason, it is critical to maximize compression for column-organized tables in order to significantly improve query performance. This ...
0 comments
Be the first person to recommend this.
Native macOS client applications require the installation of a Db2 client package. For Java-based applications, you only need the Db2 JDBC JAR files, but those are not packaged separately. In order to support native Java and other applications on macOS, you need the IBM Data Server Driver Package. Read the full article here
0 comments