“Sick of Oracle? Break Free!” Webinar Recording

Posted by Frank Fillmore on June 27, 2013 under BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 Migrations, IBM Information Management Software Sales, Oracle, pureScale. Tags: .

The materials for yesterday’s webinar detailing the reasons to consider migrating from Oracle to DB2 are found here: Break Free from Oracle Presentation 6.26.13

The recorded webinar is found on ChannelDB2.

Central Ohio DB2 Users Group (CODUG) Inaugural Meeting on June 25th – Join Us!

Posted by Frank Fillmore on June 13, 2013 under Big Data, BigInsights, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, Hadoop, IBM Champion, IBM Pure Systems, IDAA, InfoSphere, InfoSphere Streams, International DB2 Users Group (IDUG), Netezza, Optim, Oracle, Q-Replication. Tags: .

From my colleague, Jim Herrmann:

The Central Ohio DB2 Users Group (CODUG) no longer exists, but we are taking action to bring it back as a tremendous resource for the community and an amazing opportunity for leadership. CODUG is going to be a great DB2 regional users group because the members of the central Ohio DB2 community are going to make it so.

We are going to start out with all of you being a valuable contribution to your community by completing the RSVP for the June 25th, where you will have the ability to choose the presentations that you want to see from our amazing speakers. Use the URL below:


The short URL above links to a Google Docs form, which some company firewalls block, in which case you will need to make the extra effort of forwarding and filling out the form from home. Your input is essential to the success of the group. Whether you are planning to come on 6/25 or not, please fill out the form with your information and your vote. It’s free and it puts you in direct communication with the new CODUG!

You would be a further contribution to your friends and coworkers who have built their careers around DB2, on any platform, if you forward this message to them to make certain that they know about this amazing kickoff meeting. Don’t worry about them getting multiple copies, worry about them getting none. Forward this message now, while you’re thinking about it. If you wait, you will forget to do it later, and you will have missed the chance to connect someone to their community.

The meeting will be formatted with a single track in the morning and two tracks in the afternoon, one for DB2 z/OS and one for DB2 LUW. We will actually physically split the room at the lunch break. We have three well known names in the world of DB2 who will be presenting at the meeting. The bios of these three awesome individuals you can find after the attached agenda.

We are building towards an amazing day. Fill out the form, share it, and we will be one step closer to creating something powerful in our lives.

Thank you for your time and your commitment to DB2,
Please don’t forget to join us at Facebook and Linkedin to get to know about future activities at CODUG.
Linkedin group:  http://www.linkedin.com/groups/CODUG-Central-Ohio-DB2-Users-5014603/about
Facebook page: https://www.facebook.com/CODUG

09:00 – 09:30    CODUG Possibility (Jim Herrmann)
09:30 – 10:00    IBM Announcements (Monte Bauman)
10:00 – 10:15    Break
10:15 – 11:30    “DB2 101” or “I didn’t know IBM Information Management could do that!” (Frank Fillmore)
11:30 – 12:45    Lunch
12:45 – 14:15    First afternoon presentation block (Scott Hayes and Robert Catterall)
14:15 – 14:30    Break
14:30 – 16:00    Second afternoon presentation block (Scott Hayes and Robert Catterall)

Frank C. Fillmore, Jr., DB2 Gold Consultant and IBM Champion, is the Founder and President of The Fillmore Group, Inc., a Premier IBM Business Partner that specializes in Information Management (IM) software sales, consulting, and training.  Frank has appeared on the IDUG Experts Panel and frequently presents to customers and local DB2 users groups.  Franks 25 years of field experience spans IBMs Information Integration, Data Governance, Data Warehousing, and Big Data portfolios. Read More…

#BigData Bytes Recording with @TheSocialPitt, @thomasdeutsch, and @ffillmorejr

Posted by Frank Fillmore on May 20, 2013 under Big Data, IBM Champion. Tags: .

David Pittman, Tom Deutsch, and I had a lively – think ESPN’s “Pardon the Interruption” – big data discussion on a Google+ hangout Friday, May 17, 2013.  Topics ranged from governance and “schema on read” to what would be your BigData tattoo.  Spoiler: mine would be “There’s no single version of the truth”.

