#IBM #TechXchange 2025 Starts in 3 Days!

Posted by Frank Fillmore on October 2, 2025 under DB2 for i, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Migrations, InfoSphere, Oracle, PostgreSQL, Q-Replication, Replication.

IBM’s premier technical conference TechXchange kicks off in Orlando, FL in 3 days! These are the things I’m looking forward to the most:

All things IBM replication with previews into what’s coming next and an open discussion with your peer-practitioners. I’ll be moderating the latter.

I’ll be presenting real client case studies of IBM InfoSphere Data Replication (IIDR) implementations on a variety of platforms across multiple different industries – successes… as well as pitfalls to avoid.

Safe travels to Orlando. Hope to see you there!

 

TFG Vends IBM Software License Entitlement + Professional Services + Training on AWS Marketplace

Posted by Frank Fillmore on July 31, 2024 under Authorized Training Partner, DB2 for Linux Unix Windows, DB2 for z/Linux, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Federation, IBM Champion, IBM DB2 Services, IBM Mid Market Customers, IBM Training Services Delivery Partner, IDAA, Netezza, PostgreSQL, pureScale, Q-Replication. Tags: , , , , , , , , , , , , , .

I’m pleased to announce The Fillmore Group’s IBM Data & AI Software Professional Services Product is live on AWS Marketplace (MP).

This is a one-stop shop for:

  1. IBM Data & AI software license entitlement
  2. Professional services delivered by a team that includes IBM Gold Consultants and IBM Champions among its members
    • Installation, implementation, and version upgrade
    • Optimization, healthcheck, and performance tuning
    • Backup/Recovery and High Availability/Disaster Recovery
  3. Instructor-led training with hands-on Lab Exercises for all of these technologies

That’s the technology. Now let’s focus on the financial advantages.

  • By purchasing any or all of this on AWS MP you help retire AWS spend obligations.
  • By leveraging the AWS Migration Acceleration Program (MAP) you can reduce the up-front out-of-pocket cost of moving workloads to AWS.

Click on this link to obtain all of these benefits: https://aws.amazon.com/marketplace/pp/prodview-aczcrfki56v3m

IBM Data Replication Offerings 2020: In a Nutshell

Posted by Frank Fillmore on August 12, 2020 under Authorized Training Partner, DB2 for Linux Unix Windows, DB2 for z/OS, IBM DB2 Services, InfoSphere, Netezza, Oracle, PostgreSQL, Q-Replication, Replication.

IBM Data Replication 2020: In a Nutshell

IBM replication is based on two unique technical solutions: InfoSphere Change Data Capture, the heritage DataMirror product, and Q-Replication, the IBM-developed replication solution that uses MQ messaging.

IBM replication supports numerous sources and targets. For heterogeneous environments, that is, where either the source or target are not Db2, IBM recommends InfoSphere Change Data Capture. For Db2 to Db2 replication, IBM recommends Q Replication.

The currently available sources are targets are below. New offerings are always being added; for a current list visit the IBM replication homepage.

New offering highlight: Mainframe replication for Db2 for z and VSAM featuring “Remote Capture”, with the replication engine installed off the mainframe. The new solution delivers easier installation and administration as well as lower MIPs consumption to support replication from System z.

Coming soon: Refreshed monitoring tools built on Watson Knowledge Catalog, enabling expanded governance and integration with replication monitoring.

Implementation support, healthchecks and education:  Contact The Fillmore Group. We have several Quickstart offerings and have been delivering the IBM replication education offerings for decades.

Replication Sources: Db2 (LUW, Z/OS, iSeries), Oracle, SQL Server, PostgreSQL, VSAM, IMS, Informix, Sybase, MySQL.

Replication Targets: All above RDBMSs plus Teradata, Kafka, Hadoop, Files, Information Server (DataStage/QualityStage), Cloudant, AWS RedShift, S3, Azure SQL DB, JDBC targets (MongoDb, etc.), IBM IAS/ Db2WH/Db2WHoC, Netezza/Cloud Pak 4 Data System, and more.

Remote Capture Quickstart

Postgres Capture Quickstart

Kafka Replication Quickstart

Support IBM Replication – Vote for RFE QREP-I-216

Posted by Frank Fillmore on August 4, 2020 under DB2 for z/OS, Q-Replication, Replication, TFG Blog.

The IBM Request for Enhancement (RFE) system has been moved from developerWorks to the IBM Data & AI Ideas portal.

Each “idea” submitted can be voted on by users who log in. The number of votes for each particular request is taken into consideration by the IBM Product Development teams when they are planning product enhancements. More votes = higher probability of getting the request fulfilled.

