IBM hosted the inaugural TechXchange Conference in Las Vegas last week (September 11 – 15, 2023). Here’s what I liked:

• The Developer community was the primary focus of TechXchange. This is a significant change from the pre-pandemic IBM technical conferences – Think and World of Watson (sited variously in Las Vegas and San Francisco). Two of the TechXchange keynote presenters pointed out that there were no “suits” at the conference (in reference to both people and apparel).
• Artificial Intelligence (AI) was (not surprisingly) given a shout-out in almost every keynote, but I thought the most prescient comment was that in three years Quantum Computing will be where AI is today.

Lakehouse

• Since I’m a career database administrator (DBA) I am really jazzed about IBM’s Lakehouse approach to data. For decades IBM was primarily focused on IMS (hierarchical) for large-scale online transaction processing (OLTP) and Db2 (relational) for analytical workloads (and, eventually, OLTP too).
• IBM made a brief foray into Data Lake (vast amounts of unstructured or semi-structured data with varying standards of curation) with its BigInsights Hadoop distribution.
• But Lakehouse is the combination of traditional shared-nothing MPP IBM Db2 Warehouse (relatively structured with higher levels of curation, consistency, and veracity) and watsonx.data an open source stack of data repositories: Lake + House.

Key characteristics of Lakehouse:

1. Let the data decide where it should reside. Based on data attributes such as volume, structure, quality, timeliness, etc. choose the data repository that best addresses those attributes. You no longer have to force data into a repository where it’s not best-suited.
2. Seamlessly access data regardless of how and where it’s stored.
   1. Data Scientists can easily combine customer account data, transaction history, and sentiment analysis.
   2. An Auto Repair Technician can pull up vehicle history by Make/Model/Trim/Year, geography, mileage, and so forth on a tablet in a garage bay while the car is on the lift.
3. Ever increasing data storage costs have your CFO in a frenzy? Performant Object Storage will likely meet your response-time targets for most applications – at about 3% of the cost of Block Storage. Automated multi-temperature storage enables you to transition data to the storage platform most suited to its age, likelihood of being retrieved, and other factors.
4. On-prem, in the cloud, or SaaS? You decide where – and by whom – the infrastructure underpinning your OLTP and analytics workloads are provisioned.
5. Containerization enables scaling that infrastructure as required by both cyclical and black-swan events.

A much more detailed dive into Db2 Warehouse Gen 3 and watsonx.data will be in an upcoming blog post.

I am excited to announce two upcoming events The Fillmore Group will deliver in April.  Stay tuned for dates and locations!

Woodberry “DB2 101” Luncheon

Join DB2 Gold Consultant Frank C. Fillmore, Jr., for a sprint through IBM Analytics’ 2016 data management solutions portfolio. From today’s hottest topics – HTAP, Hadoop and Cloud – to the specific IBM solutions behind the buzzwords, Frank will deliver an overview of how IBM has built, acquired and integrated data management solutions to enable customers to accomplish their organization’s goals. Is this, “the more things change the more they stay the same”, or an inflection point for data technology? You be the judge!

Free Hands-on IBM DB2 Analytics Accelerator (IDAA) April Class

IBM’s 2012 announcement of the IBM DB2 Analytics Accelerator – the IDAA – the Netezza/mainframe hybrid, delivered IBM’s first Hybrid Transaction/Analytics Processing (HTAP) solution. Now, after 3 years and multiple enhancements, the IDAA continues to promise great things for IBM DB2, VSAM and IMS customers. According to our calculations, 90% of IBM System z customers don’t own an IDAA yet – and we think everyone should have one! Join us for this free, 2-day, hands-on, technical introduction to learn how an IDAA can benefit your System z shop.

I only spoke with Steve Mills a couple of times and attended presentations he delivered at conferences a few others, but he has had an enormous impact on my career.  Steve was the executive sponsor of the DB2 Gold Consultants program, of which I have been a member since 1998.  Steve recognized that specialized, deep technical skills were imperative to enabling the adoption and successful deployment of IBM’s world-class, function-rich – but let’s face it: enormously complex – information technologies.  Through the DB2 Gold Consultants program, Steve cultivated a cadre that were not only among the best DB2 practitioners, but foremost in the world in relational database technology in general.  Folks like Richard Yevich, Bonnie Baker, Frank Ingrassia, Terry Purcell, Jan Henderyckx, and Gerry Hodge.  I am humbled to be numbered among them.

For years IBM would sponsor a week-long DB2 Gold Consultants conference, usually at Silicon Valley or Toronto Lab.  Dozens of presenters including IBM Fellows like Pat Selinger, Don Haderle, Don Chamberlin, Hamid Pirahesh, and Curt Cotner would tell us about broad industry trends and specifics regarding features and functions in vNext, vNext+, and vNext++.  It was an amazing feast of insight which enabled me to better serve my clients.  None of that would have happened without Steve’s leadership.