Catch the replay here.

Keeping it in the Family: Batch Movement of Data Between DB2 Databases and/or Subsystems

Posted by Frank Fillmore on May 15, 2013 under DB2 for Linux Unix Windows, DB2 for z/OS. Tags: , .

A few weeks ago a customer was confronted with a common challenge.  They had to move terabytes of data – billions of rows – from DB2 for LUW to DB2 for z/OS.  I suggested a “cursor-based load” (aka the “cross-loader”).  This DB2 for z/OS DBA team is top-notch, with centuries of collective experience, but I mostly was met with blank stares.  So here’s the brief refresher (or introduction) I gave them on the cross-loader.

The common method for moving data from DB2 for LUW tables to DB2 for z/OS could be a serial process where the data is

  1. extracted from DB2 for LUW
  2. transported to the z/OS platform
  3. loaded into DB2 for z/OS

This can be done as three discrete steps in a variety of ways.  The problem with three discrete steps is the I/O overhead of landing the data to disk three times: to the local extract file, FTPed to z/OS, loaded into DB2.  In addition, the steps are serial (e.g. the extract must complete before the FTP can begin).

 An alternative is using a cursor-based LOAD (aka the “cross-loader”).  The cross-loader has been available in DB2 for z/OS since v7.

 Steps to enable the cross-loader:

  1. Set up DRDA definitions in the DB2 Communications Database (CDB) in the DB2 for z/OS subsystem that will be running the loads (i.e. the “target”).
  2. Create DB2 for z/OS nicknames for the tables to be loaded from the DB2 for LUW source.

In the example below the table PAOLOR7.DEPT is a nickname.  The LOAD utility jobs can be scheduled to minimize the impact on production workloads.

This would be relatively easy to set up and test in a development environment.   This is the fastest, easiest, simplest way to move the data to z/OS.  This method will also use the least machine resources.


References for cursor-based load

DB2 10 for z/OS Information Center “Loading data by using the cross-loader function

Redbook “Moving Data Across the DB2 Family

Read More…

IBM Champions: Four (and counting…) @ The Fillmore Group

Posted by Frank Fillmore on May 15, 2013 under DB2 Gold Consultants, IBM Champion. Tags: .

Congratulations to longtime colleague, Joe Geller, for being named one of the newest IBM Champions.  Joe currently is deployed at a worldwide Top 50 integrated financial services institution.  Joe is the go-to guy for DB2 for LUW performance tuning for an online banking application.

That brings to four – including Joe – the number of IBM Champions affiliated with The Fillmore Group:

  • TFG Vice President of Business Development Kim May
  • DB2 Gold Consultant and raconteur David Beulke
  • and yours truly

Learn more about the IBM Champion program.


IBM #BigData Announcements – What You Should Know: the Details on BLU, IBM Unlimited License Agreement #IULA and more

Posted by Frank Fillmore on May 13, 2013 under Big Data, BigInsights, BLU Acceleration, Hadoop, IBM Champion, InfoSphere, InfoSphere Streams, Netezza. Tags: , , , , .

IBM Champion Kim May of The Fillmore Group and Warren Heising of IBM deliver the details on “IBM Big Data Announcements – What You Should Know”.  A replay of the May 9th, 2013 webinar can be found here.  The presentation materials can be accessed MA VUG Warren Heising Big Data Announcements 5 9 13

Can the Data Warehouse and #BigData Coexist?

Posted by Frank Fillmore on May 6, 2013 under Big Data, BigInsights, Hadoop, IBM Champion, IBM Pure Systems, InfoSphere Streams. Tags: , , , .

I had the opportunity to chat with Jeff Kelly, Big Data Analyst, at Wikibon.  You can about our discussion on the Silicon Angle blog or view the interview here.

IBM Authorized Training is Evaporating Before Our Eyes

Posted by Frank Fillmore on April 21, 2013 under Authorized Training Partner, Big Data, BigInsights, DB2 Connect, DB2 Education, IBM Mid Market Customers, International DB2 Users Group (IDUG). Tags: .