I am reaching out to ask IBM Data & AI solutions users to vote for an existing RFE in the Ideas system, QREP-I-216. This is a replication enhancement to IBM’s Q Replication, for customers using the Oracle QApply.

The Oracle QApply was developed several years ago when IBM was planning to merge Q Replication and InfoSphere Change Data Capture. It enabled customers to replicate from Db2 for z/OS to Oracle without adding a layer of federation (the old method of applying changes to heterogeneous databases).

The user requesting the request has had Q Replication with QApply in production for several years and is asking to have replication monitoring improved.

If you haven’t logged on the Ideas portal, it’s easy, and the homepage gives you access to the enhancement requests as well as each solution roadmap.

For this particular RFE, log in here and click on the button on the left side of the screen to vote.

Thanks for voting!!

https://ibm-data-and-ai.ideas.aha.io/ideas/QREP-I-216

 

 

 

 

 

“45 Minutes to Understand #IBM #Replication – Sources & Targets, Lower Latency, Costs” Recording and Materials

Posted by Frank Fillmore on May 3, 2020 under Attunity, DB2 for i, DB2 for Linux Unix Windows, DB2 for z/Linux, DB2 for z/OS, DB2 Migrations, IBM DB2 Services, InfoSphere, PostgreSQL, Q-Replication, Replication, Webinar. Tags: , , , , , , , , , , , , .

Over 180 folks attended the “45 Minutes to Understand IBM Replication – Sources & Targets, Lower Latency, Costs” webinar on April 30, 2020 hosted by my colleague @KimMayTFG and me.  Thank you for joining us – along with the excellent questions and feedback.

These are the presentation materials IBM Data Replication Update 2020-04-30

You’ll find the recording of the webinar here.

Replication Webinar Thursday – Please Join Us!

Posted by Frank Fillmore on April 27, 2020 under Data and AI Expert Labs and Learning, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/Linux, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, Q-Replication, Replication, TFG Blog.

This Thursday, April 30th, join Frank Fillmore for a fast, information-packed webinar, loaded with IBM replication solution information for both non-IBM and IBM replication customers.  Come join us and learn!  Details and the registration link are in the post below.

IBM Replication: Competitive Webinar April 30th – Register Now!

Posted by Frank Fillmore on March 4, 2020 under DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Frank Fillmore, IBM Champion, IBM DB2 Services, pureScale, Q-Replication, Replication, TFG Blog.

Please join us for a webinar Thursday, April 30th, on IBM replication:

45 Minutes to Understand IBM Replication – Sources & Targets, Lower Latency, Costs  

The webinar is intended for technical teams currently not using IBM replication solutions, although the webinar content will provide an excellent overview of IBM’s current offerings – an excellent refresher and update for IBM replication customers.  Hey, it’s a webinar – anyone can attend!!

Abstract:  Technical organizations rely on replication to deliver accurate data when its needed. IBM replication supports an extensive list of sources and targets – including legacy mainframe data repositories – as well as best of breed deployment models and specialty replication solutions.

If your organization is considering a new replication deployment or looking to replace your existing replication to extend functionality – or reduce cost – please join IBM Gold Consultant Frank C. Fillmore, Jr., for a webinar overview of IBM’s replication offerings.

The webinar will cover:

1. The sources and targets supported by IBM replication.
2. Each solution available today, and their costs.
3. Latency, deployment and administrative considerations.

Date:          Thursday, 4/30/2020

Time:          11:00am – 12:00pm EDT

Register HERE 

Presenter:  Frank Fillmore

Frank C. Fillmore, Jr. is the Founder and President of The Fillmore Group, Inc., an IBM Business Partner specializing in replication solutions in the IBM Data and 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 user 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 replication customers.

Want to learn more about the Gold Consultants?  Visit the IBM Gold webpage HERE.

 

Fall Class Highlights

Posted by Frank Fillmore on September 18, 2019 under Authorized Training Partner, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 Migrations, Global Skills Initiative, IBM Training Services Delivery Partner, pureScale, Q-Replication, TFG Blog.

Learn new Db2 skills and help your organization leverage the best features and functionality available in the Db2 product family.  The classes below are our Fall, 2019 top picks!
 