An even more critical and direct aspect of Steve’s support was his sponsorship of contracting vehicles for DB2 Gold Consultants which enabled us to engage directly with IBM without having to add additional layers of third-part procurement.  He understood the practical problem of small businesses and sole practitioners trying to navigate a large, cumbersome bureaucracy.  One time I explained to Steve that even with the contracting vehicle in place, IBM buyers occasionally refused to use it.  His response was “Sometimes the inmates are running the asylum”.  I didn’t hear anything for a couple of weeks and then I received a call from a senior IBM procurement officer who introduced himself by saying: “Hi, I’m one of the ‘inmates'”.  Of course, the problem was resolved.

Steve Mills, the quintessential old-school “wild duck” IBMer, will be missed.

One result of the IBM Global Skills Initiative is the complexity around course scheduling and registration as there are now five Global Training Partners managing these processes.

The Fillmore Group is aligned with our software distributor, Arrow ECS, for IBM Analytics training delivery.  Through our relationship with Arrow we deliver public, open enrollment IBM Analytics classes in our Towson, Maryland, classroom, as well as distance learning, remote classes, and private classes.

Finding our classes on the Arrow website can be a challenge, but there are two ways to do this.

#1   Click here for classes scheduled for the next 60 days

This link will take you to the pre-sorted courses scheduled to run at The Fillmore Group in the next 60 days.

#2   Visit the Arrow ECS website and sort courses

If you would like to review the courses delivered by The Fillmore Group in Towson as well as courses delivered by other Arrow affiliated vendors in other locations, follow these instructions:

1. Click on https://ecsedu.arrow.com/ibm/us
2. At the top of the screen hover over or pull down “Scheduled and Distance Classes”
3. Click on “Training schedules”
4. Select “United States”
5.  In the list of locations, De-select “All”, then check “Towson”
6. Select “6 months” for the time period to display
7. Answer “No” to the “Show Only Guaranteed to Run” question
8. Select “All” for topics, hardware and software
9. Click the “See” button to display the classes

You should see a list of classes scheduled displayed like this.  The schedule contains dates and hyperlinks to register for individual sessions.

I hope this helps!  If can answer any questions on locating classes or navigating through to fjnd what you need, don’t hesitate to email (kim.may@thefillmoregroup.com) or call (443-956-0288) me.

In this session I described and compared the four distinct data retrieval technologies available from IBM.

Choices are good to have, but how do you choose which technology to apply to a particular business use case? Learn how these techniques differ, including their relative strengths and weaknesses.
– The traditional RDBMS, relying primarily on indexes to speed access
– The new BLU Acceleration columnar compression and memory-optimized database
– IBM PureData System for Analytics (Netezza), which deploys racks of Field Programmable Gate Array (FPGA) processors to parse data
– IBM InfoSphere BigInsights,  the IBM distribution of Hadoop

Click here for the recording of the webinar.  The presentation materials: IBM Data Retrieval Technologies RDBMS BLU Netezza and Hadoop