The Fillmore Group’s (TFG) blog ordinarily is focused on technical topics, but when a potentially disruptive business issue impacts our information management software clients I need to give folks a heads-up.  For 20 years TFG has partnered with IBM to deliver IBM-branded technical training to our mutual customers.  The nature of the business relationship between TFG and IBM that enabled us to deliver that education has changed several times over the past two decades and is changing again in 2013.  Unfortunately the new relationship has yet to be defined while the existing terms and conditions are set to expire at the end of June – in just over two months.

So why does any of this matter to you?  Well if you plan to attend an IBM Information Management training class in the second half of 2013, check out the schedule of courses.  Spoiler alert: there isn’t one.  In years past IBM has requested our public training schedule for the two dozen or so courses we offer at least four months before a new half will begin (e.g. early September of 2012 for classes that will be delivered beginning January 2013).  Between now and the end of June all existing Authorized Training Partners have been asked to arrange new relationships with aggregators engaged by IBM.  What are the new terms and conditions?  No idea.  But the only thing scarier than hearing “I’m from the government and I’m here to help you” is “You’re gonna love this new IBM program” – especially when the program’s details haven’t been publicly shared.

The tuition for most IBM courses runs between $2,000 and $3,000.  Add an additional $1,500 for travel and lodging expenses.  Most IBM training attendees must travel far from home to attend instructor-led classroom training (unlike Oracle and Microsoft customers who can usually find classes at the local training provider – say, a community college – near their homes and businesses).  Sleep in your own bed and don’t miss you kids’ soccer games.  But that’s a rant for another day.

You probably need to get prior budgetary approval for a nearly $5k expenditure and plan the schedule around project deadlines and vacations.  Right now you can’t plan for any classes beyond the end of June – remember, they don’t exist – and there’s no telling when or *if* you will be able to make those plans.  I say *if* because TFG offers the only public schedule in the US for classes on Information Server and the hot, hot, hot BigData technologies of BigInsights and InfoSphere Streams.  If you expect to deploy these technologies in 2013, you might be reading the manual or engaging scarce (and expensive) consulting resources.

So, if this matters to you what can you do?

  • Post a comment on this blog entry.
  • Send an e-mail to your IBM representative and ask “What the heck is going on?”
  • Drop me a Tweet @ffillmorejr and tell me the impact this is having on you and your team: #IMtraining.

IBM Data Strategy 2013: #BigData #BLU and much, much more…

Posted by Frank Fillmore on April 16, 2013 under Big Data, BigInsights, BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Migrations, Hadoop, IBM DB2 Services, IBM Information Management Software Sales, IBM Mid Market Customers, IBM Pure Systems, IBM Smart Analytics System, IDAA, InfoSphere Streams, Netezza, Optim, Oracle, pureScale, Q-Replication. Tags: , , , .

Thank you to all of the customers, colleagues, and IBMers who joined The Fillmore Group on April 11, 2013 at Cinghiale in Baltimore, USA to discuss IBM’s Data Strategy – which we call “DB2 101”.  As it happens, many DB2 customers don’t realize the strength and depth of the IBM Information Management portfolio.  And many non-DB2 customers don’t know about the governance and management tooling available in InfoSphere and Optim (e.g. Guardium) which IBM provides for Oracle, SQL Server, Teradata, and other-vendor database servers.

Prominently featured were the highlights of IBM’s April 3rd announcement held at Almaden Lab which my colleague, Kim May, and I attended.

Also of note is the bundling of functionality in DB2 Advanced Enterprise Server Edition (AESE).

  1. pureScale – shared-disk clustering
  2. Data Partitioning Feature (DPF) – shared-nothing hash partitioning
  3. DB2 for LUW v10.5 columnar compression database

The presentation is available at DB2 101 – IBM Information Management Software Portfolio Overview 2013-04  The audio-video recorded delivery can be viewed here.

Sheryl Larsen is a DB2 for z/OS Evangelist – and an IBMer

Posted by Frank Fillmore on April 16, 2013 under DB2 for z/OS, DB2 Gold Consultants, Information on Demand Conference, International DB2 Users Group (IDUG).

Friend, colleague, and DB2 Gold Consultant Sheryl Larsen is joining IBM on April 22, 2013 and will become the “new Roger Miller” according to an IBM executive.  Best wishes to Sheryl in her new gig!


Separated at birth?