IBM 2019 Replication Updates – 4 in 45 Minutes – Featuring Kafka!

Posted by Kim May on January 8, 2019 under Attunity, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for z/Linux, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, DB2 Stars, Frank Fillmore, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, pureScale, Q-Replication, Replication, TFG Blog, Webinar. Tags: .

Join replication experts Frank Fillmore and Ed Lynch for this information-packed webinar with news and announcements about IBM’s replication solutions. Whether you are a current IBM replication user, investigating replication for a new deployment, or working with a competitor’s solution, this webinar will help you understand what IBM offers today, and the enhancements that will help you succeed with replication in 2019.

At a sprint!

In forty-five minutes Ed and Frank will deliver an overview of IBM’s current offerings, the four most important 2019 enhancement announcements, and 3 special pricing offers that can help your organization realize significant savings. We know you want your data to be available when you need it and where you need it, and fast. We can help.

Registration is required. Please register HERE.

Date: Thursday, 2/7/19

Time: 1:00pm – 2:00pm EST

Presenters:

Frank Fillmore is the Founder and President of The Fillmore Group, Inc., an IBM Business Partner specializing in replication solutions in the IBM Analytics portfolio. Frank has been a Db2 Gold Consultant since 1998 and is currently an IBM Champion for both Analytics and System z. Frank frequently presents on cutting-edge topics at regional and international Db2 Users Group meetings and is an IBM authorized instructor for delivery of replication courses including Q Replication, ICDC and pureScale. Frank leads a team of expert consultants delivering presales, implementation and enablement support to IBM customers. Frank is currently supporting a pureScale implementation for a US Federal agency.

Ed Lynch was with IBM for over 25 years as a leader and innovator in Data Analytics and Information Integration.  Leveraging his balanced and diversified knowledge of data and Information Technology with business needs and capabilities, Ed consistently recommends and delivers best of breed technical solutions. A trusted advisor to his customers and colleagues, Ed’s cross-industry knowledge enables him to be an effective go-to resource, particularly for difficult and complex challenges, and his success in many diverse roles at IBM, including development, technical team management, marketing and sales, showcase his flexibility. Ed is currently supporting a complex replication implementation for a large, US-based financial institution.

SQL to Aid #Db2 for z/OS EBCDIC to Db2 for LUW Unicode Conversion #IBMAnalytics #IBMz

Posted by Frank Fillmore on January 2, 2019 under DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Gold Consultants, IBM Champion. Tags: , , , .

Dr. Sheldon Cooper of “The Big Bang Theory” regularly records a YouTube video called “Fun with Flags” so I’m going to call this blog post “Fun with SQL”.  Sheldon may be a future Nobel Prize winner, but I’ve been named an IBM Champion for Analytics and System z for 2019. 🙂

The problem statement: a large US government agency is contemplating migrating a packaged application from System z to Linux.  The current and future database repositories are Db2 for z/OS and Db2 for LUW respectively.  As a System z Champion I’ve presented on the continued relevancy and efficacy of the IBM mainframe, but that’s not the focus of this post.  One of the challenges of porting data is the conversion of character encoding from EBCDIC (Extended Binary Coded Decimal Interchange Code) which is the legacy encoding protocol used on IBM mainframes and System i to Unicode.  Db2 for z/OS supports Unicode, but I’m not going to address anything other than EBCDIC encoding at the source and Unicode at the target (Sorry, ASCII).  In brief, EBCDIC represents an 8 bit binary encoding scheme that can represent 256 different characters.  For example: the letter “F” (one of my faves) is represented as 1100 0110 in binary and C6 in hexadecimal. For national language support amid the variety of Single Byte Character Sets (SBCS) used around the world – think the German umlaut (i.e. ä ö ü) – the 256 byte universe of EBCDIC wasn’t nearly enough.  The Unicode solution is to use more than 1 byte to represent some characters.  For example: the “¢” cent sign takes one byte to represent in EBCDIC, but 2 bytes in Unicode.

select length(ebcdic_str('¢')) as EBCDIC, length(unicode_str('¢')) as Unicode from sysibm.sysdummy1;
EBCDIC    UNICODE

     1          2

