“IBM Data Retrieval Technologies : RDBMS, BLU, IBM Netezza and Hadoop” #IDUG Presentation

Posted by Frank Fillmore on November 18, 2014 under BigInsights, BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/OS, Hadoop, IDAA, International DB2 Users Group (IDUG), Netezza. Tags: , , , , .

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.

Countdown to: “IBM Data Retrieval Technologies : RDBMS, BLU, IBM Netezza and Hadoop” #IDUG Europe

Posted by Kim May on November 11, 2014 under Big Data, BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, Hadoop, IBM Champion, IBM Pure Systems, International DB2 Users Group (IDUG), Netezza.

Frank is doing his final preparation for today’s presentation at IDUG Europe – if you are lucky enough to be in beautiful Prague at the conference I hope you will stop by!

Session E7 on Tuesday, November 11 from 3:15 to 4:15 p.m.

Abstract:  IBM offers four distinct data retrieval technologies: the traditional RDBMS, which primarily relies on indexes to speed access; the new BLU Acceleration columnar compression database; IBM PureData System for Analytics (IBM Netezza), which deploys racks of Field Programmable Gate Array (FPGA) processors to parse the data; and IBM InfoSphere BigInsights, which is the IBM distribution of Hadoop. Choices are good to have, but how do you choose which technology to apply to a particular business use case? In this session, you learn how these techniques differ, including their relative strengths and weaknesses, to help you make an informed choice.

 

Join BFF’s at Insight

Posted by Kim May on October 9, 2014 under DB2 Education, DB2 for Linux Unix Windows, DB2 Migrations, Frank Fillmore, IBM Information Management Software Sales, Insight 2014, Oracle, pureScale, TFG Blog. Tags: , .

Excuse the corny wordplay – please!

IBM will again host the annual Break Free Forum (BFF) at the upcoming Insight Conference in Las Vegas (previously known as the Information on Demand Conference).  In addition to many terrific conference sessions, speakers and entertainment, the Break Free Forum is a 2-hour session dedicated to customers considering, and hopefully moving to, DB2.

Frank has been invited to participate on the panel at the Break Free Forum, which is quite an honor.  And, as Frank and I have had the pleasure to work with many of the talented IBM teams that support customers moving to DB2, we will be there with several BFF’s – including Amit Patel, Bill Kincaid and this year’s Break Free Forum host Paul Zikopoulos.

If you are planning to attend the Insight Conference and are interested in joining us at the Break Free Forum, please let me know.  I believe the session is invitation-only, but I am sure coordinator Angie Payton would be happy to send you an invitiation.

“The Top Three Reasons #DB2 is Best!” Webinar Materials

Posted by Frank Fillmore on September 29, 2014 under BLU Acceleration, DB2 for Linux Unix Windows, DB2 Migrations, IBM Champion, IBM Information Management Software Sales, IBM Mid Market Customers, Oracle, pureScale. Tags: , , .

Many thanks to my colleague, Kim May, and IBMer Bill Kincaid for an excellent presentation on DB2 for LUW feature/functionality and pricing advantages over competing offerings.  And thank you to the many IBMers and customers that attended.  We received great feedback from you during the poll questions and the Q&A.

To view the webinar click here.

The presentation materials are here: Top Three Reasons DB2 is Best Presention 9.25.14

The Top Three Reasons DB2 is Best! Webinar, 9/25

Posted by Kim May on September 15, 2014 under DB2 Education, DB2 for Linux Unix Windows, DB2 Migrations, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IBM Mid Market Customers, Oracle, TFG Blog. Tags: , , , , , .

Date:  Thursday, September 25, 2014

Time:  12:00pm – 1:00pm EDT

Register:  HERE

Every organization – current DB2 users and others – is under fire to deliver a flexible, reliable database solution to support business requirements.  In sixty minutes you will learn why DB2 10.5 for LUW is the best choice to support critical data management needs.  When someone asks, “Why DB2?” you will have 3 answers!

