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.

 

Changing the Hostname for a DB2 Server – An Update

Posted by Frank Fillmore on February 7, 2014 under DB2 for Linux Unix Windows, DB2 Migrations. Tags: , .

Probably my most popular blog post of all time – certainly the one most commented upon – was called Changing the Hostname for a DB2 Server.  If you work in a shop that uses the same image (i.e. a Windows backup, VMWare image, or some other form of snap-shotting a Windows computer) containing DB2 for LUW for multiple implementations you will have run into a problem.  When changing the “Computer name” or hostname, the DB2 instance fails to start with an SQL1042C error.

I won’t repeat the entire blog post here – that’s why I included the link above – but I do need to post an update on the location of the important db2nodes.cfg file.  The db2nodes.cfg file now (in DB2 version 9.7) resides in the instance directory.  On a default Windows DB2 installation, that would be x:\ProgramData\IBM\DB2\DB2COPY1\DB2

Please be sure to follow the rest of the instructions on the original post to clear the SQL1042C error.

Big Data Classes at The Fillmore Group

Posted by Kim May on February 6, 2014 under Arrow ECS, Authorized Training Partner, Big Data, BigInsights, DB2 for Linux Unix Windows, DB2 for z/OS, Hadoop, InfoSphere Streams, TFG Blog. Tags: , , , , .

With IBM’s 2014 focus on Big Data solutions I want to highlight The Fillmore Group’s IBM authorized training classes coming this Spring – and invite new BigInsights and Streams customers to join us.  We have students enrolled and expect these sessions to run as scheduled.

All classes may be attended either in our classroom in Towson, Maryland, or remotely via distance learning.

Feb 26 DW652  IBM BigInsights Analytics for Programmers      2 days; $1500

Mar 17 DW723  Program for InfoSphere Streams V3 with SPL   4 days; $3000

Mar 21 DW730  Administration of InfoSphere Streams                 1 day; $750

Apr 2   DW641   BigInsights Analytics for Business Analysts        1 day; $750

If you are interested in learning more click on the course code above for the complete outline of topics to be covered and registration information.  If you have any questions on these classes or other training classes available from The Fillmore Group please contact me here.

One note:  these classes are being delivered through The Fillmore Group’s affiliation with Global Training Provider Arrow ECS; you will need to register for classes on the Arrow website.

Thanks!

TFG and Arrow Bring Back Training with a BANG! #ibmiod

Posted by Kim May on November 2, 2013 under Arrow ECS, Authorized Training Partner, BigInsights, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, IBM Training Services Delivery Partner, InfoSphere, Q-Replication. Tags: , , , , .

To everyone joining us at IOD, I invite you to stop by Arrow ECS’s booth in the Expo, #1309, to pop a balloon and possibly win a valuable training class prize – or an iPad!  Arrow ECS is one of the four new IBM-selected Global Training Partners, and in addition to being The Fillmore Group’s software distributor, Arrow is the partner TFG has aligned with to continue to deliver IBM Authorized Information Management classes.

To qualify to win you must stop by the booth and pop a balloon.  Special prizes are in *some* balloons.  Good luck!  Let’s get IBM IM training restarted with a BANG!

TFG (Finally!) Offers Training Again

Posted by Kim May on October 8, 2013 under Authorized Training Partner, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, IBM Training Services Delivery Partner, Q-Replication, TFG Blog. Tags: , , , , , , , .

This past summer IBM rolled out the Global Skills Initiative, essentially outsourcing all education marketing and delivery to four selected Global Training Partners.  IBM will continue to develop course curriculum, but everything else is now in the hands of the four Global Training Partners, or GTP’s.

The Fillmore Group has aligned with Global Training Partner Arrow ECS, our software distributor, and I am pleased to finally be able to announce that we are back in the training business.

There are still challenges.  Two of the biggest are the process of finding our classes on the IBM training site and actually registering for a class.  While I work through this process so I can update our website with accurate information, I am going to post our schedule in as many places as possible (right here for starters), and invite anyone in search of an IBM class to contact me if you need help.  Public classes, private classes, in the classroom or remote – please don’t hesitate to email me.  I want to help!