Congratulations to Frank on the selection of his 2015 Insight Conference presentation!  Frank’s presentation (session #3584 for those of you already  working on your schedules) is titled, “DB2 ^ (Netezza | BLU) = Hybrid Transaction and Analytics Processing (HTAP)”.

As soon as the Insight schedule is released I will update this post with the session date and time.  Stay tuned!

In his session Frank will describe and compare the four distinct data retrieval technologies available from IBM, including two Hybrid Transaction and Analytics Processing (HTAP) platforms. Choices are good to have, but how do you choose which technology to apply to a particular business use case? Learn how these techniques differ, including their relative strengths and weaknesses.

– The traditional RDBMS, relying primarily on indexes to speed access

– The new BLU Acceleration columnar compression and memory-optimized database

– IBM PureData System for Analytics (Netezza), which deploys racks of Field Programmable Gate Array (FPGA) processors to parse data

– IBM InfoSphere BigInsights, the IBM distribution of Hadoop

Bio
DB2 Gold Consultant and IBM Champion Frank C. Fillmore, Jr. is the Founder and President of The Fillmore Group, Inc., a Premier IBM Business Partner that specializes in IBM Analytics software sales, consulting, and training. Frank has been providing IBM Information Management solutions to government, industry, and not-for-profit enterprises as varied as The World Bank, J.P. Morgan Chase, Northrop Grumman, and the FBI for over 28 years. Frank’s current practice centers on Hybrid Transaction and Analytic Processing (HTAP) and Oracle to DB2 migrations as well as information governance and integration. Frank kayaks and cheers for the Baltimore Orioles.

I am excited to invite IBM data management users to join DB2 Gold Consultant Frank C. Fillmore for a series of three webinars covering the latest IBM database strategies.  Each session highlights a topic critical to IBM data management customers’ knowledge of the many, sometimes competing, often confusing, options available from IBM.

The content will help data architects better understand the latest solutions available to support analytic and OLTP workloads, as well as IBM’s data strategy direction and where today’s solutions – relational databases, Netezza and Hadoop – are best applied.

Attend one webinar or join us for all three.  Each one hour session will provide a wealth of clear, useful information.  Click on the links below to register.

#1  IBM DB2 Analytics Accelerator v4 PTF 5 Enhancements
Tuesday, June 9, 2015, 1pm-2pm EDT  Register here:  https://attendee.gotowebinar.com/register/5384878354738776577
Frank will present an update on the latest IBM DB2 Analytic Accelerator (IDAA) PTF released in April, 2015. This PTF delivers new functionality to extend IDAA utilization for DB2 for z/OS users including:
– Improved Incremental Update reliability and performance
– Accelerated dynamic query statement caching
– Additional scalar function support
– In-database transformation with Accelerator Only Tables

#2 IBM Hybrid Transaction/Analytic Processing (HTAP)
Tuesday, June 20, 2015, 1pm-2pm EDT  Register here: https://attendee.gotowebinar.com/register/5118968064636087810
Learn how customers are using HTAP to eliminate analytic latency and data synchronization issues to transform and simplify information management infrastructure. For years IT customers have been told that online transaction processing (OLTP) and analytics couldn’t co-exist on the same platform. This led to costly and complex regimes to move OLTP data to a different platform for analytics. With HTAP, the barriers to near real-time analytics are removed amid significant reductions in IT expenses and complexity risk.

The concept of Hybrid Transaction/Analytic Processing was coined by Gartner. IBM implements HTAP in two ways:
– IBM DB2 Analytics Accelerator (IDAA) for DB2 for z/OS data (using Netezza hardware)
– DB2 BLU Acceleration – DB2 for Linux, Unix, Windows (a software-only implementation)

#3  IBM Data Retrieval Technologies:  RDBMS, BLU, Netezza and Hadoop
Tuesday, July 21, 2015, 1pm-2pm EDT, Registration here:  https://attendee.gotowebinar.com/register/1762449336105853441
In this session Frank will describe and compare the four distinct data retrieval technologies available from IBM.  Choices are good to have, but how do you choose which technology to apply to a particular business use case? Learn how these techniques differ, including their relative strengths and weaknesses.
– The traditional RDBMS, relying primarily on indexes to speed access
– The new BLU Acceleration columnar compression and memory-optimized database
– IBM PureData System for Analytics (Netezza), which deploys racks of Field Programmable Gate Array (FPGA) processors to parse data
– IBM InfoSphere BigInsights,  the IBM distribution of Hadoop

Registration for each webinar is required.  To register, click on the session registration links above.  I hope you will join us!

The Fillmore Group 2H 2015 Class Schedule

With all the challenges IBM’s move to the Global Skills Initiative (aka outsourcing education) has created for DB2 users, please remember IBM classes do still exist and are available for the patient and persistent.  Fear not!  If you need training, we are prepared to help.

After seeing public training nosedive over the past two years we are now seeing a bit of a resurgence.  Are classes really running?  Well, in all honesty, not often.  However, we are seeing a few run here and there, and when they don’t, with our relationship with Arrow ECS (one of the five Global Training Partners) intact, we are learning to “collect” students interested in training, and either gather them together for classes, or provide private training at affordable rates.

I’ve just submitted our second half of 2015 public training class schedule to Arrow (see the attachment above) and expect to see the classes posted on the IBM training site (IBM.com/training) within the next couple weeks.  I welcome anyone looking for a class – whether it’s on my schedule or not – to contact me at kim.may@thefillmoregroup.com so that I can work some coordination magic for you.

We are looking forward to continuing our relationship with IBM Global Training Partner Arrow ECS is 2015.  Our schedule is up on the IBM training website, with the specific Arrow/The Fillmore Group classes listed and available for registration at:  https://ecsedu.arrow.com/ibm/us/index.html.

If you plan on taking a class early next year, I hope you will consider attending one of our classes, delivered in Towson, Maryland, just north of Baltimore.  We have great instructors, a comfortable classroom, and Baltimore offers some the best seafood in the world.

The complete list of classes is here.  I hope to see you in 2015!

The trip to Prague, CZ last week for the International DB2 Users Group meeting was fabulous.  The city certainly has changed since I’ve been there – all for the better.  It seems more cosmopolitan, the people seem younger, more vibrant than I remember from 2004.  And the dining and music – Kim and I attended jazz and classical music concerts and enjoyed Madame Butterfly at the Prague State Opera – were amazing CutterWelderMaestro.

Here’s my pitch on “IBM Data Retrieval Technologies” if you weren’t able to attend.  IDUG EMEA 2014 E7 – IBM Data Retrieval Technologies – RDBMS BLU IBM Netezza and Hadoop

Next year IDUG EMEA will be in Dublin.  Hope you can join us for a Guinness by the River Liffey.