We will cover:

  1. Functionality: high availability with pureScale, maximum data compression, and query acceleration with DB2 BLU
  2. Success:  learn how current customers are leveraging DB2 to meet their objectives
  3. Pricing:  find the right fit with simplified purchasing options

Whether you are currently using DB2 and looking to better understand its features, or considering a move to DB2, please join us.

The webinar will be presented by IBM DB2 Competitive Sales Specialist Bill Kincaid and IBM Champion Kim May.

About the presenters:

Bill Kincaid is an IBM DB2 Competitive Sales Specialist.  Bill has worked for IBM, Microsoft and Oracle, as well as data virtualization solution developer xkoto.  Bill’s specialty is helping database users – customers currently using DB2 and customers considering migrating to DB2 – to fully understand the value of DB2.  Bill earned his BA at the University of North Carolina and his MBA from the University of Georgia.  He lives in Charlotte and works with IBM customers in the Eastern US.

Kim May is the Vice President of Business Development for The Fillmore Group and an IBM Champion for Information Management.  Kim coordinates The Fillmore Group’s software sales and consulting efforts, including migration support for customers moving workloads to DB2.  Kim’s experience includes several years supporting technical education, and she currently serves on the board of the Baltimore/Washington DB2 Users Group.

 

“IBM Data Retrieval Technologies : RDBMS, BLU, IBM Netezza and Hadoop” #IDUG Europe

Posted by Frank Fillmore on July 14, 2014 under Big Data, BigInsights, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, Hadoop, IDAA, Netezza. Tags: , , , , , .

From November 9 – 14 I will be visiting one of the most charming cities on the planet when I attend the International DB2 Users Group (IDUG) conference in Prague, CZ.  I will present “IBM Data Retrieval Technologies : RDBMS, BLU, IBM Netezza and Hadoop”.  It will be session E7 on Tuesday, November 11 from 3:15 to 4:15 p.m.  Please consider attending IDUG Europe and joining me at this session.

Abstract:  IBM offers four distinct data retrieval technologies: the traditional RDBMS, which primarily relies on indexes to speed access; the new BLU Acceleration columnar compression database; IBM PureData System for Analytics (IBM Netezza), which deploys racks of Field Programmable Gate Array (FPGA) processors to parse the data; and IBM InfoSphere BigInsights, which is the IBM distribution of Hadoop. Choices are good to have, but how do you choose which technology to apply to a particular business use case? In this session, you learn how these techniques differ, including their relative strengths and weaknesses, to help you make an informed choice.

Services – Available Help for the “tions”

Posted by Kim May on May 30, 2014 under Authorized Training Partner, Big Data, Data Studio, DB2 Connect, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Federation, Frank Fillmore, Hadoop, IBM Champion, IBM DB2 Services, IBM Pure Systems, IDAA, InfoSphere, InfoSphere Streams, MQT's, Netezza, Optim, Oracle, pureScale, Q-Replication, SQL Tuning, TFG Blog. Tags: , , , , , , , , , , , , , , , , , .

I was on a call this morning with an IBM technical team to discuss our progress filling the seats in one of our upcoming free IDAA classes.  Not surprising, given the number of people on the call (and who they were!) we went a bit off topic and ended up chatting about services and what appears to be – to IBM customers and sellers at least – a shortage of skilled consultants available to help with the “tions” – replication, implementations, migrations and federation.

The Fillmore Group has skilled consultants available to support these efforts, at rates that are typically about half of those being charged by “the competition”.

If your team has a project pending, or one in process, where a skilled consultant, at a reasonable hourly rate, can get things back on track, please contact me.  We are ready to work!  A list of our IBM Information Management capabilities is attached here.

 

Summary of DB2 and Q Replication Performance Tuning Techniques

Posted by Frank Fillmore on March 25, 2014 under DB2 for Linux Unix Windows, Q-Replication, SQL Tuning. Tags: , .

