Finding the DB2 Mid Market – First of a Series

Posted by Kim May on March 13, 2012 under DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Migrations, IBM DB2 Services, TFG Blog. Tags: , , .

I decided to blog on my efforts to get engaged with Mid Market Information Management customers in 2012, as IBM is encouraging Business Partners like The Fillmore Group to support the Mid Market while they focus on larger accounts.  IBM is a huge organization, and as seems natural, they like to work with other huge organizations.  As demonstrated by the success of that 35-year-old tech start-up from Redmond, small and mid-sized businesses often grow, and share their growth with their vendors.  However, IBM is opting to stay focused on their core – integrated and aligned and named accounts – and delegating Mid Market customer support to Business Partners.

Makes sense, right?  Sure!  So then next…what if you are an IBM Business Partner that WANTS to work with Mid Market Information Management customers?  What if you are a Mid Market IBM Information Management customer that WANTS to work with a Business Partner?  How do you find each other?  How do you determine if you have the right chemistry?  It’s not easy. Read More…

Replication Webcast Materials

Posted by Kim May on February 23, 2012 under DB2 for i, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Frank Fillmore, IBM Champion, IBM DB2 Services, Q-Replication. Tags: , , , .

For those of you attending (or that attended) Frank’s webinar on the new replication part number and consolidation, the presentation file and the questionnaire referenced in the presentation are attached.  I hope you find these valuable.  Please feel free to contact me (kim.may@thefillmoregroup.com) or Frank (frank.fillmore@thefillmoregroup.com) with questions.

Webcast recording

Changes and Choices Replication Presentation – Final

Replication Customer Questionnaire – Revised 2012-02-22

IBM Data Strategy Luncheon

Posted by Kim May on February 13, 2012 under Baltimore Washington DB2 Users Group, DB2 Connect, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, Frank Fillmore, IBM Champion, Netezza, Optim, Oracle, Q-Replication. Tags: , , , , , , , , .

In 2011, Information Management was IBM’s largest software product family, based on worldwide sales.  What does IBM have that you should know about?  Join us in the beautiful Patrizio dining room at Baltimore’s award winning Cinghiale Italian restaurant on March 8th to find out.

DB2 Gold Consultant and IBM Champion Frank Fillmore will deliver a presentation on IBM’s 2012 Information Management product portfolio, including background on IBM’s recent acquisitions and information integration and data governance strategies.  Learn how IBM has accumulated and integrated data solutions to position themselves as the thought leader in information management.

Whether you already use IBM data products or are interested in finding out what IBM has to offer, the presentation will provide a dose of nutritious food for thought.

To register, click here.   We will send you a confirmation with directions to Cinghiale.  Valet parking will be provided.  We look forward to seeing you there!

Webinar: InfoSphere Replication: Changes and Choices

Posted by Kim May on January 16, 2012 under DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Frank Fillmore, IBM Champion, IBM DB2 Services, Q-Replication, TFG Blog. Tags: , , , , , , , .

Please join us for a webinar Thursday, February 23, 2012, at noon Eastern.  To register, click here

IBM is merging replication offerings with the announcement of the IBM InfoSphere Data Replication V10.1.2 package.  The new Data Replication package updates and consolidates InfoSphere Data Replication, InfoSphere Change Data Capture, InfoSphere Change Data Delivery, and InfoSphere Change Data Delivery for Information Server into a single offering, giving replication users considerable flexibility in making a choice of a data replication solution.   In this session Frank will explain what the consolidation means to customers evaluating a replication technology and make recommendations to ensure your organization makes the right choice to address your business needs. Read More…

DB2 for System i (iSeries, AS/400)

Posted by Frank Fillmore on June 9, 2011 under DB2 Connect, DB2 for i. Tags: , , , .

Jim Tonchick had this recent post on DB2-L in response to a query from Dan Luksetich regarding DB2 for iSeries:

>> Yep, we’re out here.  But this forum is mostly for z/OS and LUW.  There are some iSeries forums, but DB2 is not the main focus. 