Virtual and in-classroom options are available.  For registration email Kim May.
—-
10/7 – 10/9 Db2 pureScale Implementation and Management.  Prepare for planning, installing, managing and monitoring a DB2 pureScale database system.  Cost:  $2325.  View the course outline below.
—-
10/10 – 10/12 Db2 BLU Acceleration Implementation and Use.  Learn the concepts and facilities of BLU Acceleration including loading data into column-organized tables and monitoring the processing of SQL statements that access the tables.  Cost:  $1550.
—-
10/15 – 10/17 Change Data Capture Essentials.  Learn the architecture, components and capabilities of CDC, day-to-day operations, monitoring and troubleshooting.  Cost:  $2775.
—-
10/21 – 10/23 Db2 LUW – and IAS! – Database Administration Workshop.   The Fillmore Group’s Db2 DBA fundamentals course, authored by our consultants and trainers, and delived to hundreds of Db2 users.  Cost:  $1800.
—-
10/28 – 10/31 Q Replication Workshop.  Learn the architecture, components and capabilities of Q Replication, day-to-day operations, monitoring and troubleshooting.  Cost:  $2400.

—-

Through a partnership with TechData one of IBM’s select global training providers, The Fillmore Group delivers authorized training for the design, installation, maintenance, and troubleshooting of IBM Analytics solutions. This partnership allows The Fillmore Group to leverage the award winning IBM technical training content that is exclusive to IBM’s global training providers.

IBM Replication Featured at Upcoming Baltimore/Washington Db2 Users Group

Posted by Frank Fillmore on August 28, 2019 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for z/OS, DB2 Migrations, PostgreSQL, Q-Replication, Replication, TFG Blog.

IBM is hosting the September meeting of the Baltimore/Washington Db2 Users Group to be held at the BWI Hilton on Wednesday, September 11th.  IBM’s Kenishia Sapp and Anthony Ciabattoni will be presenting on Db2 for z/OS topics (see agenda below) and *drum roll!* IBM Replication Product Offering Manager Davendra Paltoo will be presenting on IBM’s recent replication enhancements and new offerings.

With the recent Gartner report validating IBM’s market position in their “magic quadrant” with IBM’s offerings supporting a broad range of replication sources and targets (including Postgres and Kafka), and the increased focus on making data accurate and available for analytics, it’s important to understand what IBM is delivering to customers today.

If you are in the Baltimore/Washington area I hope you will join us for the meeting and the opportunity to talk replication with Davendra.

The full agenda is below.  Registration is required – please register on the Baltimore/Washington Db2 Users Group website HERE.

Date:  Wednesday, September 11, 2019

Time:  9:00am – 3:30pm (registration open at 8:30am)

Location:  BWI Hilton, 1739 W Nursery Road, Linthicum Heights, MD  21090

Agenda:

9:00am – 10:15am   APIs: A Pathway to the Modern Enterprise, Kenishia Sapp, IBM NA z API Swat Team

As Enterprises begin their modernization journeys, REST and the API economy are integral elements of their roadmaps. There are many ways to achieve the goal of REST API enablement for the mainframe, and it can be hard to distinguish the benefits and unique value points among them. Kenishia Callaway will illustrate how solutions such as z/OS Connect, API Connect and others can be used to modernize while retaining the well-developed systems that differentiate company value.

10:30am – 11:45am  Db2 for z/OS Native RESTful Experience, Anthony Ciabattoni, IBM Db2 zOS Development SWAT Team

IBM Db2 for z/OS is still the undisputed leader for storing and maintaining mission critical data. It remains the “gold standard” for system availability, scalability, security and cost effectiveness. A majority of Fortune 500 companies, including the world’s top banks, retailers and insurance providers trust Db2 for z/OS for storing their data. In addition, Db2 for z/OS continues to invest in industry leading easy to access, efficient and cost effective data access capabilities while maintain our mainframe heritage.This session will show how Db2 REST services allow modern applications to access and consume Db2 data and to reuse existing SQL statements and stored procedures. We will present how they are easily deployed, managed and also promote the rapid/agile development and deployment of new applications that are mobile friendly.

12:45pm – 2:00pm  Db2 12 experiences from the field, recipe for successful migrations, FTB’s & Insert Algorithm 2, Anthony Ciabattoni

Migrating to Db2 12 and exploiting and taking advantage of new features and functions needs to be planned, prepared and executed to maintain availability and achieve organizational success. This session will go through the recipe of a successful Db2 migration, what can be completed prior to the migration window and what steps actual customers have made to achieve a successful migration. In addition, Fast Traversal Blocks and Insert Algorithm 2 are two of the most popular new features in Db2 12. During the session these two features will be described in detail along with the appropriate use cases for both technologies. Lastly, real life customer behavior, experiences and implementation successes will be discussed. If you are an organization that is in the process of migrating to Db2 12 or are planning for a Db2 12 migration before Db2 11 End of Service this is a must attend session.

2:15pm – 3:30pm Delivering a Real-time Experience for Dynamic Digital Businesses, Davendra Paltoo, Replication Offering Manager

Learn how organizations use IBM Data Replication to deliver near real time data across the enterprise from Db2 and most other major databases. IBM Data Replication key capabilities and plans will also be covered.