This problem has manifested itself as an error when moving a CHAR(5) column of data from Db2 for z/OS to Db2 for LUW.  If, say, the pesky “¢” is present in the string and all 5 characters are significant (i.e. no trailing blanks), the string won’t fit in the same column width on the target platform.  Most customers find this out the hard way when the Db2 for LUW LOAD command or IMPORT utility posts errors.  There are two possible solutions:

  • data cleanup (Do we really need the pesky ‘¢’ in a Comments column?)
  • lengthen the target columns to accommodate Unicode expansion

Both can be time-consuming and expensive and will depend on a variety of factors beyond the scope of this blog post.  The purpose here today is to identify the extent of the problem before you actually try to port the data.  I’ve constructed this SQL statement to do just that. Read More…

IDUG Call for Speakers Open Until October 19th

Posted by Kim May on September 24, 2018 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for z/Linux, DB2 for z/OS, DB2 Migrations, International DB2 Users Group (IDUG), Oracle, pureScale, TFG Blog.

 

The Call for Speakers for the 2019 IDUG North America Conference, scheduled for Charlotte, NC, from June 2 – 6, 2019, is open.  For Db2 users this is an excellent opportunity to share your experience with your peers.  IDUG has a well documented presentation submission format and process, detailed on the IDUG North America webpage.

You may submit an unlimited number of abstracts.  However, it is important that you provide all of the information requested when submitting your presentation(s) for review. Failure to provide all requested information may impact whether or not the abstract is accepted.

One last note:  given the timing, don’t forget to reach out to your local Db2 RUG and offer to deliver your presentation at one of their meetings prior to the conference.  It’s a great opportunity to do a practice run, and also allow your local peers – some of whom may not be attending the conference – to appreciate your work.

From the IDUG webpage:

IDUG is soliciting presentation abstracts that explore into details of implementation, migrating to a new release, or maximizing performance from any member of the DB2 product family. In recognition of the complex requirements of today’s database implementations, presentation abstracts relating to migration from Oracle to DB2, upgrading within versions of DB2, and new hardware implementations are also being requested. Presentations may cover details of DB2 tools, Big Data and other ancillary DB2 products.

All presentations must be strongly technical in nature, cannot contain marketing themes, and must support and strengthen the information services community by providing the highest quality education and services designed to promote the effective utilization of the DB2 and its family of products.”

 

Fixed Price Private Classes – Do I Need to Add Pizza?

Posted by Kim May on January 5, 2015 under Arrow ECS, Authorized Training Partner, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, Global Skills Initiative, pureScale, TFG Blog.

Beginning this month The Fillmore Group will be offering fixed price private IBM Information Management training classes to customers located in the US and Canada, making it easier for customers to budget for critical IM education.  Our team recognizes the value of technical training – and we understand the challenges IBM Information Management customers are facing with the array of offerings generated by the Global Skills Initiative.  I am hoping that by offering fixed priced IM education and simplifying the pricing aspect of training procurement, customers will be encouraged to pursue training to support new and existing IM solution implementations.

The fixed prices below include IBM authorized curriculum, IBM remote eLab access, travel and lodging for the instructor, and course delivery by one of our experienced instructors.  Do I need to add pizza to get you to bite??