>> DB2 for iSeries is IBM’s best kept secret.  Every iSeries lpar has DB2 by default.  It comes with the operating system as the default file manager.  Even though it is on every instance of the i5 operating system, it is not covered by IBM at the OnDemand Conference or at IDUG’s conferences.  Even the IBM’s DB2 Family web site does not mention it (http://www-01.ibm.com/software/data/db2/).  You have to do to the IBM System i software path to find it (http://www-03.ibm.com/systems/i/software/db2/).  That’s a shame because DB2 for iSeries fits into the the DB2 family very well and can be a part of a distributed DRDA based application.

>> I attended IDUG NA 2011 in May and asked around why DB2 for iSeries was not even mentioned let alone represented.  The answers I received ranged from “not our target market” to “DB2 runs on the iSeries?”.  I’m glad to see someone in the industry finally take notice.

I agree that this member of the DB2 “family” is neglected.  For those of you who have been attending the DB2 Connect Virtual Users Group, DB2 Connect enables Distributed Relational Database Architecture (DRDA) between System i and DB2 for Linux, Unix, Windows because System i is EBCDIC-based (as is z/OS).

There’s a great manual for explaining the duality (split personality?) of DB2 for System i: “DB2 Universal Database for iSeries Database Performance and Query Optimization”.  It discusses the legacy Classic Query Engine (CQE) as well as the more-DB2-like SQL Query Engine (SQE).

There are also Redbooks

  • “OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4” (SG24-7326)
  • “SQL Performance Diagnosis on IBM DB2 Universal Database for iSeries” (SG24-6654)
  • “Preparing for and Tuning the SQL Query Engine on DB2 for i5/OS” (SG24-6598)

Finally there’s “SQL Reference for Cross-Platform Development” which takes the place of FREDS (Formal Register of Existing Differences of SQL – believe it or not!).  This manual compares the SQL dialects for

  1. Version 9 of DB2 for z/OS
  2. Version 6.1 of DB2 for IBM i
  3. Version 9.5 of DB2 for the Linux, UNIX and Windows Platforms

Free Your Data…Without Breaking the Bank!

Posted by Kim May on February 21, 2011 under Attunity, DB2 for i, DB2 for Linux Unix Windows, DB2 for z/OS, TFG Blog. Tags: , , , .

Affordable IBM Mainframe & DB2 Data Integration

Live Webinar Thursday, February 24th from 12:30pm – 1:30pm EST

Register today to learn how you can accomplish efficient and affordable IBM mainframe or DB2 data integration in a heterogeneous environment for BI, reporting, MDM, DW, and more.  The session will conclude with a live product demo and Q&A session.

Read More…

DB2 101 Sessions Announced

Posted by Kim May on February 1, 2011 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Migrations, IBM DB2 Services, Optim, Oracle, Q-Replication. Tags: , , , , , .

The Fillmore Group will be hosting three sessions of what we are calling, “DB2 101” – sessions that provide an executive overview of the IBM Information Management product portfolio, one each month, in February, March and April.  We have selected three restaurants close to our Baltimore headquarters – 2 in Baltimore and 1 in Columbia, Maryland (about halfway between Baltimore and Washington, DC).  The purpose of each session is to bring attendees up to date on IBM’s Information Management product portfolio (an expanding target), and strategy. Read More…

Virtual Users Group “DB2 Connect: History, Today’s Functionality, and What’s Next”

Posted by Frank Fillmore on December 14, 2010 under DB2 Connect, DB2 Education, DB2 for i, DB2 for VSE&VM, DB2 for z/OS, International DB2 Users Group (IDUG). Tags: , .

Curt Cotner presents DB2 Connect from a technical, historical perspective.  In his presentation Curt explains how DB2 Connect evolved as a technical solution, describes the changes to DB2 Connect and why organizations should consider eliminating the gateway.  Curt looks at what the future holds for DB2 Connect.  Curt covers best practices for moving from three-tier DB2 Connect topology using a gateway to the recommended two-tier architecture so attendees can begin to figure out how to get their organization from here to there.

db2-connect-history-dec-2010

Also, we would like to thank everyone for volunteering.  We are hoping to have three meetings a year and will be posting them through the IDUG website.  A special thanks to Michael McBride for all of this assistance with the website.

Please feel free to invite your friends and colleagues to join the Virtual Users Group!  Contact Blaire Crowley at blaire.crowley@thefillmoregroup.com for details.

DB2 Connect Virtual Users Group Inaugural Meeting on December 14

Posted by Frank Fillmore on November 24, 2010 under DB2 Connect, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, International DB2 Users Group (IDUG). Tags: , .

“DB2 Connect, History, Today’s Functionality, and What’s Next”

Tuesday, December 14, 2010 from 11:30 a.m. to 1:00 p.m. (US) Eastern Standard Time

IBM Fellow Curt Cotner will present DB2 Connect from a technical, historical perspective.  In his presentation Curt will explain how DB2 Connect evolved as a technical solution, describe the changes to DB2 Connect and why organizations should consider eliminating the gateway.  Curt will finish the presentation with a look at what the future holds for DB2 Connect.  Curt will cover best practices for moving from three-tier DB2 Connect topology using a gateway to the recommended two-tier architecture so attendees can begin to figure out how to get their organization from here to there.

The presentation will be delivered online via GoToWebinar.  Click here to register.

DB2 Connect Virtual Users Group

Posted by Kim May on September 26, 2010 under DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for z/OS, International DB2 Users Group (IDUG), Uncategorized. Tags: , , .

The Fillmore Group is coordinating the startup of a virtual users group of DB2 Connect users.  We are actively seeking DB2 Connect users to participate – as members, as board members, and as presenters.  We hope to have a volunteer board meet periodically and have one to two hour sessions delivered via Webex to all members quarterly.  All of this will be handled virtually, with an opt-in email contact list providing event notification to members, and an affiliated IDUG group to provide interim communication between members. 

I am planning to attend the IOD Conference and will host a meeting on Monday, October 25th, for anyone volunteering to participate as a board member.  My colleague Blaire Crowley at The Fillmore Group is working with Michael McBride at IDUG to establish the IDUG group and to collect member, board member and speaker volunteer names.  On the 25th we will have board member volunteers attending IOD get together and share a conference call with remote volunteers to work through a schedule of events for late 2010 and 2011.

The virtual users group will initially operate independent of IBM and IDUG.  Kevin Foster and Kimberly Madia on the IBM DB2 Connect team have offered assistance with speakers. 

If you are interested in joining please email Blaire Crowley at blaire.crowley@thefillmoregroup.com.  Blaire will send you instructions on joining the IDUG group and add you to the list of members.  Please (please!) let Blaire know if you would like to volunteer.