Performance tuning for both DB2 and Q Replication are an ongoing process.  However, there are three tools which provide an initial set of recommendations for bufferpools, Database Manager (DBM or instance) and database configuration parameters, indexes, and other application table objects.

 

DB2 Configuration Advisor

The DB2 Configuration Advisor recommends the initial values of the bufferpool size, database configuration parameters, and database manager configuration parameters.

To use the Configuration Advisor, specify the AUTOCONFIGURE command for an existing database, or specify AUTOCONFIGURE as an option of the CREATE DATABASE command.

Example:

db2 autoconfigure using mem_percent 50 num_stmts 100000 tpm 6000 admin_priority performance num_local_apps 144 num_remote_apps 0 isolation UR apply none

DB2 Design Advisor

The DB2 Design Advisor is used to improve application SQL performance by creating (or dropping) indexes, Materialized Query Tables (MQTs), and MultiDimensional Clustering (MDCs).  The Design Advisor analyzes an SQL workload against existing table structures and recommends changes to improve performance.  The workload can be derived from Dynamic Statement Cache (DSC).  The DB2 Design Advisor command can be invoked by the db2advis command.

A prerequisite is creating the DB2 EXPLAIN tables for the schema conducting the analysis.

cd /<path>/sqllib/misc

db2 –vtf EXPLAIN.DDL

Then run the db2advis command.

db2advis -d mydb -g -a myuser -x -c USERSPACE1 -f -m IMCP -o db2advis_output

 

Q Replication Dashboard Performance Advisor

The Q Replication Performance Advisor helps you identify latency issues with your replication environment and suggests ways to lower end-to-end latency.  The Performance Advisor tab is located within each Monitoring Group.  The Q Replication Dashboard Performance Advisor can recommend updating statistics or reorganizing tables.

BLU Acceleration – One Size Fits Most (Well)

Posted by Kim May on March 17, 2014 under BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/OS. Tags: , .

DB2-L had some interesting and (always!) entertaining discussion recently about the process of performance tuning for DB2 for LUW vs. DB2 for z/OS.  After a bit of spirited debate Leon Katsnelson posted an analogy explaining the evolution of DB2 BLU.  It’s perfect.  Enjoy it below.

Leon Katsnelson DB2-L Post 3/17/14:

At some point in time, not too long ago the only way to get a well fitting suit was to go to a tailor. Tailor would measure you up and after a few fittings you would get a suit that was, well, tailor made for you. Nobody, and especially not me, would argue that this is the best way to get a great fitting suit. However, most of us could not afford a tailor made suit. But most of us can go to a mall and pick up a great Boss suit for, say $600, off the rack. What the fashion industry has done is deliver high fashion to everyone. Some designers argued that it could not be done as did many custom tailors. Now, high end designers have not disappeared and I get calls and emails from custom tailors who still make the best fitting suits … for a price.

BLU Acceleration for Cloud is high end data warehousing for everyone the same way a $600 Boss suit is a high end suit for everyone. Many have told us it can’t be done. Well, we did it. The cloud allowed us to take the cost of the hardware off the table. It also allowed us to create configurations which just like suit sizes fit most people. BLU Acceleration technology removed indexes, reorgs etc., and does not even give one a choice to disable compression and other features.  It removed the need and in some cases even ability to decide on some aspects of the system. Fewer decisions make it much easier to run. For many, BLU Acceleration is as close to the load-and-go system as you can get. BLU Acceleration for Cloud went even further by integrating BI tools (Cognos BI), pre-engineered schemas and reports (3 Warehouse Packs) and we are working hard on making sure that getting data in to the warehouse is brain dead simple. Can you create a better performing data warehouse by hand tuning DB2? Yes you can. But can you make one available to your end-user to run themselves in less than an hour and for less than $1/hr? That is what BLU Acceleration for Cloud does. We are betting that there are lots of people who could use data warehouse capability if it was easy and affordable. We intend to help these people, regardless of their skill or budget, get value from the IT technologies that for too long have been out of reach. For these people, cloud is the only path and technologies like BLU is the only future.