There IS of course some “fine print”:  1) the prices below are for IBM Information Management courses only (320 current courses are available; you can sort through them at http://tinyurl.com/IM2015courses or contact me for assistance identifying the appropriate course based on your needs), 2) courses must be delivered in the US or Canada, in English, within one mutually agreed upon, contiguous calendar week.  3) The purchasing customer must provide a training facility equipped with one computer for each student, and high-speed Internet access.

The fixed prices are:

Course Length                 1-3 Students                    4-6 Students

3 days                                  $9,900                             $11,900

4 days                                 $13,900                            $15,900

Please let me know (email me at kim.may@thefillmoregroup.com) if I can help you with any questions or private class coordination.  Thanks!

 

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.

 

IBM InfoSphere Data Replication (IIDR)

Posted by Frank Fillmore on April 10, 2013 under DB2 for i, DB2 for Linux Unix Windows, DB2 for z/OS, IBM Information Management Software Sales, Information on Demand Conference, InfoSphere, Q-Replication. Tags: , , .

IBM has bundled its replication technology into a single package: IBM InfoSphere Data Replication (IIDR).  IIDR combines three components:

  • SQL Replication (heritage DataPropagator- Relational)
    • Easy to set up
    • Staging tables
  • InfoSphere Replication Server (IRS – heritage Q Replication)
    • High volume, low latency
    • Native Oracle and DB2 sources and targets
    • WebSphere MQ transport layer
  • InfoSphere Change Data Capture (ICDC – heritage DataMirror)
    • Broadest set of heterogeneous sources and targets
    • TCP/IP transport layer

There are a few of important take-aways.

  1. IBM substituted an implementation decision for a buying decision.  For quite a while SQL Replication was bundled free with DB2 for LUW.  ICDC and IRS were separately purchasable technologies with a lot of functional overlap.  In 2010 my colleague, Kim May, delivered an IBM Information on Demand (IOD) presentation distinguishing between the three.  Now you purchase the IIDR bundle and determine which technology is best suited for a particular use case.  As with most IBM software on distributed platforms, the cost is based on Processor Value Units (PVUs).
  2. New feature/functionality will be built into IIDR rather than the former heritage ICDC and IRS packaging.
  3. There will be a convergence of the technologies over time.  Many of the prospective changes are still IBM Confidential, but IBM is looking to consolidate components where it makes sense to do so.  There is a long-term roadmap that I hope IBM be sharing shortly.
  4. Upgrading and migration paths are a work-in-progress.  If you currently own ICDC or IRS and want to move up to IIDR, contact The Fillmore Group for pricing and implementation assistance.

DB2 101 Luncheon at Cinghiale April 11th

Posted by Kim May on February 28, 2013 under Big Data, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Frank Fillmore, IBM Information Management Software Sales, IBM Mid Market Customers, IBM Pure Systems, InfoSphere, Netezza, Optim, Oracle. Tags: , , , , , .

As volumes of data explode and organizations look for unique ways to leverage the quantities of data – often in real-time – it’s easy to become confused.  We can help – join us for lunch at Cinghiale for an overview of the data management products in the IBM portfolio and gain an understanding of today’s top solutions.

Frank Fillmore will deliver an overview of hot topics in IBM data management:  Big Data, Information Governance, and appliances, and explain how new solutions are changing database and warehousing technologies.  Gain an understanding of how IBM’s acquisitions and integrated solutions have them positioned as today’s thought leader in data management.

DB2101 at Cinghiale (the “Boar”), 822 Lancaster Street, Baltimore, MD, 21202
April 11, 2013, 11am – 1pm

To register, click here.  

Satisfy your appetite and your curiosity with a tasty Italian lunch at local favorites Tony Foreman and Cindy Wolf’s Cinghiale. Whether you already use IBM data products or are interested in learning what IBM has to offer, the presentation will provide a dose of nutritious food for thought.

I will send you a confirmation with directions to the award winning Cinghiale.  Valet parking will be provided.

IBM Information Management Software Portfolio Overview

Posted by Frank Fillmore on April 5, 2012 under DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Migrations, IBM Smart Analytics System, Informix, InfoSphere, Netezza, Optim, Q-Replication. Tags: , , , .

The recording of April 5, 2012 webinar “IBM 2012 Information Management Product Strategy and Portfolio Overview” is located here.

The presentation materials: DB2 101 – IBM Information Management Software Portfolio Overview

DB2 101 Webinar – IBM Information Management Portfolio Review

Posted by Kim May on March 26, 2012 under Authorized Training Partner, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Frank Fillmore, IBM Champion, Netezza, Optim. Tags: , , , , , , , , .

Frank delivered a terrific summary of the products in the Information Management portfolio at a lunch event at Baltimore’s Cinghiale restaurant earlier this month.  Unfortunately, we can’t offer everyone lunch (sorry!) but we will offer a repeat presentation via webinar on April 5th.  The invitation and registration information are below and the complete session abstract and Frank’s bio can be accessed by clicking ” Read More”.  Please share this event with anyone who may be interested in learning more about what IBM has to offer – it’s packed with great information.

Thursday, April 5, 2012, 3:00pm – 4:00pm EDT    Register here.  Read More…

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…